Data Analyst Python Sql Jobs in State College, PA

43k - 50k, salary dependant on skills and experience

Base location in either Lincoln or Huntingdon (depending on your location) and home working (expectation is 2 days in the office)

Permanent

Full time, 37 hours per week

Do you have prior experience of Enterprise Data Engineering, dimensional modelling?

Do you have experience of working within an Agile environment or are keen to work in one?

Do you like to always explore, learn, challenge yourself and are a good team player?

If you can answer yes to the above we have an exciting opportunity for you with our expanding team!

The Data and Digital Services team will transform the way data and digital services are provided in Anglian Water, moving from an order-taker service to a trusted, informed partner. The data service will go beyond the traditional data warehouse to provide a modern business intelligence capability that supports distributed (crowd-sourced) reporting and analytics, allowing business SMEs and data and analytics SMEs to work hand in hand to deliver insight to drive business performance. The team will keep the BI service in step with emerging technologies and practices to ensure their activities continue to align to externally recognised best practices.

What will my role involve?

The Enterprise Data Engineer is a T-shaped professional (also referred to as a generalised specialist) with identifiable core skills yet with an ability to work across multiple disciplines (both technical and non-technical) as required.

The Enterprise Data Engineer whilst having core skills to enable them to deliver data and analytical solutions on our analytics and big data platform, you will also act as a technical expert in all aspects of delivery and provide leadership and guidance to small project teams/resources in a collaborative way.

You will be expected to work in Agile/Scrum environment in a squad model consisting of various other developers. You may be expected to work as lead on the squad and/or fulfil other roles within the squad.

The Enterprise Data Engineer will have the core skills to be able to carry out following activities:

• Actively contribute to work estimation

• Adopt and embed agile development and continuous improvement into team ways of working

• Support the on boarding of new team members & coach other Data Engineers

• Actively contribute to drafting and updating our service policies, procedures, work instructions and guidance notes.

• As a BI Solution Architect/Dimensional Modeller, design robust, secure and supportable corporate data solutions to meet business requirements following dimensional modelling methodology, considering privacy by design and self-service capabilities by default.

• As an ETL Developer, develop, test and/or quality assure extracts of data from corporate systems into the Data Lake

• As a Semantic Layer Developer, develop, test and/or quality assure semantic models

• As a Report Developer, develop, test and/or quality assure reports, visualisations and dashboards, producing lo-fi and hi-fi wireframes and capturing purpose.

• As a Test Automation Specialist, responsible for building new automated test frameworks, for developing test harnesses for each component and be responsible for raising the overall test coverage across the project. would work with each squad to ensure the culture of automated testing is embraced and that any technical challenges are resolved. These processes are essential to building robust delivery pipelines if the solution is to adopt modern DevOps processes.

What does it take to be a Data Engineer?

• Previous experience in data engineering ideally using Databricks, Azure Data Factory, Spark, Python, SQL, Cosmos DB, Microsoft Azure Analysis services, PowerBI

• Dimensional data modelling

• Experience in delivering end to end BI solution from requirements, design to delivery

• Experience of working within an Agile/Scrum environment

• Experience/understanding of Product lifecycle management

• Knowledge of Azure DevOps or similar tools

As a valued employee, you'll be entitled to:

• Personal private health care

• 26 days annual leave - rising with length of service

• Flexible working

• Pension scheme - Anglian Water double-matches your contributions up to 6%

• Bonus scheme

• Flexible benefits to support your wellbeing and lifestyle.

Why Anglian Water?

Anglian Water is not your typical water company. What we do really matters. Water is the lifeblood of our world and we're proud of the difference we make. We put people at the heart of our business and we truly love what we do! If you're passionate about what you do and would like to make a difference then we'd love to hear from you.

Inclusion at Anglian Water: Join us and make a difference. Our customers come from a wide range of backgrounds, and we think our workplace should reflect that. We are committed to making sure all our colleagues feel they belong and are supported to succeed. Together with our fellow water companies, we are committed to the Social Mobility Pledge; we are also a signatory to Business in the Community's Race at Work charter; we hold the Armed Forces Gold Covenant for Employers; we are an accredited Disability Confident employer and we play a leading part in the Women's Utility Network.

#loveeverydrop