BI Developer (Contract)
Posted Today by Hamilton Barnes
Negotiable
Undetermined
Hybrid
London, UK
Summary: The role of BI Developer involves joining the Risk Reporting team to design and develop scalable data solutions and business intelligence capabilities. The position requires expertise in SQL and experience with data warehousing technologies, particularly Snowflake and Power BI. The developer will contribute to data model design, optimize query performance, and implement data security measures. This is a hybrid role based in London for a duration of 6 months.
Key Responsibilities:
- Contribute to the design and development of efficient data models, schemas, and pipelines.
- Develop data ingestion and processing solutions using existing frameworks.
- Write complex SQL queries, stored procedures, and functions to extract, transform, and load data.
- Optimize query performance to ensure data integrity, consistency, and scalability.
- Provide BI technology subject matter expertise and collaborate with risk stakeholders to translate business requirements into technical solutions.
- Implement data security measures and access controls aligned with governance policies.
- Monitor and troubleshoot data pipelines, identify performance bottlenecks, and implement improvements.
- Participate in code reviews and maintain technical documentation.
- Implement and maintain CI/CD pipelines for automated testing, deployment, and monitoring.
Key Skills:
- Strong proficiency in SQL with deep expertise in advanced SQL concepts and techniques.
- Experience working with large-scale, multi-terabyte data warehouses.
- Solid understanding of data warehousing principles, dimensional modelling, and star schema design.
- Hands-on experience with Snowflake, including architecture, features, and best practices.
- Familiarity with ETL/ELT tools and techniques.
- Expert-level experience with Power BI development.
- Experience with Scripting languages such as Python or PowerShell for automation and data processing.
- Experience using dbt (data build tool) for data transformation and modelling.
Salary (Rate): £440/day
City: London
Country: UK
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
Location: London, UK
Work Model: Hybrid (4 days in office)
Duration: 6 Months
Contract Rate: Up to £440/day
About the Team
The Risk Reporting team is responsible for designing and developing technologies that support data warehousing, data mining, Business Intelligence (BI), and reporting solutions across the Group.
The Role
We are looking for an experienced BI Developer to join our Risk Reporting team. You will play a key role in designing and developing scalable data solutions and BI capabilities that support business-critical reporting and analytics.
Key Responsibilities
- Contribute to the design and development of efficient data models, schemas, and pipelines.
- Develop data ingestion and processing solutions using existing frameworks.
- Write complex SQL queries, stored procedures, and functions to extract, transform, and load data.
- Optimize query performance to ensure data integrity, consistency, and scalability.
- Provide BI technology subject matter expertise and collaborate with risk stakeholders to translate business requirements into technical solutions.
- Implement data security measures and access controls aligned with governance policies.
- Monitor and troubleshoot data pipelines, identify performance bottlenecks, and implement improvements.
- Participate in code reviews and maintain technical documentation.
- Implement and maintain CI/CD pipelines for automated testing, deployment, and monitoring.
Essential Skills & Experience
- Strong proficiency in SQL with deep expertise in advanced SQL concepts and techniques.
- Experience working with large-scale, multi-terabyte data warehouses.
- Solid understanding of data warehousing principles, dimensional modelling, and star schema design.
- Hands-on experience with Snowflake, including architecture, features, and best practices.
- Familiarity with ETL/ELT tools and techniques.
- Expert-level experience with Power BI development.
- Experience with Scripting languages such as Python or PowerShell for automation and data processing.
- Experience using dbt (data build tool) for data transformation and modelling.
Desirable Skills
- Experience as a Power BI Developer within enterprise environments.
- Experience working with risk systems in financial institutions.
- Experience with Control-M or similar orchestration tools.
- Familiarity with Agile methodologies and DevOps practices.