Jobs

SQL Warehouse Developer (Data Engineer)


Job details
  • Irwin Mitchell
  • Birmingham
  • 1 month ago
Applications closed

Your Role

The SQL Warehouse Developer is responsible for the design, development, and maintenance of data warehouse solutions for Irwin Mitchell. They understand requirements, create technical designs, configure applications, write code, and conduct testing. They collaborate with various teams, participate in meetings, and provide technical advice to address concerns. They troubleshoot and resolve technical issues, debug code, investigate failures, support end-users and the maintenance of the solutions. They document the data warehouse development process, including technical specifications. Collaboration with other engineers, testers, and project managers is crucial for successful delivery. They ensure quality and reliability by conducting thorough testing, performing code reviews, and implementing best practices in data warehouse development.

The SQL Warehouse Developer role is a key part in accelerating data value creation at IM and unlocking data’s potential, enabling improved data driven decisions and advanced analytics. This role will ensure IM’s data is optimised to support the needs of colleagues and Clients.

This role will contribute creating an aspirational data culture and underpins a critical pillar of the IM data estate.

What You'll Be Doing 

Designing, developing, optimizing, and maintaining ETL processes and data warehouse solutions using SQL and SSIS (SQL Server Integration Services). Collaborating with cross-functional teams to understand complex data requirements and translating them into efficient data models and ETL processes. Implementing data integration and transformation workflows to extract, clean, and load data from various sources into an on-premise SQL Datawarehouse. Monitoring, updating and optimising existing ETL processes, understanding and documenting current solutions. Mentoring and providing technical guidance to junior developers, ensuring adherence to best practices and driving continuous improvement. Collaborating closely with BI developers and analysts to understand their requirements and providing data warehousing support for their projects. Monitoring and troubleshooting ETL processes, ensuring data integrity, availability, and security.

About You Proven experience as a SQL Developer or Data Engineer, with experience of SQL, SSIS and Data Warehousing. Expertise in T-SQL / SQL server for data warehousing tasks, including data extraction, transformation, and loading. Experience with BI development tools (i.e. Tableau, Power BI and Crystal Reports) to enable understanding and support of existing BI solutions. In-depth understanding of data modelling, ETL development, and data integration techniques. Experience of Agile working practices Strong documentation skills, experience of using Git and Azure DevOps repositories for version control. SQL server security experience Experience of working within a Professional services firm Our Benefits - What We Can Offer You 25 days holidays as standard plus bank holidays - You can ‘buy’ up to 35hrs of extra holiday too. Generous and flexible pension schemes. Volunteering days – Two days of volunteering every year for a cause of your choice (fully paid) Westfield Health membership, offering refunds on medical services alongside our Aviva Digital GP services.

We also offer a wide range of well-being initiatives to encourage positive mental health both in and out of the workplace and to make sure you’re fully supported. This includes our Flexible by Choice programme which gives our colleagues more choice over a hybrid way of working subject to role, team and client requirements.

We have been ranked in the Best Workplaces for Wellbeing for Large Organisations for 2024!

Our responsible business programmes are fundamental to who we are and our purpose. We’re committed to being a diverse and inclusive workplace where our colleagues can flourish, and we have established a number of inclusion network groups across our business to support this aim. 

Our commitment to Social Responsibility, community investment activity and tackling climate change is a fundamental part of who we are. It’s made up of four strands: Our People, Our Community, Our Environment and Our Pro Bono.

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Data Warehouse Developer (T-SQL, SSIS)

An exciting opportunity has arisen for an experienced Data Engineer / Data Warehouse Developer to join a well-established Financial Services organisation in Central London - they operate a hybrid working model, and you will spend 3 days per week in their modern office to collaborate with your team.Following a recent...

London

Data Warehouse Developer (On-premise)

An exciting opportunity has arisen for an experienced Data Engineer / Data Warehouse Developer to join a well-established Financial Services organisation in their Central London office - they operate a hybrid working model, and you will spend 2-3 days per week in their modern office to collaborate with your team.Following...

London

Data Warehouse Developer

An exciting opportunity has arisen for an experienced Data Engineer / Data Warehouse Developer to join a well-established Financial Services organisation in Central London - they operate a hybrid working model, and you will spend 2-3 days per week in their modern office to collaborate with your team.Following a recent...

Tenth Revolution Group London

Data Engineer Leicester / Hybrid

Data Engineer Leicester HybridMy client based is Leicester is growing! After successfully hiring a number of developers it's the Business Intelligence Teams turn!Working in the BI team this role will see you using modern toolsets within the Microsoft Stack to manage day to day integration, developer ETL processes and enable...

Leicester

Scala Developer

Job Advert: Scala Developer / Engineer (Banking Sector)Location: NorthamptonJob Type: FTEWork Model: HybridWe are seeking a skilled Scala Developer to design and develop high-performance, scalable data processing applications for a banking sector client. If you're passionate about building data-intensive systems and solving complex challenges with Big Data technologies, this role...

Northampton

BI Developer

Triple Wimbledon champion Fred Perry founded his brand in 1952. He was the son of a cotton spinner, who played and fought his way through, always with style – and despite the establishment. Today, Fred Perry is a global community of over 370 employees, all inspired by the Laurel Wreath...

Fred Perry London