
Operational Data Analyst Milton Keynes, England
Job description
We’re looking for an Operational Data Analyst to join our IT Systems Integration team in Leighton Buzzard or Milton Keynes supporting our business. This role will be an expansion to an already existing well established team of DBAs/Engineers and Analysts ready to support the Group’s expansion.
You will be working with some very talented people who are always looking to move forward with the latest and greatest technology, this role will demand great attention to detail and an analytical mind-set. It will be a chance for someone who is looking to get into the data world or expand on their analytical knowledge and mind-set with a new challenge.
This role will be supported with a training and personal development scheme offering you the opportunity to earn £3,000 per qualification up to 2 qualifications over a 12 month plan period.
Key responsibilities of the Operational Data Analyst:
- Understanding and maintaining data quality of system and operational databases.
- Understanding and aligning the group JML process.
- Manage and maintain the group GDPR data processes.
- Support ad-hoc report generation or data extracts via T-SQL queries.
- Responsible for managing all Operational Service reporting in SSRS and PowerBI.
- Interpret written functional requirements and technical specification documents and translate into reporting deliveries
- Manage the IT Operational Data Warehouse and develop new schema for additional systems.
Experience & skills required to be successful as an Operational Data Analyst:
- Data Analytics skills.
- Understanding complex JML processes.
- T-SQL skills.
- Strong working knowledge of Data Analytic languages R, M-Query.
- Experience with SQL Server Reporting Services (SSRS).
- Advanced Microsoft Excel skills.
- Knowledge of data warehousing and different schema methodologies.
Desirable skill of the Operational Data Analyst:
- Understanding of advanced bespoke T-SQL data collection solutions.
- Exposure to MySQL &; Oracle.
- Experience with SSIS and ETL Processing.
- Functional knowledge of SSAS and multi-dimensional analytical development.
- DBA/DBD operational experience.
Connells Group is one of the largest and most successful estate agency and property services providers in the UK and as of March 2021 also encompasses Countrywide. Founded in 1936 and with a network of over 1,200 branches nationwide, the Group combines residential sales and lettings expertise with a range of consumer and corporate services including new homes, mortgage services, conveyancing, EPC provision, surveying, corporate lettings, asset management, land & planning, LPA receivers and auctions.
Connells Group UK is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, transgender status, religion or belief, marital status, or pregnancy and maternity.
Don’t meet every single requirement? Studies have shown that women and people of colour are less likely to apply to jobs unless they meet every single qualification. At Connells Group we are dedicated to building a diverse, inclusive and authentic workplace. So if you’re excited about this role but your experience doesn’t fit perfectly with every aspect of the job description, we encourage you to apply anyway. You may be just the right candidate for this or other opportunities.
Job Reference: CF00104
