Data Engineer (SQL)

at  PoloWorks

DESCRIPTION

Reporting to: IT Service Manager
Time commitment: 37.5 hours a week with flexible working
Hybrid working: Flexible with office working of a minimum of 2 days per week.
Salary: Up to £70,000, plus excellent benefits package
Location: Cheltenham/London

SKILLS, KNOWLEDGE AND EXPERTISE

• Experience with custom built data warehousing projects in Microsoft technologies. This should incorporate some knowledge of Kimble design or an equivalent.
• Experience with one or more of the following: data processing automation, data quality, data warehousing, data governance, business intelligence, data visualization, data privacy
• Experience with SQL, ETL, data modelling and at least one programming language (e.g., VB, Java, Python, C++, C#, Scala).
• Experience designing, coding, testing, and correcting complex SQL models and scripts.
• Knowledge of data analysis, data modelling and quality assurance techniques.
• Experience in Azure platform architecture and developing data engineering pipeline in the cloud would be beneficial.
• Experience in ADF and Azure Analysis Services.
• Experience with SSRS, Power BI or similar reporting tools.
• Familiarity with Cloud Virtual machines and the Microsoft Azure security model.
• Familiarity with DevOps deployment pipelines, .Net Windows Services and web forms would be desirable.
• Demonstrates behaviours aligned to the Polo Works PRIDE values:
• Pioneering – we don’t stand still
• Responsible – We do the right thing
• Inclusive – we all play a role
• Delivery Focussed- we provide services we are proud of
• Empowering – we equip people to be their best

• Developing, testing, and documenting complex pipelines from a design specification into the enterprise data warehouse.
• Ensure that agreed standards and tools are utilised to achieve well-engineered outcomes.
• Determine and implement the security model based on privacy requirements, confirm safeguards are followed, address data quality issues, and evolve governance processes within allocated areas of ownership.
• Implementing new Facts and Dimensions within the enterprise data warehouse.
• Assisting with troubleshooting data issues, performance issues, validating result sets, recommending, and implementing process improvements.
• Developing an effective working relationship with members of the wider IT teams, ensuring efficient support of business requirements.
• Participate in reviews of work to ensure developments are standardised, reliable, and maintainable.