Data Quality Engineer

Location: Remote (For Non-Local) or Hybrid (Local to NYC area)

Position Summary:

We are seeking a highly motivated and detail-oriented Data Quality Engineer to join our team. In this critical role, you will be the guardian of our data's integrity, ensuring the accuracy, reliability, and robustness of the systems that power our operations and analytics. You will be instrumental in building trust in our data and empowering the organization to make confident, data-driven decisions that drive positive healthcare outcomes.

Position Responsibilities:

• Technical Issue Identification & Root Cause Analysis: Identify, investigate, and triage technical issues within the data engineering tech stack (specifically focusing on [Specify Key Technologies - e.g., Python, SQL, Airflow, dbt]). Conduct thorough root cause analysis, utilizing logs, database queries, and system monitoring data to pinpoint the source of problems.
• Log Analysis & Monitoring: Monitor and analyze system logs (e.g., using CloudWatch to validate application functionality, identify performance bottlenecks, and proactively detect anomalies. Develop and maintain dashboards to visualize key system metrics.
• Database Querying & Analysis: Utilize SQL to query and analyze data within the Snowflake data warehouse. Develop and execute complex queries to investigate data discrepancies, identify trends, and support troubleshooting efforts. Familiarity with SQLAlchemy is a plus.
• AWS Service Support: Collaborate with the engineering team on the support and monitoring of AWS services utilized within data engineering (g., EC2, S3). Assist with troubleshooting issues related to these services.
• Collaboration & Requirements Translation: Collaborate with Product Managers and engineers to understand business requirements and translate them into actionable test requirements and test plans. Participate in sprint planning and daily stand-ups.
• QA Execution: Conduct thorough QA tasks, including ticket review, refinement, testing (manual and potentially exploratory), and bug identification.
• Scrum Team Support: Partner with the scrum team to manage backlogs, refine tickets, and support roadmap development.
• UAT Support: Assist with UAT testing, stakeholder communication, and documentation to align team efforts with business goals.
• Compliance & Reporting: Ensure adherence to company policies, including timely reporting of noncompliance.
• Code of Conduct: Responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance.

Minimum Qualifications:

• Bachelor's degree strongly preferred in Computer Science, Information Technology, or a related field.
• 3+ years of experience in a QA Analyst, Data Engineer, Business Analyst, or related role.
• Proficiency in Python
• Strong SQL experience; familiarity with Snowflake preferred.
• Familiarity with Agile methodologies and workflows.
• Experience with GitHub or similar source control repositories.
• Excellent communication and collaboration skills, with the ability to translate between technical and non-technical audiences both verbally and in writing.
• Strong analytical and problem-solving skills with attention to detail and QA principles
• A meticulous, detail-oriented mindset with a passion for ensuring data accuracy.

Preferred Qualifications:

• Experience in the healthcare or PBM sector.
• Hands-on experience with modern data stack tools like Airflow, dbt, and Snowflake.
• Experience with CI/CD pipelines.
• Understanding of data warehousing concepts.
• Familiarity with automated testing frameworks and data validation tools.

This position description is designed to be flexible, allowing management the opportunity to assign or reassign duties and responsibilities as needed to best meet organizational goals.