Analytics Engineer

This is a fully remote position, open to applicants in Arizona, +27 more states.

📋 Description

• Construct and support scalable data models that convert raw data into organized, business-ready datasets.

• Ensure data integrity, comprehensive documentation, observability, semantic consistency, and optimal performance.

• Create and maintain modular dbt models, semantic layers, and BI views for business analysts and executive stakeholders.

• Grasp evolving business trends, business logic, and cross-functional collaborations to incorporate context and governance within the data layer.

• Develop, document, and sustain Kimball dimensional models, semantic definitions, warehouse transformation logic, and BI datasets.

• Design, create, and uphold version-controlled data models that facilitate self-service analytics and reporting.

• Guarantee data quality and pipeline accuracy through automated dbt testing, lineage tracking, performance optimization, and proactive alerts.

• Enhance complex business logic and disjointed queries by standardizing analyst requests into documented semantic models.

• Integrate data governance, metric standardization, documentation, single source of truth definitions, and secure data access.

• Collaborate with data team members and stakeholders; engage in standups, planning sessions, and retrospectives.

• Diagnose data logic issues and modeling errors while participating in analytics support activities.

• Identify enhancements to data transformation processes and semantic definitions.

• Contribute to the analytics platform, dbt models, semantic layers, and BI reporting frameworks.

• Take independent ownership of analytics engineering workstreams and modeling roadmap items.

• Cultivate domain expertise in business metrics and data definitions.

⛳️ Requirements

• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related discipline.

• 3-5 years of experience in analytics engineering, data engineering, or data science.

• Proven experience in building, testing, and maintaining production-grade data transformation workflows and semantic models.

• Familiarity with dimensional data modeling techniques, including Star Schema and Kimball methodology.

• Experience utilizing dbt or semantic tools to define, document, and communicate metric logic.

• Background in modeling business domain data, product usage metrics, and semi-structured JSON data for BI consumption.

• Software engineering mindset applied to data, including Git, automated testing, CI/CD, data modeling, and code documentation.

• Expertise in advanced SQL, dbt, Snowflake, Python, Git, and modern BI tools such as Looker or Tableau.

• Experience with Google Analytics, marketing, advertising, social media platforms, CRM/Salesforce, and BI visualization tools.

• Knowledge of the modern data stack, encompassing modeling, semantic layers, testing, documentation, governance, and BI integration.

• Understanding of dimensional data modeling techniques, including Kimball methodology, Star Schema, and Snowflake Schema.

• Must be legally authorized to work in the United States without sponsorship now or in the future.

• Candidates must reside in one of the states listed for hiring.

🏝️ Benefits

• Annual Bonus and Stock Option Program.

• Fully flexible workforce: remote work, Pittsburgh office, or a hybrid approach.

• Complete coverage of employee health plan, including vision, dental, and supplemental options at no cost.

• Flexible Paid Time Off Policy.

• Work-from-home office stipend.

• 12 weeks of fully paid parental leave available for all employees.

• Short-term disability coverage for birthing parents.

• 401(k) plan with employer matching.

• Equal opportunity and inclusive work environment.

• Remote interview process.