We are looking for a senior SQL & Data Engineer partly on-site in London, with 5+ years of experience, who will be responsible for building scalable ETL pipelines, optimizing SQL queries, and developing efficient data models to power business intelligence and reporting. This role places a strong emphasis on database management, data processing, and ETL automation, while also integrating Microsoft Fabric and Power BI for visualization and reporting. Short-term contract – 3 months.
This role is for you if you
- Have deep expertise in SQL (T-SQL, PostgreSQL, MySQL) and query optimization.
- Have experience designing and maintaining ETL pipelines for large-scale data processing.
- Can structure and model data efficiently for BI and reporting purposes.
- Have experience working with Microsoft Fabric, Power BI, and cloud data solutions.
- Are skilled in data warehousing, data integration, and performance tuning.
Key Responsibilities
- Develop and optimize SQL queries, stored procedures, and data models to support data processing and analytics.
- Design, build, and maintain ETL pipelines to integrate data from multiple sources.
- Structure and clean raw data to enable efficient BI reporting and decision-making.
- Implement and manage Microsoft Fabric and Power BI dashboards for real-time analytics.
- Monitor and optimize database performance, ensuring reliability and scalability.
- Collaborate with finance, product, and business teams to define data requirements and reporting needs.
Requirements
- Strong SQL (T-SQL, PostgreSQL, MySQL) expertise, including query optimization and indexing.
- Hands-on experience with ETL processes and workflow automation.
- Data modeling expertise, including normalization, denormalization, and performance tuning.
- Experience with Microsoft Fabric and Power BI for BI and reporting.
- Knowledge of data warehousing concepts and best practices.
- Familiarity with cloud platforms (Azure, AWS) is a plus.
- Strong problem-solving skills and ability to work with large datasets.
Tech Stack
Databases: SQL/T-SQL, PostgreSQL, MySQL.
ETL Tools: Apache Airflow, dbt, Microsoft Fabric.
BI & Reporting: Power BI, Microsoft Fabric.
Cloud: Azure, AWS (optional).
Data Warehousing: Snowflake, Redshift (if applicable).