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.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