About the role
Design and evolve a cloud data warehouse on Snowflake with dbt: layered modelling, history/snapshot strategy and ingestion from operational databases. Lead technical discovery: scope validation, impact analysis, data profiling and solution design. Set engineering standards for ETL, stored procedures, migrations and multi-environment promotion. Architect reporting solutions in Power BI (paginated reports and dashboards), including automated report testing. Define CI/CD and ALM for data, reporting and Power Platform workloads. Evaluate tools and build-vs-buy options, balancing cost, licensing and security. Drive AI-assisted delivery (knowledge bases, agent-assisted development and testing). Oversee production stability, review designs and code, and mentor engineers. Engage stakeholders and translate business needs into roadmaps and estimates. Strong data architecture experience with SQL Server/Azure SQL and Snowflake dbt, dimensional modelling, SCD/snapshot patterns Power BI architecture (paginated reports and dashboards) CI/CD for data platforms (Azure DevOps or GitHub) Excellent client-facing communication and documentation Power Platform / Power Automate ALM Fivetran, AWS (S3), PostgreSQL Azure (Container Apps, Entra ID) GenAI / agentic tooling for engineering