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