Sr. Data ModelerLocation: RemoteDuration: 12 MonthsRole 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 ArchitectWork with Research & Engineering resources to understand how data is or should be structured to allow for a sustainable and scalable data platformDesign data ingestion/integration pipelines, considering aspects of full vs. incremental loads, how to handle slowly changing dimensions, unique identifiers for merge processesDesign data movement/curation/transformation proceduresDesign 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 setsProvide input into business data glossary / data catalog (Collibra/Data Dash) and logical data models (ER/Studio); help maintain and steward technical metadataProvide 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-)normalizationDeep understanding of Data Integration patternsAdvanced database handling languages (SQL and variants)Experience working with data dictionaries, data maps, taxonomiesKnowledge 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, ExcelExperience in the creation of new databases, data lakes, data warehouses, etc.