Analytics Engineer — DBT & SQL

About the job

One of our clients is seeking an Analytics Engineer to own dbt transformations and provide trusted, reusable data for reporting and self-service analytics.

Responsibilities

• Own dbt project structure, naming conventions, tests, documentation and refactoring.
• Keep production transformations reliable through builds, deployments, dependency management, monitoring and failure triage with data engineers.
• Develop shared dimensions, facts and metrics, and agree upstream data-shaping requirements with engineering teams.
• Translate analytical requirements into reliable, performant dbt models.
• Work with data quality analysts to embed validation rules and tests into transformations.
• Build star-schema facts and dimensions with explicit grain and consistent metric calculations.
• Convert analyst and business requirements into reusable transformation logic.
• Document model descriptions, lineage, business context and assumptions so data is discoverable and understandable.
• Support shared definitions, semantic consistency and governance across reporting teams.
• Participate in code reviews, testing and deployment workflows.

Required Qualifications

• A bachelor’s degree in analytics, computer science, information systems or a related field, or equivalent experience.
• At least five years in analytics engineering, business intelligence, data engineering or a related role.
• Advanced SQL, including complex transformations, aggregations and window functions, backed by at least one year of hands-on SQL work.
• Experience developing and refactoring dbt models, sources, tests and documentation.
• Strong knowledge of analytical data modeling.
• Ability to translate business concepts into data models.
• Ability to explain transformation logic in business terms.
• Build collaborative, trusting working relationships.
• Communicate complex information accurately, concisely, respectfully and accessibly in writing and conversation.
• Solve problems with urgency and maintain delivery through challenging situations.
• Contribute positively to the wider professional community.
• Consider the needs of colleagues and stakeholders in your decisions.
• Exercise objectivity and integrity in your work.

Preferred Qualifications

• Experience combining a modern cloud warehouse, dbt and business intelligence tools.
• Experience with Microsoft Fabric, Power BI semantic models or similar capabilities.
• Experience collaborating with data engineering and data quality specialists.
• Knowledge of lineage, stewardship, shared definitions and certified metrics.
• Ability to bring clarity to evolving requirements and modeling standards.
• Professionalism, integrity and accountability in day-to-day delivery.