Full Job Description
In the role of Analytics Engineer 2, we'll count on you to:
• Design and develop analytics models aligned to business processes and reporting needs.
• Create curated marts and semantic structures that promote reuse and consistent interpretation.
• Partner with analysts to translate business questions into durable data models.
• Implement models using layered patterns (raw/conformed/curated) and modular SQL design.
• Use managed dependencies and reusable components (e.g., shared functions/templates) for standardized patterns and reuse.
• Apply incremental strategies where appropriate to improve refresh performance and manage costs.
• Define, document, and maintain KPIs/metrics; ensure consistent definitions across reporting surfaces.
• Maintain transformation-layer documentation (model/column descriptions) and publish lineage artifacts for impact analysis.
• Contribute to governance practices including naming conventions, tagging/metadata, and change management.
• Implement automated tests and freshness checks to ensure the reliability of published analytics datasets.
• Participate in peer review and CI checks to improve quality and reduce regressions.
• Enable stakeholders through documentation, demos, and shared patterns to support adoption.
Preferred Qualifications
• In depth experience with dbt Cloud or dbt Core with Git integration.
• Experience with BI tools (e.g., Power BI, Tableau) and semantic modeling patterns.
• Familiarity with CI/CD for analytics models (PR-based testing, documentation builds, promotion).
Required Qualifications
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or other applicable degree.
• Experience in analytics, BI, or data roles with demonstrated modeling and SQL proficiency.
• Ability to translate business requirements into stable, reusable data models.
• Familiarity with BI/reporting consumption patterns.