Analytics Engineer Sr

The Senior Analytics Engineer designs and optimizes scalable data solutions that enable dependable reporting, analytics, and governed self-service insights. This role also leads complex initiatives from design through deployment while providing technical leadership and mentorship to strengthen data quality and delivery.

Responsibilities

• Partner with business stakeholders to define requirements, identify opportunities to improve data delivery, and determine which business processes and tasks can be automated.
• Analyze source data and relationships among data assets to deliver actionable, data-driven insights and decision support.
• Design, develop, test, and maintain data architectures, ELT processes, logical and physical data models, data marts, metadata repositories, and data warehouse solutions aligned with business needs.
• Optimize data retrieval and dataset processing by developing scalable algorithms and identifying opportunities to improve reliability, efficiency, quality, and performance.
• Contribute to and maintain the business glossary, metadata, documentation, and other resources that support shared understanding and cross-functional collaboration around analytical data assets.
• Provide technical leadership for analytics initiatives and projects, ensuring solutions support information management, reuse, scalability, and governance; develop and test proofs of concept to validate feasibility and demonstrate business value.
• Collaborate with and cross-train data scientists, systems analysts, report developers, and other technical partners to improve solution quality, knowledge sharing, and delivery continuity.
• Perform other duties as assigned.

Required Qualifications

• Bachelor’s degree in computer science, applied mathematics, engineering, or another IT-related field; or an equivalent combination of education and/or relevant work experience; high school diploma from an accredited school or equivalent GED.
• 5 years of experience in IT, including 3 years of data analytics engineering and experience in business intelligence, data warehousing, or analytics.
• Must be eligible to work in the United States without the need for work visa or residency sponsorship.

Additional Qualifications

• Demonstrated ability to architect, develop, and maintain scalable cloud-based data solutions.
• Strong understanding of relational and dimensional data modeling, data transformation, code operationalization, and data exploration.
• Ability to develop, maintain, review, and translate data models into reliable analytical solutions.
• Proficiency in SQL, stored procedures, ELT development, and cloud database platforms.
• Demonstrated experience delivering complex analytics engineering solutions end to end, including design, development, testing, deployment, and operational support.
• Demonstrated experience mentoring and developing junior analytics engineers through guidance on engineering practices, code quality, testing, and solution design.
• Demonstrated experience establishing and applying data engineering standards, testing practices, code review expectations, and performance optimization techniques.
• Understanding of the pharmacy benefit management and broader healthcare ecosystem.
• Knowledge of and experience with benefit planning and modeling.
• Leverage AI to create and enhance engineering deliverables.
• Reverse engineer existing codebases for migration to modern technologies.

Preferred Qualifications

• dbt certification or equivalent hands-on experience.
• Experience with software development and work management tools such as GitHub and Jira.
• Experience partnering with end users to gather requirements and deliver technical solutions from concept through implementation.
• Programming experience with languages such as Python and supported frameworks.
• Experience with cloud data platforms and associated technologies such as Google Cloud and BigQuery.
• Google Kubernetes Engine (GKE) experience.
• Experience building and maintaining data and analytics products using common business intelligence tools and cloud technologies.

Technologies

• SQL, stored procedures, ELT, cloud database platforms, dbt, GitHub, Jira, Python, Google Cloud, BigQuery, Google Kubernetes Engine (GKE)

Compensation

Potential pay for this position ranges from $108,000.00 to $184,000.00 per year based on experience and skills.

Security and Compliance

Every employee must understand, comply with, and attest to the security responsibilities and security controls unique to their job, and comply with all applicable legal, regulatory, and contractual requirements and internal policies and procedures.

Essential Functions

Every employee must be able to perform the essential functions of the job. If requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions, absent undue hardship. Prime retains the right to change or assign other duties to this job.

Equal Opportunity and Other Statements

• Prime Therapeutics LLC is an equal opportunity and affirmative action employer.
• Applicants with different backgrounds, experiences, abilities, and perspectives are welcome, including qualified applicants with arrest and conviction records and applicants requiring reasonable accommodations in accordance with the law.
• Prime Therapeutics LLC is a Tobacco-Free Workplace employer.
• Positions will be posted for a minimum of five consecutive workdays.