Senior Data Engineer

Who We Are:

SmithRx is a rapidly growing, venture-backed Health-Tech company.  Our mission is to disrupt the expensive and inefficient Pharmacy Benefit Management (PBM) sector by building a next-generation drug acquisition platform driven by cutting edge technology, innovative cost saving tools, and best-in-class customer service.  With hundreds of thousands of members onboarded since 2016, SmithRx has a solution that is resonating with clients all across the country.

We pride ourselves for our mission-driven and collaborative culture that inspires our employees to do their best work. We believe that the U.S healthcare system is in need of transformation, and we come to work each day dedicated to making that change a reality. At our core, we are guided by our company values:

• Integrity: Do the right thing. Especially when it’s hard.
• Courage: Embrace the challenge.
• Together: Build bridges and lift up your colleagues.

Job Summary:

SmithRx is developing the next-generation pharmacy benefits management (PBM) platform, revolutionizing how businesses administer and oversee pharmacy benefits. Our cutting-edge technology platform provides real-time actionable insights that drive cost efficiencies, enhance clinical services, and elevate the customer experience. Operating within SmithRx's production and engineering division, the data engineering team is dedicated to establishing a scalable and dependable single source of truth data ecosystem. This ecosystem plays a critical role in enabling our organization to provide unparalleled service excellence and operational superiority to our valued customers. 

We are currently seeking a highly motivated Senior Data Engineer to join our fast-paced data team. The primary focus of this role will be delivering high data availability and quality throughout the entire data life cycle from ingestion to end products: data pipelines, and data warehouse production datasets. This role will gather data quality requirements from stakeholders, these data consumers could include business users, product owners, data analysts, software developers, or even other data developers. 

This role is critical because data quality is a continuous process as data environments are complex, interdependent, and constantly changing. He/She will advocate and bring best practices/methodologies, coding standards, and large-scale data warehouse design perspectives to our team.

What will you do:

• Design, build, and implement bug prevention strategies, and maintain highly scalable and reliable data platforms, including data pipelines, data warehouses, and data lakes.
• Develop and execute manual and automated test cases for data warehouse solutions to ensure the reliability of data pipelines, ETL processes, and data transformations. 
• Collaborate with business users, product owners, data analytics, data engineering, and development teams to implement data quality best practices and optimize data workflows. 
• Implement and optimize data governance and security policies to ensure data quality and compliance.
• Drive engineering excellence and lead craftsmanship in building, testing, and optimizing ETL/feature/metric pipelines
• Document data quality issues, testing procedures, and resolutions for future reference and knowledge sharing. Ability to perform root cause analysis on defects.

What will you bring to SmithRx:

• BS or Master's degree preferred in Computer Science, Information Technology or Systems Engineering. Bachelor’s degree 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.
• Start-up experience is highly desirable
• Prior experience in cloud services (AWS preferred), 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 
• Build 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)
• Well stocked kitchen in office locations
• Professional development and training opportunities