Analytics Engineer

Analytics Engineer

Job Summary

Key Responsibilities

• Design, develop, and maintain scalable data transformation pipelines.
• Build and manage data models using SQL and dbt.
• Transform raw datasets into clean, reliable, analytics-ready data.
• Develop and maintain data warehouses and data marts.
• Create reusable data models for business intelligence and reporting.
• Implement data quality testing, validation, and monitoring.
• Optimize SQL queries and improve data warehouse performance.
• Integrate data from multiple business applications and platforms.
• Collaborate with data analysts and business teams to understand reporting requirements.
• Maintain documentation for data models, workflows, and transformations.
• Ensure data consistency, accuracy, governance, and security.
• Support dashboards, KPI reporting, and business analytics initiatives.

Required Technical Skills

• Programming: Advanced SQL, Python.
• Analytics Engineering: dbt Core, dbt Cloud.
• Data Warehousing: Snowflake, Google BigQuery, Amazon Redshift.
• Data Modeling: Dimensional modeling, Star Schema, Snowflake Schema.
• ETL/ELT: Data transformation, pipeline development, data integration.
• BI & Visualization: Tableau, Power BI, Looker, Looker Studio.
• Cloud Platforms: AWS, Azure, or Google Cloud Platform.
• Data Orchestration: Apache Airflow, Dagster.
• Version Control: Git, GitHub, GitLab.
• Data Quality: Great Expectations, dbt tests, data validation.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, or a related field.
• 3–8 years of experience in Analytics Engineering, Data Engineering, or a related role.
• Strong expertise in SQL and data transformation.
• Hands-on experience with dbt and modern data warehouse platforms.
• Experience developing scalable and reusable data models.
• Understanding of data architecture, ETL/ELT workflows, and analytics best practices.
• Strong analytical, communication, and problem-solving skills.
• Ability to work independently in a fully remote environment.

Preferred Qualifications

• Experience implementing modern data stack architectures.
• Knowledge of business intelligence and reporting frameworks.
• Experience working with large-scale datasets.
• Understanding of data governance and data privacy.
• Experience with CI/CD workflows for analytics projects.
• Familiarity with Agile development methodologies.

Salary & Benefits

• Annual Salary: $110,000 – $165,000.
• Competitive compensation based on experience and skills.
• Fully remote working opportunity.
• Health, dental, and vision insurance (subject to employer policy).
• Paid vacation and holidays.
• Professional development opportunities.
• Career growth and advancement opportunities.

Work Schedule

• Employment Type: Full-Time, Permanent.
• Working Hours: 40 hours per week.
• Work Location: Fully Remote.
• Location Preference: San Francisco, CA, United States.
• Must be available to collaborate with US-based teams.

Equal Employment Opportunity