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).
Primary Job Responsibilities

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 CareQuest 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.
Required
JOB QUALIFICATIONS:

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 PowerBI)
Experience integrating LLMs into applications using Azure OpenAI and/or Azure AI Foundry.
Exposure to LangChain (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.
Preferred

Master’s degree in data science, computer science, informatics, public health, or similar field
Experience with medical or dental claims data, electronic health records, and/or dental practice management software preferred
Familiarity with CI/CD pipelines, version control (e.g., Git), and cloud platforms (e.g., Azure, AWS).
Experience using data analytics and/or report development tools like PowerBI and Tableau
Experience with prompt engineering and AI data tools
Hands-on expertise with statistical software such as R, SAS
Physical Demands

Incumbent must be able to communicate effectively.
Manual dexterity and sitting is required in carrying out position own position responsibilities (i.e., use of personal computer).
Ability to travel or move about within and outside serviced facilities required.
Incumbent works primarily in either a private or shared office environment.
The target hiring range for this role is $107,185-126,100 ( Annually). The starting base salary will be determined based on skills, experience, and other job-related factors. In addition, our total rewards package includes medical, dental, and vision plans; generous time off including PTO, short and long-term disability insurance and a competitive 401(k) savings match including financial planning workshops. See our Careers Page for more information.
The specific statements shown in each section of this description are not intended to be all-inclusive. They represent typical elements and criteria necessary to successfully perform this position.

In accordance with CareQuest Institute for Oral Health’s Compliance Plan, all employees must conduct CareQuest Institute for Oral Health business and activities in accordance with applicable laws, regulations, professional standards and ethical standards and report potential compliance or ethical issues to CareQuest Institute for Oral Health’s designated Compliance Officer. **
CareQuest Institute for Oral Health’s Affirmative Action Program affirms our commitment to make reasonable accommodation for known physical or mental limitation of otherwise-qualified individuals with disabilities or special disabled veterans, unless the accommodation would impose an undue hardship on the operation of our business and activities. Please see Human Resources for additional information regarding this program.