BI Developer

Consultant

Summary of the role purpose 

We need to invest in managing data as the asset it is, so it is findable, accessible, interoperable, reusable, and protected across Group applications. Data is foundational to achieving our ambition to be trusted to make the difference for our clients, people and society. We must ensure data is trustworthy and trusted, so we can innovate, use cutting edge technology and create value for our firm and our clients.

Part of the Chief Data Office in Group Digital, the Data Governance discipline sets out the framework for authority, control and shared decision making over the management of data assets. Data Governance guides all other data management disciplines to ensure strategy, policy, stewardship and culture support availability, usability, integrity, and security of data throughout its lifecycle.

The Data Governance Senior Developer will support these ambitions through use of technical solutions to help colleagues across the firm to understand, connect and govern the core data and information relied on to support our business operations, fostering trust and supporting growth.  

Key responsibilities

• Develop and and oversee implementation of technical solutions to support data and information cataloguing, classification, quality and discovery.

• Working with stakeholders to confirm business requirements and test approaches and solutions.

• Provide subject matter expertise and technical leadership to colleagues for our chosen data technologies as required.

• Champion and explore use of AI within our chosen data technologies to improve data management processes. 

• Development of tools and products to help business stakeholders engage e.g. dashboards and remediation tools.

Technical Skills:

 Must have:

1. Experience working with Informatica suite of data governance tools (preferably Cloud - IDMC). 

   • knowledge on out of the box transformations available exclusively in Informatica such as Parser, Key generator, Match, Labeler, Standardizer, Address doctor, in addition to the PowerCenter transformations etc.

   • Experience creating profiles/scorecards

   • Knowledge on PDO/CDO/LDO,

2. Experience in SQL 

3. Expertise in Cloud Data Integrations and API integrations with strong knowledge on APIs. 

4. Experience of working in a data management role as part of a multi-disciplinary team.

5. Appreciation of related data disciplines and concepts such as data profiling, DQ dimensions, Facts, dimensions, data granularity, data cleansing, metadata management, data lineage, exception remediation, SCD’s etc.

Good to have:

1. Experience of working with other data governance tools available in the market. 

2. Experience of Cloud data platforms (preferably Microsoft suite – Azure SQL, Databricks, Blob Storage, Databricks and Data factory).

3. Knowledge of Data warehousing and Data engineering concepts.

4. Familiar with DevOps models and Agile methodologies.

Personal Skills:

1. Effective communication – ability to communicate ideas and concepts clearly, articulate technical challenges in a non-technical language and to listen to others, engaging in discussions with an open mind.

2. Team player - Ability to work within a team and adapt as required to achieve shared goals, with a willingness to learn from colleagues.

3. Decision making - Ability to assess situations, consider various perspectives, and decide on the right move forward for the benefit of the team or project.

4. Problem-solving – innovative thinking on options to overcome challenges and articulating these to the wider team.

5. Delivery of outcomes – proactive approach to tasks and projects, focus on the end goal, influencing others as required.

Summary of the role purpose 

We need to invest in managing data as the asset it is, so it is findable, accessible, interoperable, reusable, and protected across Group applications. Data is foundational to achieving our ambition to be trusted to make the difference for our clients, people and society. We must ensure data is trustworthy and trusted, so we can innovate, use cutting edge technology and create value for our firm and our clients.

Part of the Chief Data Office in Group Digital, the Data Governance discipline sets out the framework for authority, control and shared decision making over the management of data assets. Data Governance guides all other data management disciplines to ensure strategy, policy, stewardship and culture support availability, usability, integrity, and security of data throughout its lifecycle.

The Data Governance Senior Developer will support these ambitions through use of technical solutions to help colleagues across the firm to understand, connect and govern the core data and information relied on to support our business operations, fostering trust and supporting growth.  

Key responsibilities

• Develop and and oversee implementation of technical solutions to support data and information cataloguing, classification, quality and discovery.

• Working with stakeholders to confirm business requirements and test approaches and solutions.

• Provide subject matter expertise and technical leadership to colleagues for our chosen data technologies as required.

• Champion and explore use of AI within our chosen data technologies to improve data management processes. 

• Development of tools and products to help business stakeholders engage e.g. dashboards and remediation tools.

Technical Skills:

 Must have:

