Data Product Engineer II

We are seeking a highly skilled and innovative Data Engineer II to lead the design, development, and optimization of scalable data products that drive analytics, reporting, and machine learning across the organization. This role requires strong knowledge of advanced data engineering capabilities, strategic product thinking, and an ability to advise and collaborate across teams. You will work with internal and external partners and play a key role in shaping the data architecture and governance standards that support enterprise-wide decision-making.

You will also integrate AI capabilities where they make sense using Azure OpenAI and Azure AI Foundry, building Lang Chain‑based components, and applying prompt engineering to ship practical AI features (RAG, assistants, smart tools).

• Lead the design, development, and deployment of complex data products and pipelines to support advanced analytics and business intelligence.
• Conduct routine and ad hoc complex data extractions, transformations, and analyses to support strategic initiatives.
• Develop and implement standard operating procedures to ensure compliance with licensing, legal, and ethical requirements
• Collaborate with cross-functional teams to translate business needs into scalable, high‑performance data solutions.
• Lead initiatives to implement curated datasets and reusable data assets.
• Optimize and manage data models for performance, reliability, and scalability across multiple platforms.
• Create and maintain advanced Tableau dashboards and visualizations, ensuring alignment with business goals.
• Document and communicate technical architecture, data flows, and product features for diverse audiences.
• Manage user permissions, access controls, and platform security to ensure data products are protected and compliant with organizational policies.
• Contribute to the data product roadmap, prioritizing features based on user feedback and business impact.
• Stay current with BI best practices and emerging technologies, including AI technologies
• Perform prompt engineering to improve accuracy, relevance, and efficiency of generative AI tools.
• Provide technical leadership and mentorship to junior data engineers and analysts.
• Ensure that data sets are high‑performing, efficient, organized, and reliable, given a specific set of business requirements and constraints.
• Facilitate secure storage and transfer of prepared datasets to external and internal partners
• Serve as a subject matter expert and technical advisor across departments.
• Develop and maintain database and dashboard applications for monitoring measures by Care Quest Institute staff.
• Continuously evaluate and improve existing data infrastructure and processes.
• Perform new and existing set‑up and maintenance processes
• Other duties as needed or required.

• Bachelor’s degree in data science, computer science, informatics, public health, or similar field
• 5+ years of experience in data analytics and dashboard development
• 5+ years of experience with SQL programming and Databricks
• 3+ years of experience developing and maintaining data products
• Proficiency in Relational Databases (SQL Server preferred) data visualization (Tableau and/or Power
  
  BI)
• Experience integrating LLMs into applications using Azure OpenAI and/or Azure AI Foundry.
• Exposure to Lang Chain (or similar frameworks) for building LLM workflows such as RAG or tool‑using agents.
• Working knowledge of prompt engineering approaches (system prompts, few‑shot, structured output, guardrails).
• Understanding of AI limitations: hallucinations, safety risks, and strategies to mitigate them in production.
• Experience with vector stores or search services (e.g., Azure AI Search) for retrieval‑augmented generation.
• Strong understanding of data architecture, modeling techniques, and governance frameworks.
• Demonstrated ability to handle multiple projects in a fast‑paced, results‑driven environment.
• Superior written and verbal communication skills to ensure that the messages are received and understood both up and down within stakeholders’ organizations.

• Master’s degree in data science, computer science, informatics, public health, or similar…