Sr. Data Modeler ( 100% Remote)

Sr. Data Modeler

Location: Remote

Duration: 12 Months

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)

Required Advanced Level of Technical Competencies:

• Creating or editing database models (logical and physical) using ERD tools such as ER/Studio.
• Sound data analysis and design skills for both, transactional and data warehousing solutions, adequately applying context-based concepts of (de-)normalization
• Deep understanding of Data Integration patterns
• Advanced database handling languages (SQL and variants)
• Experience working with data dictionaries, data maps, taxonomies
• Knowledge of Data Governance & Management Concepts (MDM, Data Quality)
• Working understanding of BI and Data visualization tools (eg. Tableau)

Competencies in one or more of the following areas:

• Data manipulation tools such as: SSMS, SSIS, TOAD, Access, Excel
• Experience in the creation of new databases, data lakes, data warehouses, etc.