We are looking for a Senior BI Engineer to join us and work within the Enterprise Reporting platform. Hands-on engineering contribution is, and remains your primary focus, working within a cross functional platform. As a technical specialist you will bring your design, development, delivery, and operational support experience to bear and deliver outstanding solutions. This is a fantastic opportunity to work collaboratively alongside our existing team of talented solution architects and engineers.

If you are passionate about technology and data engineering, love hands-on development and want to build best in class Business Intelligence (BI) solutions based on the Microsoft Data Platform – you should work with us!

What you’ll be doing:

• Responsible for the design, development, testing, implementation, and maintenance of BI solutions
• Working with your peers you will help identify data engineering best practices and promote their adoption; answering technical and procedural questions from less experienced team members; teaching improved processes; mentoring team members.
• Work closely with the Solution Architect to ensure that designs are practical, workable, and deliverable, and that the technical implementation and the architectural vision remain aligned, particularly in the case where changes are required on either side due to external influences or other constraints.  
• Supporting the Lead Business Intelligence Engineer, to identify risks, issues, and opportunities and collaborate on solutions, championing efficiency and pragmatism throughout the development lifecycle.
• Researching and experimenting with emerging data technologies and industry trends with a view to bringing business value through early adoption.
• Encouraging and driving the use of CI/CD so that solutions are deployable through a transparent and repeatable automated build and release pipelines.
• Responsible for the technical implementation of high-quality, enterprise-grade solutions based on the Microsoft Data Platform. 
• Ensure that each solution is built to the highest standard, is built in a way that favours a simple and maintainable approach over a clever and complex one, is tested at every step on the path to production using the appropriate tools and practices, is deployable using automated tooling only, and is suitably instrumented to meet core operational and business monitoring needs. 
• Demonstrate your passion for engineering by promoting good engineering practices within your team, including any associated disciplines and functional areas, such as QA, DBAs etc. 
• Work with the Engineers and other members of your peer group to ensure that software delivered by your team is built in a way which is technically consistent with - and exploits where possible - the collected learning’s, tools, patterns and practices in place across the wider Engineering community. 
• Seek out and actively promote ideas and techniques in the community – both within ASOS and externally.

What the Successful Candidate Looks Like: 

• Proven experience in a BI Engineering role.
• Proven experience of contributing to highly performing and high-quality solutions through the full application lifecycle.
• Experience and understanding of Agile and XP practices.
• Understanding of non-functional requirements, quality assurance and continued improvement methods.

Key Skills and Experience: 

Essential Skills: 

• Expert in implementing modern BI, ETL and data warehousing technologies.
• Expert knowledge of Microsoft SQL Server and business intelligence tools such as MicroStrategy & Power BI.
• Experience in data-warehousing, dimensional modelling, and dimensional data mart design.
• Experience in design, development, and implementation of Dashboards & Business Intelligence applications.
• Experience with data analysis, trending and KPI development.
• Excellent TSQL skills including SQL query performance optimisation.
• Excellent analytical, problem solving, and communications skills.
• Experience in alerting and monitoring requirements for the platform
• Experience across the delivery lifecycle, an understanding of agile development practices, ideally having worked successfully with agile delivery teams.
• Knowledge of the Microsoft SQL and Data Platform(s), especially:
  • SQL Server
  • Azure SQL Database
  • Azure Storage Services

• Understanding of cloud and on-premises infrastructure concerns 
• Strong understanding of Big Data integration techniques – e.g., how to deal with volume/velocity/variety in a performant way.
• Working knowledge of the tools and practices available and appropriate to each phase of software delivery, such as TDD, BDD, Integration Testing, Performance Testing etc. 
• Responsible for unit, integration, stress/load testing of reports and dashboards to ensure functional and performance requirements are met.
• Broad knowledge of CI/CD tools:
  • Continuous Integration tools such as TeamCity, Jenkins, Azure DevOps build pipelines
  • Automated Deployment and Release Management tools such as Octopus Deploy, Azure DevOps release pipelines.
  • Source control tools such as GIT and Team Foundation Version Control
  • Automated Testing frameworks and unit testing approaches – tSQLt, SpecFlow

Nice to Have:

• Familiarity of Azure Data technologies such as:
  • Azure Synapse Analytics
  • Azure Data Factory v2,
  • Azure Data Lake gen2
  • Azure Databricks
  • Azure Functions
• Agile development background (SCRUM preferred)
• Good scripting skills e.g., PowerShell
• Azure Cosmos DB or equivalent NoSQL databases
• Understanding of Big Data technologies (Hadoop, Spark)
• Experience in retail and/or e-commerce
• Experience working with on and offshore teams.

What's in it for you?

• Truly unique and agile working environment surrounded by a diverse range of passionate experts, with three common interests: our customers, technology and innovation
• Generous salary, bonus and pension-matching, life insurance, free private medical care, cycle to work scheme + much more
• Bespoke flexible benefits scheme catered to your personal needs
• Best in class Learning & Development schemes and career development programmes
• 25 days holiday + never work your birthday again
• Free top-of-the-range onsite gym, plus great value personal training and wellness treatment rooms
• Subsidised canteen facilities with breakfast bar, salad cart, expert chefs and multiple coffee shops
• Tech Develops days – last Friday of the month dedicated to developing yourself and others around Tech including external speakers and exclusive Microsoft training material
• Regular company-wide social events including sports days, charity days, ‘Give A Week Away’ opportunities to visit our charity partners in India, annual celebrations to name just a few
• Huge staff discounts, sample sales and early access to exclusive partnerships”