Analytics Engineer (Full-time Hybrid, Morrisville, NC Based)

Alliance Health; Morrisville (NC); Hybrid; USD 84,000 - 106,000; Full time

Benefits offered by this job

Medical insurance

Retirement plan

Flexible schedules

Paid time off

Dress code

Job summary

Alliance Health is seeking an Analytics Engineer to bridge Data Engineering and Data Analytics, building high-value data assets, such as metrics stores and semantic layers, to enable enterprise-wide analytics. The role emphasizes CI/CD, versioning, and automated orchestration to drive scalable data initiatives.

The position is full-time, hybrid, requiring in-office presence in Morrisville, NC on Wednesdays and within 50 miles of Morrisville.

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Engineering or related field with at least three (3) years designing and operating data analytics pipelines.
• Experience designing, operating, and optimizing analytics pipelines in a modern data stack.
• Ability to translate business metrics into technical artifacts and data products.

Responsibilities

• Design, build, and manage scalable analytics pipelines from raw data to analytics-ready assets.
• Develop and maintain complex DAGs for data workflows and dependency management.
• Architect and manage semantic models, metrics stores, and analytical cubes for enterprise-wide self-service analytics.
• Leverage Databricks, SQL Server, PostgreSQL to process large-scale data in the cloud.
• Apply AI-assisted tooling to accelerate development while ensuring accuracy and reliability.

Skills

Analytics pipelines

DAGs

SQL

Python

Databricks

Cloud platforms

CI/CD

Git

Semantic modeling

Metrics stores

Education

Bachelor's degree

Tools

dbt

DLT

Databricks

SQL Server

PostgreSQL

Mosaic

Strategy

Job description

TheAnalytics Engineer serves as a critical technical bridge between Data Engineering and Data Analytics, applying rigorous data engineering principles to the analytics development lifecycle. This role is responsible for creating, scaling, and managing high-value data assets (including metrics stores, data marts, and semantic layers) to ensure consistent and reliable data consumption across the organization. By implementing best practices such as code versioning, CI/CD, and automated orchestration, the Analytics Engineer brings software engineering discipline to the analytics space to drive scalable and modernized data initiatives. Working closely within business domains, the Analytics Engineer translates complex business metrics and KPIs into actionable analytical artifacts, empowering the organization to achieve greater success through a mature, data-driven culture.

This position is full-time hybrid. Selected candidate must come into the Home office in Morrisville on Wednesdays, for business meeting as needed, reside within 50 miles of Morrisville North Carolina.

Responsibilities & Duties

Analytics Pipeline Development & Orchestration

• Design, build, and manage scalable analytics pipelines to handle the transition from raw data to analytics-ready assets
• Develop and maintain complex Directed Acyclic Graphs (DAGs) to ensure logical execution and dependency management of data workflows
• Perform advanced extract, load and transform processes specifically tailored for the analytics domain, focusing on data cleansing, preparation, and transformation

Semantic Modeling & BI Enablement

• Architect and manage high-value semantic models using Strategy (BI) and Mosaic technology to ensure a centralized source for business metrics
• Design and scale critical data assets, including metrics stores, semantic layers, and analytical cubes, to support enterprise-wide self-service analytics

Cloud & Database Management

• Leverage enterprise data platforms to process large-scale datasets and implement modern data engineering workflows within a cloud environment
• Perform database management tasks for Strategy (BI) databases, ensuring these environments are optimized and properly integrated with analytics pipelines

AI-Augmented Productivity & Engineering

• Utilize AI-augmented tools to accelerate code development, documentation, and technical problem-solving
• Apply responsible AI practices by carefully crafting prompts and rigorously validating AI-generated code and outputs to ensure accuracy and reliability

Cross-Functional Collaboration & Strategic Support

• Partner closely with the Data Analytics and Data Science teams to proactively identify, define, and deliver the specific data requirements and datasets they need to succeed
• Collaborate with the Data Governance team to support the development of secure, compliant, and high-quality enterprise data assets and products
• Engage with cross-departmental teams, including Quality Management and Medical Economics, to translate their unique business needs into robust analytical solutions and data products

Engineering Best Practices & DevOps

• Apply software engineering disciplines to the analytics lifecycle, including version control, CI/CD, and automated orchestration to drive scalability and consistency
• Integrate directly into domain teams to bridge the gap between data management and business needs, facilitating federated analytics architectures

Minimum Requirements

Education & Experience

Required:

Bachelor’s degree in Computer Science, Data Science, Engineering or related field from an accredited college/university with at least three (3) years designing and operating data analytics pipelines.

Knowledge, Skills, & Abilities

• Designing, building, and managing scalable analytics pipelines in a modern data stack (i.e., dbt, dlt) to transform raw data into analytics-ready assets.
• Expertise in developing and maintaining complex Directed Acyclic Graphs (DAGs) to ensure logical execution and dependency management.
• Semantic Modeling: Expertise in architecting and managing high-value semantic layers, metrics stores, and analytical cubes using Strategy and Mosaic technology.
• Proficiency in leveraging Databricks and SQL Server to process large-scale datasets and implement modern data engineering workflows in a cloud environment.
• Proficiency in managing PostgreSQL and SQL Server environments, including schema design, indexing, and performance tuning for analytics pipelines.
• Ability to utilize AI-driven tools like GitHub Copilot to accelerate code development, documentation, and technical problem-solving.
• Proficiency in applying software engineering principles, including Git version control, CI/CD, and automated orchestration to the analytics lifecycle.
• Ability to translate complex business metrics and KPIs into technical artifacts while partnering with Data Science, Governance, Quality Management, and Medical Economics teams.
• Advanced technical skills in SQL and Python for sophisticated data manipulation, integration, and modeling.

Employment for this position is contingent upon a satisfactory background check and credit check, which will be performed after acceptance of an offer of employment and prior to the employee's start date.

Salary Range

$83,510-$106,475/Annually

Exact compensation will be determined based on the candidate's education, experience, external market data and consideration of internal equity.

• Medical, Dental, Vision, Life, Long Term Disability
• Generous retirement savings plan
• Flexible work schedules including hybrid/remote options
• Paid time off including vacation, sick leave, holiday, management leave
• Dress flexibility

Education

Required

• Bachelors or better in Computer Science

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.