Senior Data Engineer- MiddlesbroughContract type: Permanent
Start date: TBC
Salary: Competitive Salary + benefits
We are the leading provider of infrastructure services. At Altrad, we transform our nation's critical infrastructure to operate safely and sustainably. With over 11,000 talented people, we provide the full spectrum of critical engineering and construction services for industries both onshore and offshore.
Join a Leading Organisation in the Nuclear Industry
Role details:This role is responsible for supporting the development of business intelligence solutions using Microsoft PowerBi to the business. Altrad has a mature reporting environment that is aligned with the Microsoft application stack and works using the Agile Scrum Development methodology.
Activities include:- Various Integration activity (ETL) using Azure Data Factory, SSRS and C#. Connecting multiple data sources to our Datawarehouse and integration into the Altrad data model.
- Data Modelling activity is SQL and PowerBi in designing robust curated datasets.
- Visualisation of key priority reporting and supporting an empowered userbase in creating their own visuals.
Key Responsibilities:- Help lead the development Altrad BI Solution Architecture, Replication Wearhouse and secure data sets using the Microsoft application stack.
- Create and evolve secure data sets for all systems that you make available to Key users in the production of their reports.
- Undertake ETL integrations and support tasks using ADF and other technologies.
- Coach and mentor junior BI professionals.
- Testing and modifying new data sets and reports created by Key Users to ensure that they operate reliably, and changes do not disrupt operations.
- Resolve data integrity, quality and robustness challenges with legacy/system data to encourage quality and transformation reporting.
- Develop and update BI process maps that form the basis of the system Architecture and configuration.
- Drive excellence through effective and efficient use of systems.
- Understand and document business requirements over the short, medium and longer term.
- Consult through lesson learned sessions with End Users, Key users and Process Owners to ensure that functionality and configuration meets evolving business requirements.
- Develop and maintain consistent solutions across our approved application suite.
- Maintain confidentiality with sensitive data/information.
- Build and maintain workflows and process automation.
- Support other Business Systems Analysts and leads in digital transformation projects.
Key Requirements:- 5 years' experience as a business intelligence analyst/developer or related role.
- Experience with SQL Management Server, SSRS, SSIS and other related systems.
- Experience with Microsoft Azure stack and related technology such as ADF, Logic Apps, Data Lake, Data Bricks, Power Query etc.
- Experience in Low code MS related technologies, SharePoint, Nintex, Power Apps, Power Bi etc.
- ETL related experience using SSIS, ADF or similar products to undertake complex integrations.
- Experience in the role of a DBA or DBA related activities.
- Relevant further qualification in business analytics related field.
- Strong technical acumen and the ability to analyse complex situations and effectively solve problems and drive an excellence culture.
- Understanding of GDPR and good practice of complex data management.
- Strong communication skills and able to effectively work with varying stakeholders.
- Pragmatic approach, able to balance the ideal with the reality of what is needed today.
- Demonstrable ability to thrive in a complex, rapidly changing and demanding globally integrated (but not centralised) business environment.
- Experience/knowledge of the Agile Scrum development methodology.
Why Join Us?- Work on high-impact projects within a leading organisation at the forefront of the industry.
- Competitive salary and benefits package.
- Opportunities for career growth and professional development.
- Collaborative and dynamic work environment with a focus on innovation and excellence.