Lead Data Engineer

Location : Basingstoke Office Based or Isle of Man (Hybrid)

Salary : Excellent Salary + Benefits

Seeking career advancement in a rapidly expanding work environment?

Our esteemed client, a prestigious lender, is in search of a Lead Data Engineer, who is responsible for developing ETL/ELT systems for precise data transformation, ensuring a single source of truth for business reporting. Collaborates with the data team and external users, advocating SQL best practices. Leads scalable business-wide data architecture design, acting as a data governance champion to enforce controls and best practices within the group.

Responsibilities :

1. Data Transformation: Develop and maintain ETL/ELT systems, ensuring accurate data transformation into fact and dimension datasets.
2. Single Source Assurance: Ensure datasets serve as a singular source for business reporting, collaborating with power users inside and outside the team.
3. Best Practices Promotion: Collaborate with data team and external users to advocate SQL script and report best practices for efficiency.
4. Architectural Leadership: Lead design of scalable business-wide data architectures to handle evolving demands.
5. Governance Advocacy: Act as a data governance champion, promoting controls for data integrity within the group.
6. Project Technical Leadership: Lead detailed design phases for data projects, identifying and resolving technical issues.
7. Strategic Data Analysis: Assess business needs, researching alternatives for data tech solutions aligned with goals.
8. Documentation and Training: Prepare detailed data specifications, ensuring sufficient documentation and staff training for project success.
9. Report Management: Design and maintain reports and datasets for business needs, ensuring correctness and performance.
10. Enhancements and Support: Manage 3rd party development, coordinate implementations, oversee enhancements, and provide support for databases and data sets, optimizing system performance.

Essential System Skills :

• Microsoft platforms.
• Advanced PowerBI.
• Advanced MSSQL Server /SSIS, SSRS, Modern web technologies and interfacing.
• IT Standards, Methodologies & audit requirements.
• VBA / MSSQL / batch scripting, database administration and management skills.

Desirable System Skills :

• HTML, TFS, JavaScript, ASP.NET.
• Microsoft SharePoint.
• Data Warehouse experience.
• Microsoft Azure.
• Artificial Intelligence for data.
• Application Programming Interface (API) experience.
• Python programming.
• Azure Data Factory