Senior Analytics Engineer – Data Modeling, BI

Job Description: • Develop and maintain data replication and ELT pipelines feeding the analytics platform • Design and implement dimensional data models using star and snowflake schemas • Build and maintain data transformations that convert operational data into analytics-ready datasets • Implement data quality checks, testing, and validation to ensure accuracy of KPIs and metrics • Create and maintain documentation for data models, business logic, and data lineage • Establish data governance standards for analytics, including naming conventions, access controls, and metric definitions • Partner with BI tool users (Tableau, Looker, Power BI) to design efficient, performant data structures • Mentor junior engineers and analysts on data modeling, SQL optimization, and analytics best practices Requirements: • 5+ years of experience in data engineering with a strong focus on analytics and business intelligence • Expert-level proficiency in SQL and dimensional data modeling • Hands-on experience with Amazon Redshift, including performance tuning and optimization • Strong experience using dbt for analytics engineering, including transformations, testing, and documentation • Experience building ELT workflows using AWS data services such as S3, Glue, Lambda, or Step Functions • Working knowledge of Python for data processing or pipeline orchestration • Understanding of data security and privacy principles, including experience with regulated data (PII, PHI) • Experience with Git-based workflows and Agile development practices • Strong communication skills and ability to explain technical concepts to business stakeholders • Bachelor’s degree in Computer Science, Engineering, Statistics, Information Systems, or related field • Due to FedRAMP requirements, candidates must be a U.S. Person Benefits: • Medical, Dental & Vision (inclusive of domestic partnerships) • Employer Paid Life Insurance & Employee/Spouse/Child Supplemental life • Voluntary Short/Long Term Disability Insurance • 401K (Roth/Traditional) • A generous PTO plan that celebrates your commitment and seniority (including paid Bereavement/Jury Duty, etc) • Above market annual bonuses Apply tot his job Apply To this Job