Database Developer / Data Engineer (SQL / SSIS)

Worcester Permanent £35,000 - £40,000 per year
  • Opportunity to work on a major Data Transformation Programme
  • Opportunity to influence and enhance insight & analytics strategy

About Our Client

Large Government Organisation

Job Description

Large Government Organisation require a Database Developer / Data Engineer to support on a data transformation and data analytics enhancement programme. You will work in a team to support Analysts to generate new insight and reports in Power BI whilst working with the IT function on their journey in transition to MS Azure.Key Responsibilities:

  • Support the Design, development and maintenance of new Business Intelligence capabilities in line with the organisations analytics strategy and vision.
  • Support the analytical community by providing access to data sources, building and maintaining semantic access layers.
  • Work on Data Transformation from SAP Business Objects to MS Power BI with further adoption of the MS Stack leading to Azure Cloud Transformation in the future.
  • Utilise SSIS / ETL tools to create access to new data sets for analytics in Power BI
  • Capture and translate business requirements into specifications, then implement appropriate data access to allow analysts to create the required reports and dashboards.
  • Adhere to IT change processes, acting as a conduit between IT and Strategy, Planning and Insight.
  • Develop and configure Business Objects Universes; including appropriate development and testing approaches.
  • Develop and configure PowerBI datasets and workspaces.
  • Working with others to develop and document domain knowledge of key systems in support of maximising the value of the data available.
  • Working with the Data Management function to understand and remediate data quality issues.

Key skills / Experience

  • A degree, or equivalent in a relevant field.
  • A solid understanding of Business Intelligence toolsets, and how they fit in to end-to-end data infrastructure.
  • Strong knowledge of SQL, SSIS (or similar ETL tools) and Power BI
  • Data literacy; development of domain knowledge.
  • Knowledge of logical and physical data modelling concepts.
  • Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures.
  • Comprehensive knowledge of analytical processes, techniques and skills.
  • Hands on development of BI tools and development of analytical products.



Experience of data warehousing solutions would be an advantage

The Successful Applicant

  • A degree, or equivalent in a relevant field.
  • A solid understanding of Business Intelligence toolsets, and how they fit in to end-to-end data infrastructure.
  • Strong knowledge of SQL, SSIS (or similar ETL tools) and Power BI
  • Data literacy; development of domain knowledge.
  • Knowledge of logical and physical data modelling concepts.
  • Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures.
  • Comprehensive knowledge of analytical processes, techniques and skills.
  • Hands on development of BI tools and development of analytical products.
  • Experience of data warehousing solutions would be an advantage

What's on Offer

Opportunity to work on a major Data Transformation Programme

Contact
James Hobson
Quote job ref
JN-052024-6413916
Phone number
+44 117 906 5144

Job summary

Job function
Technology
Subsector
Business Intelligence
Sector
Technology & Telecoms
Location
Worcester
Contract type
Permanent
Consultant name
James Hobson
Consultant phone
+44 117 906 5144
Job reference
JN-052024-6413916