Overview
This range is provided by Lithium3 IT Consulting Limited. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range
Direct message the job poster from Lithium3 IT Consulting Limited
Role
Director/Founder - Data, ERP, Business/Digital Transformation
SQL Developer or Senior Data Analyst or Data Engineer, SQL Azure V12, SQL, Relational databases, ETL, SSIS, SSMS, Analytical and problem solving softer skills.
This role is 2 days a week in the office and 3 days remote working. You can either be based in Cambridge or Sheffield, so candidates commutable to either location is fine.
Lithium3 are working with our client exclusively to recruit a Senior Data Engineer (Who could also be a Senior Data Analyst or SQL Developer background) to join their established team who sit between the main Enterprise Data Warehouse Build function and the visualisation team for reporting. This individual will be responsible for managing, maintaining expanding and optimising the data pipeline and architecture, and supporting end users through data and report delivery. This team is very much doing Projects, working with technical and non-technical stakeholders on business problems providing Data solutions. Project examples might be managing trade profit data in the ERP and POS systems or creating a Pricing Control system. Our client is in the final stages of migrating to Azure BI Platform.
The ideal candidate for the role will need to have extensive experience of data interface design and delivery, ETL processes and data modelling and will enjoy optimising data systems and building them from the ground up. They will support our MI colleagues in the delivery of reports, dashboards and data sets using a variety of tools, including but not limited to SSMS, SSIS, MS Excel, MS Access and will ensure robust, automated and efficient data pipelines are in place for our data Visualisation Team to use through Power BI. You must be self-directed and comfortable supporting the data needs of multiple teams, users and systems and relish the opportunity to. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.
Responsibilities
* Managing, maintaining, expanding and optimising the data pipeline and architecture.
* Supporting end users through data and report delivery.
* Working with technical and non-technical stakeholders on business problems providing data solutions.
* Examples include managing trade profit data in ERP/POS systems or creating a Pricing Control system.
* Collaborating during migration to Azure BI Platform.
* Supporting MI colleagues in the delivery of reports, dashboards and data sets.
Qualifications
* Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) as well as familiarity with a variety of database technologies (including SQL, Access).
* Experience building and optimising ETL processes, data pipelines, architectures and data sets.
* Experience performing root cause analysis and resolving issues in relation to internal and external data and processes to answer specific business questions and identify opportunities for improvement.
* Strong analytic skills related to working with structured and unstructured datasets.
* Build processes supporting data transformation, data structures, metadata, dependency and workload management.
* Data modelling and database design experience
* Understanding of and exposure to Operational Data Stores, Data Warehouses, Data Lakes and similar structured data sources and targets in delivering data to end users
* Strong project management and organisational skills.
* Experience supporting and working with cross-functional teams in a dynamic environment.
* Experience of SSIS, SSRS, SSMS, Power BI and an expert SQL query writer.
* Experience of creating ad-hoc data sets and SQL reports for end users
* A successful history of manipulating, processing and extracting value from large disconnected datasets.
* Experience of using agile delivery methodologies
* Experience of creating high-quality technical documentation.
Benefits & Other
* 3 month notice clauses are acceptable.
* Benefits include 25 days holiday + BH, 7.5% pension.
* Lithium3 and our client are an Equal Opportunities Employer.
* By applying for this role your details will be submitted to Lithium3.
* Our Candidate Privacy Information Statement on our website explains how we will use your information.
Seniority level
* Associate
Employment type
* Full-time
Job function
* Analyst
* Industries
* IT Services and IT Consulting
Referrals increase your chances of interviewing at Lithium3 IT Consulting Limited by 2x
Get notified about new SQL Developer jobs in Cambridge, England, United Kingdom.
Cambridge, England, United Kingdom 9 months ago
Cambridgeshire, England, United Kingdom 2 weeks ago
Cambridge, England, United Kingdom 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr