Data Engineer (Team Blossom)
Department: IT
Employment Type: Permanent - Full Time
Location: Home United Kingdom
Reporting To: Steven Smith
Description
SSRS, SSIS, SQL and Power BI experience is essential
Do you want to work for a forward-thinking, award winning in-house software development team?
As a Data Engineer you will be involved in the design, development and delivery of full data solutions, in particular data reporting, using the Microsoft BI stack. You will have strong T-SQL skills and Performance Dashboard development. In particular you will have strong skills in creating SSRS reports and in data visualisation tools such as Power BI, and will also hold experience of developing and maintaining Data Warehouses.
You must have strong experience of developing in Visual Studio database solutions and releasing changes via Azure DevOps automated deployments, with experience of creating and running unit tests and be able to mentor and guide other members of the team towards an automated test-driven approach. You will work with members of the business to capture requirements and help shape the development of the reports and dashboards.
You will be part of a great team who love new technologies. We have a fast-growing working environment, where we empower and trust our team to work independently whilst also pulling together to achieve our objectives.
Key Responsibilities
- Responsible for the design and development of data solutions across the company.
- Deliver and maintain performance dashboards to operational teams and external customers to ensure business access to essential data.
- Deliver and maintain SSRS reports to ensure business and customer access to essential MI/BI.
- Contribute to the design and development of new solutions using Power BI.
- Define, update and adhere to software development patterns and standards.
- Provide technical assistance, support and development skills across the company.
- You must have experience in developing in Visual Studio and Azure DevOps pipelines in Test Driven Development, we are looking for someone who can help us introduce and instil that mind-set in the rest of the team.
- Liaise with third party software providers throughout the lifecycle - including design, development, support and maintenance, ensuring best practise.
We are looking for someone who has gained experience in a variety of different tools and implementations who is capable of making informed choices. You will have extensive experience of working within a team.
Performance Competencies:
- Highly numerate with previous experience in delivering BI reporting solutions.
- Good T-SQL skills are essential.
- Good understanding of data warehousing, ETL and database concepts.
- Good experience of Microsoft BI technologies.
- Experience in delivering complex reporting solutions.
Essentials:
- Microsoft stack
- SQL Server 2008/12/16
- SSIS
- SSRS
- Power BI
- SQL Server Unit Tests
- Azure DevOps
- Visual Studio
- CI/CD Pipelines
- Azure SQL
- Azure Data Factory
Job Benefits
- Davies Incentive Plan
- 25 days holiday per year which increases with level of service (opportunity to buy & sell 3 days)
- Family Cover Private Medical Insurance (Bupa) - will automatically be at single cover level but can opt into family option within first month of joining
- Simply Health Care Cash Plan
- WeCare - 24/7 online GP, mental health support and virtual wellbeing covering a whole host of topics to do with health, mental health, wellbeing & healthy living and financial & legal wellbeing
- Death in Service
- Critical Illness Cover
- PHI/Income Protection (Private health insurance)
- Pension Contribution based 5% Employee / 3% Employer
- Cycle to Work Scheme*
- Tech Scheme*
- Season Ticket Loan*
- Gym Flex*
- Access to Online Discount Sites
- Discounted Gourmet Society Membership
- Discounted Tickets for Merlin Attractions nationwide
- Discounts at local retail outlets