Senior Data Engineer

Job Description Job Description 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 innovating in Pharmacy Benefits Management (PBM) with a next-gen platform, transforming how businesses manage pharmacy benefits. Our advanced technology offers real-time insights for cost efficiency, improved clinical services, and an enhanced customer experience.

As part of SmithRx's product & engineering organization, the data engineering team is committed to creating a scalable and reliable data ecosystem, a vital foundation for delivering excellent service and operational superiority to our customers. We are currently seeking a highly motivated Senior Data Engineer to join our fast-paced data team. The ideal candidate will work closely with cross-functional teams to develop scalable data pipelines, optimize data workflows, and ensure data quality and reliability.

This should also include a strong background in data engineering, with expertise in data modeling, ETL processes, and cloud technologies. What you will do: Design and implement scalable data models in enterprise data warehouse to support the company's analytical and reporting needs.

Develop and optimize ETL processes to ingest, transform, and load data from various sources into a data warehouse. Collaborate with internal stakeholders, including Data Analytics team, to understand data requirements and translate them into technical solutions. Build and maintain data warehouses, data lakes, and other data storage solutions to store and manage large volumes of structured and unstructured data.

Implement and enforce data governance policies to ensure PII/PHI protection, security, and compliance. Monitor and optimize ETL jobs, database performance and data warehouse queries. Document data engineering processes, data models, and design for knowledge sharing and reference.

Mentor junior data engineers and provide technical guidance and support to team members. What you will bring to SmithRx: Bachelor's degree above in Computer Science, Information Technology, or a related field. 5 years of related experience in data engineering, software engineering, including proven experience as a Data Engineer with expertise in data warehouse technologies.

Strong programming skills, particularly in languages such as Python, Java.

Proficiency in SQL, PySpark. Strong programming skills, particularly in languages such as Python, Java.

Proficiency in SQL, PySpark Solid understanding of data modeling concepts and database design principles. Hands-on experience with ETL tools and frameworks (e.g., Apache Spark, Apache Airflow, DBT, Looker) Strong problem-solving abilities and attention to detail. Excellent communication and collaboration skills.

Positivity; non-dogmatic, team-first attitude Flexibility; someone who is responsive and comfortable with ambiguity Start-up or healthcare experience is highly desirable What SmithRx Offers You: Total Rewards package that includes incentive bonus and stock options Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance and AD&D Insurance Flexible Spending Benefits 401(k) Retirement Savings Program Short-term and long-term disability Discretionary Paid Time Off 12 Paid Holidays Wellness Benefits Commuter Benefits Paid Parental Leave benefits Employee Assistance Program (EAP) Well-stocked kitchen in office locations Professional development and training opportunities