Sr. Data Modeler

Sr. Data Modeler ( 100% Remote)

[Dallas, TX, 75342] |   2021-12-04 10:39:33

Apply Now

Share Job 

Job Code : Hash0011

Role: Sr. Data Modeler

Location: Remote

Duration: 12 Months

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)

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., (on-prem or cloud)

- Experience working with data integration/replication tools such as: ADF, Qlik Replicate, Fivetran

- Working understanding of APIs

COMPUTING ENVIRONMENT

- ADO for team work plan

- Cloud-based tools (Azure, Snowflake, Cloudera)

- MS Office software