Senior Data Quality Engineer

Who We Are: SmithRx is a rapidly expanding, venture-backed Health-Tech company. Our goal is to overhaul the costly and inefficient Pharmacy Benefit Management (PBM) industry by creating a cutting-edge drug procurement platform powered by state-of-the-art technology, innovative money-saving tools, and top-tier customer service. Since 2016, we've brought on board hundreds of thousands of members and our solution is gaining traction with clients nationwide. We take pride in our mission-centred, collaborative culture that encourages our employees to give their best. We hold the conviction that the U.S healthcare system needs a serious overhaul, and we approach work every day dedicated to making this change a reality. At our core, we adhere to our company values: - Integrity: Always do what's right, even when it's difficult. - Courage: Take on the challenge. - Together: Build bridges and uplift your colleagues. Job Summary: SmithRx is pioneering a next-generation pharmacy benefits management (PBM) platform, revolutionizing how businesses administer and monitor pharmacy benefits. Our leading-edge technology platform offers real-time actionable insights that promote cost efficiencies, enhance clinical services, and enrich the customer experience. The data engineering team within SmithRx's production and engineering division is dedicated to creating a scalable and reliable data ecosystem. This ecosystem is critical in enabling our organization to deliver unparalleled service excellence and operational superiority to our valued clients. We are currently seeking a highly driven Senior Data Quality Engineer to join our dynamic data team. The main focus of this role is delivering exceptional data availability and quality throughout the entire data lifecycle, from ingestion to end products: data pipelines, and data warehouse production datasets. The incumbent will collect data quality requirements from stakeholders, who could be business users, product owners, data analysts, software developers, or even other data developers. This role is crucial as data quality is an ongoing process in data environments that are complex, interdependent, and continuously changing. The incumbent will champion and introduce best practices/methodologies, coding standards, and perspectives on large-scale data warehouse design to our team. What you will do: - Gather requirements, develop and execute manual and automated test cases for data warehouse solutions to ensure the reliability of data pipelines, ETL processes, and data transformations. - Conduct thorough data profiling and analysis of data sources & sets to identify inconsistencies, inaccuracies, and anomalies. - Develop, maintain, and enhance a comprehensive data quality framework that defines data standards, quality rules, and validation processes. - Establish data monitoring systems to continuously assess data warehouse quality and report on deviations to stakeholders. - Contribute to data governance efforts by participating in data stewardship, data quality, and PII/PHI compliance. - Work closely with data engineers, data scientists, engineers, and data analysts to address data quality issues and drive improvements. - Lead data engineering excellence and promote craftsmanship in constructing, testing, and optimizing ETL/feature/metric pipelines. - Maintain meticulous documentation of data quality standards, policies, and procedures. What you will bring to SmithRx: - Preferred BS or Master's degree in Computer Science, Information Technology or Systems Engineering. A Bachelor’s degree is required. - A minimum of 6+ years of related experience in data engineering, software engineering, DevOps, and technical leadership. With a Bachelor’s degree, 8+ years of experience are required. - Experience within a startup is highly desirable. - Prior experience with cloud services (preferably AWS), and columnar databases (Redshift, Snowflake). - Proficiency in SQL, Python, Spark (Batch/Streaming), SparkSQL, PySpark, AWS Glue, Airflow, Terraform, Kubernetes, CI/CD, and automated testing capabilities. - Experience with end-to-end integration testing between multiple independent systems and interfaces (flat files, APIs, ETL), etc. What SmithRx Offers You: - Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance. - Flexible Spending Benefits. - 401(k) Retirement Savings Program. - Short-term and long-term disability. - Discretionary Time Off. - 13 Paid Holidays. - Wellness benefits- Spring Health, Gympass, and Headspace. - Commuter Benefits. - Paid Parental Leave benefits. - Employee Assistance Program (EAP). - A well stocked kitchen in office locations. - Opportunities for professional development and training.