Database Developer / Data Engineer SQL / SSIS

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.

Client Details

Large Government Organisation

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

Profile

• 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

Job Offer

Opportunity to work on a major Data Transformation Programme