1. Experience working with Informatica suite of data governance tools (preferably Cloud - IDMC). 

   • knowledge on out of the box transformations available exclusively in Informatica such as Parser, Key generator, Match, Labeler, Standardizer, Address doctor, in addition to the PowerCenter transformations etc.

   • Experience creating profiles/scorecards

   • Knowledge on PDO/CDO/LDO,

2. Experience in SQL 

3. Expertise in Cloud Data Integrations and API integrations with strong knowledge on APIs. 

4. Experience of working in a data management role as part of a multi-disciplinary team.

5. Appreciation of related data disciplines and concepts such as data profiling, DQ dimensions, Facts, dimensions, data granularity, data cleansing, metadata management, data lineage, exception remediation, SCD’s etc.

Good to have:

1. Experience of working with other data governance tools available in the market. 

2. Experience of Cloud data platforms (preferably Microsoft suite – Azure SQL, Databricks, Blob Storage, Databricks and Data factory).

3. Knowledge of Data warehousing and Data engineering concepts.

4. Familiar with DevOps models and Agile methodologies.

Personal Skills:

1. Effective communication – ability to communicate ideas and concepts clearly, articulate technical challenges in a non-technical language and to listen to others, engaging in discussions with an open mind.

2. Team player - Ability to work within a team and adapt as required to achieve shared goals, with a willingness to learn from colleagues.

3. Decision making - Ability to assess situations, consider various perspectives, and decide on the right move forward for the benefit of the team or project.

4. Problem-solving – innovative thinking on options to overcome challenges and articulating these to the wider team.

5. Delivery of outcomes – proactive approach to tasks and projects, focus on the end goal, influencing others as required.

Summary of the role purpose 

We need to invest in managing data as the asset it is, so it is findable, accessible, interoperable, reusable, and protected across Group applications. Data is foundational to achieving our ambition to be trusted to make the difference for our clients, people and society. We must ensure data is trustworthy and trusted, so we can innovate, use cutting edge technology and create value for our firm and our clients.

Part of the Chief Data Office in Group Digital, the Data Governance discipline sets out the framework for authority, control and shared decision making over the management of data assets. Data Governance guides all other data management disciplines to ensure strategy, policy, stewardship and culture support availability, usability, integrity, and security of data throughout its lifecycle.

The Data Governance Senior Developer will support these ambitions through use of technical solutions to help colleagues across the firm to understand, connect and govern the core data and information relied on to support our business operations, fostering trust and supporting growth.  

Key responsibilities

• Develop and and oversee implementation of technical solutions to support data and information cataloguing, classification, quality and discovery.

• Working with stakeholders to confirm business requirements and test approaches and solutions.

• Provide subject matter expertise and technical leadership to colleagues for our chosen data technologies as required.

• Champion and explore use of AI within our chosen data technologies to improve data management processes. 

• Development of tools and products to help business stakeholders engage e.g. dashboards and remediation tools.

Technical Skills:

 Must have:

1. Experience working with Informatica suite of data governance tools (preferably Cloud - IDMC). 

   • knowledge on out of the box transformations available exclusively in Informatica such as Parser, Key generator, Match, Labeler, Standardizer, Address doctor, in addition to the PowerCenter transformations etc.

   • Experience creating profiles/scorecards

   • Knowledge on PDO/CDO/LDO,

2. Experience in SQL 

3. Expertise in Cloud Data Integrations and API integrations with strong knowledge on APIs. 

4. Experience of working in a data management role as part of a multi-disciplinary team.

5. Appreciation of related data disciplines and concepts such as data profiling, DQ dimensions, Facts, dimensions, data granularity, data cleansing, metadata management, data lineage, exception remediation, SCD’s etc.

Good to have:

1. Experience of working with other data governance tools available in the market. 

2. Experience of Cloud data platforms (preferably Microsoft suite – Azure SQL, Databricks, Blob Storage, Databricks and Data factory).

3. Knowledge of Data warehousing and Data engineering concepts.

4. Familiar with DevOps models and Agile methodologies.

Personal Skills:

1. Effective communication – ability to communicate ideas and concepts clearly, articulate technical challenges in a non-technical language and to listen to others, engaging in discussions with an open mind.

2. Team player - Ability to work within a team and adapt as required to achieve shared goals, with a willingness to learn from colleagues.

3. Decision making - Ability to assess situations, consider various perspectives, and decide on the right move forward for the benefit of the team or project.

4. Problem-solving – innovative thinking on options to overcome challenges and articulating these to the wider team.

5. Delivery of outcomes – proactive approach to tasks and projects, focus on the end goal, influencing others as required.