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

Alliance; United States; Hybrid; USD 84,000 - 106,000; Full time

Benefits offered by this job

Medical, Dental, Vision, Life, LTD

Generous retirement plan

Hybrid work options

Paid time off

Job summary

Alliance is seeking an Analytics Engineer to bridge Data Engineering and Data Analytics. You will design, build, and manage scalable data pipelines, semantic models, and analytical cubes to enable enterprise-wide self-service analytics.

The role emphasizes CI/CD practices, AI-assisted tooling, and collaboration with Data Science and Governance teams. Hybrid schedule with in-office weekly meetings in Morrisville, NC.

Qualifications

• Bachelor's degree required in CS/Data Science/Engineering or related field.
• Minimum 3 years designing and operating data analytics pipelines.
• Experience translating business metrics into analytical artifacts.

Responsibilities

• Design, build, and manage scalable analytics pipelines from raw data to analytics-ready assets.
• Develop and maintain complex DAGs for data workflows.
• Perform ETL focusing on data cleansing, preparation, and transformation.
• Architect and manage semantic models and analytical cubes for enterprise metrics.
• Collaborate with cross-functional teams to deliver data assets and products.

Skills

Analytics pipelines

DAGs

Semantic modeling

Databricks

SQL Server

PostgreSQL

GitHub Copilot

Git version control

CI/CD

KPIs & metrics

AI-driven tooling

Education

Bachelor's degree in Computer Science/Data Science/Engineering

Tools

dbt

dlt

Databricks

SQL Server

PostgreSQL

GitHub Copilot

Job description

If you are a job seeker with a disability and require a reasonable accommodation to apply for one of our jobs, you will find the contact information to request the appropriate accommodation by visiting the following our Accessibility Accomodation for Applicants page.

Share

• Posted on October 14, 2026

Locations

Showing 1 location

Home Office
Morrisville, NC 27560, USA

• Hybrid
• Information & Data Management
• Full-Time
• Requisition #: ANALY003599

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

• 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
• 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
• 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

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.

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

Qualifications

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.