- Create and enhance data warehouse systems to help with analytics and business intelligence.
- To gather needs and deliver data solutions, work together with engineers, data analysts, and other stakeholders.
- Incorporate ETL procedures to guarantee precise and prompt data integration from diverse sources.
- Create and manage stored procedures, tables, views, and database schemas.
- Analyse data and offer insights to back up business choices.
- Make that the data warehouse has secure, accurate, and up-to-date data.
- Investigate and fix disparities and problems with data.
- Data warehousing and reporting technologies within an Azure environment
- The collation of data from various internal/external data sources in differing formats
- Reviewing and rationalisation of existing data solutions to deliver costs, efficiency, scalability benefits
- Design and development of highly scalable/performant data solutions to support transactional systems in a service oriented architecture
- Required experience with ADF, Synapse, Azure SQL and Power BI.
- Experience with DataBricks and python (desirable).
- Deep knowledge of SQL and data warehouse methodologies.
- Knowledge of how to deliver BI solutions through CI/CD.
- Strong analytical and problem-solving abilities.