BASIC FUNCTION OF THE JOB (Position Description): Description: Role is responsible for working with the Fuels Value Chain organization, translating business requirements into fit-for-purpose data solutions, designing logical and physical data models, performing data profiling to understand data transformation and harmonization requirements, design data integration and ingestion procedures, design data consumption views/APIs, produce and maintain comprehensive documentation of processes, operating procedures and service standards, seek and implement opportunities for automation or efficiency to increase organizational effectiveness. Activities include: - Design system specific data models (logical and physical) with input from Solution/System/Data Architect - Work with Research & Engineering resources to understand how data is or should be structured to allow for a sustainable and scalable data platform - Design data ingestion/integration pipelines, considering aspects of full vs. incremental loads, how to handle slowly changing dimensions, unique identifiers for merge processes - Design data movement/curation/transformation procedures - Design data consumption views/APIs as per consumer’s requirements (business organizations and data scientists) - Execute data profiling on source data, to drive harmonization/contextualization of disparate data sets - Provide input into business data glossary / data catalog (Collibra/Data Dash) and logical data models (ER/Studio); help maintain and steward technical metadata - Provide input to address data quality issues and provide technical data quality remediation plans for systems (in partnership with Data Architects and Business SMEs) Skill Qualifications Required Advanced Level of Technical Competencies: - Creating or editing database models (logical and physical) using ERD tools such as ER/Studio. - Deep understanding of Data Integration patterns - Advanced database handling languages (SQL and variants) - Experience working with data dictionarys, data maps, taxonomies - Solid knowledge of Data Governance & Management Concepts (MDM, Data Quality) - Working understanding of BI and Data visualization tools (eg. Tableau) Preferred (Beginner to Expert) Technical Competencies: Competencies in one or more of the following areas: - Data manipulation tools such as: SSMS, SSIS, TOAD, Access, Excel - Experience in creation of new databases, data lakes, data warehouses, etc., (on-prem or cloud) - Experience working with data integration/replication tools such as: ADF, Qlik Replicate, Fivetran - Working understanding of APIs - Strong communication and interpersonal skills with strong English proficiency - Demonstrate critical thinking, analytical skills, and employ judgment to offer thoughtful, concise input toward resolutions of problems - Be able to translate business processes into data requirements - Leadership skills needed to successfully promote ideas, coordinate work activities, and plan deliverables within a project team. - Minimum Bachelor’s Degree in Engineering Technology, Computer Science, or a related field with equivalent experience - Pays attention to detail and is meticulous in his/her work - Able to work independently and in a team COMPUTING ENVIRONMENT - ADO for team work plan - Cloud-based tools (Azure, Snowflake, Cloudera) - MS Office software Scope of Work specific to this Assignment: Role is responsible for working with the Fuels Value Chain organization, translating business requirements into fit-for-purpose data solutions, designing logical and physical data models, performing data profiling to understand data transformation and harmonization requirements, design data integration and ingestion procedures, design data consumption views/APIs, produce and maintain comprehensive documentation of processes, operating procedures and service standards, seek and implement opportunities for automation or efficiency to increase organizational effectiveness.