Analytics Engineer (Full-time Hybrid, Morrisville, NC Based)
About The Position
The Analytics Engineer serves as a technical bridge between Data Engineering and Data Analytics, applying data engineering principles to the analytics development lifecycle. The role creates, scales, and manages data assets—including metrics stores, data marts, and semantic layers—to enable consistent and reliable data consumption across the organization. It applies practices such as code versioning, CI/CD, and automated orchestration to bring software engineering discipline to analytics and support scalable, modern data initiatives. Working within business domains, the Analytics Engineer translates business metrics and KPIs into analytical artifacts and partners with analytics, data science, governance, and business teams to deliver data products. The position is full-time and hybrid. The selected candidate must reside within 50 miles of Morrisville, North Carolina, and come to the Morrisville home office on Wednesdays and for business meetings as needed.
Requirements
- Bachelor’s degree in Computer Science, Data Science, Engineering, or a related field from an accredited college or university.
- At least three years of experience designing and operating data analytics pipelines.
- Experience designing, building, and managing scalable analytics pipelines in a modern data stack, such as dbt or dlt.
- Expertise developing and maintaining complex DAGs for workflow execution and dependency management.
- Expertise architecting and managing semantic layers, metrics stores, and analytical cubes using Strategy and Mosaic technology.
- Proficiency with Databricks and SQL Server for large-scale data processing and cloud-based data engineering workflows.
- Proficiency managing PostgreSQL and SQL Server environments, including schema design, indexing, and performance tuning for analytics pipelines.
- Ability to use AI-driven tools such as GitHub Copilot for code development, documentation, and technical problem-solving.
- Proficiency with software engineering principles, including Git version control, CI/CD, and automated orchestration.
- Ability to translate complex business metrics and KPIs into technical artifacts and partner with Data Science, Governance, Quality Management, and Medical Economics teams.
- Advanced SQL and Python skills for data manipulation, integration, and modeling.
- Must reside within 50 miles of Morrisville, North Carolina, and attend the Morrisville home office on Wednesdays and for business meetings as needed.
- Employment is contingent upon satisfactory background and credit checks after offer acceptance and before the start date.
Responsibilities
- Design, build, and manage scalable analytics pipelines that transform raw data into analytics-ready assets.
- Develop and maintain complex Directed Acyclic Graphs (DAGs) to manage workflow execution and dependencies.
- Perform analytics-focused extract, load, and transform processes, including data cleansing, preparation, and transformation.
- Architect and manage semantic models using Strategy (BI) and Mosaic technology to centralize business metrics.
- Design and scale metrics stores, semantic layers, and analytical cubes to support enterprise-wide self-service analytics.
- Use enterprise data platforms to process large-scale datasets and implement modern data engineering workflows in a cloud environment.
- Manage Strategy (BI) databases and ensure they are optimized and integrated with analytics pipelines.
- Use AI-augmented tools to accelerate code development, documentation, and technical problem-solving, while validating generated code and outputs for accuracy and reliability.
- Partner with Data Analytics and Data Science teams to identify, define, and deliver required data and datasets.
- Collaborate with Data Governance to support secure, compliant, high-quality enterprise data assets and products.
- Work with Quality Management, Medical Economics, and other cross-departmental teams to translate business needs into analytical solutions and data products.
- Apply version control, CI/CD, and automated orchestration to promote scalable and consistent analytics development.
- Integrate with domain teams to connect data management with business needs and support federated analytics architectures.
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Life insurance
- Long-term disability coverage
- Generous retirement savings plan
- Flexible work schedules, including hybrid/remote options
- Paid time off, including vacation, sick leave, holidays, and management leave
- Dress flexibility
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
