Analytics Engineer II

This is a fully remote position, open to applicants in United States.

📋 Description

• Construct and sustain dependable, scalable, and thoroughly documented data models that facilitate reporting, self-service analytics, and informed business decision-making.

• Collaborate with data engineers, analysts, data scientists, and business stakeholders to convert raw data into clean, reusable datasets and uniform metrics.

• Design, create, and uphold data models and transformation pipelines utilizing dbt and Snowflake.

• Develop and enhance SQL queries and transformations to meet reporting, analytics, and operational requirements.

• Take ownership of assigned tasks from requirements gathering through development, validation, deployment, and continuous support.

• Clarify stakeholder requirements and convert analytical needs into precise, well-structured datasets and metrics.

• Collaborate with data engineers to incorporate new data sources and address upstream dependencies.

• Create and manage dbt models, macros, automated tests, and relevant documentation.

• Investigate and rectify data quality issues, resolve transformation failures, and optimize query and model performance.

• Contribute to the development of shared metric definitions and semantic layers.

• Maintain data definitions, documentation, and lineage for governance and self-service analytics.

• Engage in code reviews and knowledge-sharing sessions.

• Utilize AI-assisted development tools for SQL development, troubleshooting, testing, and documentation, while validating generated code and outcomes.

• Communicate updates, dependencies, and risks, and seek guidance on intricate or unclear tasks.

⛳️ Requirements

• 3–5 years of experience in analytics engineering, data modeling, business intelligence, or a similar data role.

• Proficient SQL skills, encompassing complex joins, window functions, aggregations, as well as query troubleshooting and optimization.

• Practical experience with dbt, including modular models, testing, documentation, and basic Jinja.

• Familiarity with Snowflake or a similar cloud data warehouse.

• Understanding of dimensional modeling, dataset grain, and table relationships.

• Experience with Git, pull requests, and collaborative code review processes.

• Knowledge of data quality, automated testing, documentation, governance, and data lineage principles.

• Capacity to independently deliver clearly defined tasks, clarify ambiguous requirements, and troubleshoot data challenges.

• Experience with AI-assisted development tools such as Cursor, Claude Code, GitHub Copilot, or comparable technologies.

• Ability to effectively communicate technical concepts to both technical and non-technical stakeholders.

• Strong attention to detail, curiosity, and a proactive approach to solving problems.

• Experience with semantic layers, shared metric definitions, or data contracts.

• Familiarity with modern BI tools such as Sigma, Omni, Tableau, Power BI, or Looker.

• Knowledge of data ingestion and integration tools like Fivetran or Matia.

• Familiarity with CI/CD workflows and automated deployment of analytics code.

• Experience with Python for scripting or automation tasks.

• Familiarity with AWS services utilized for data integration and processing.

🏝️ Benefits

• Supportive, open, and inclusive work environment.

• Commitment to equal opportunity employment.

• Disability assistance and accommodations available throughout the hiring process.