Job Description
- 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