IT Data Modeler


Curitiba, PR, BR

Company:  ExxonMobil

Job Role Summary

Come be part of the team to solve some of the toughest energy problems in the world. ExxonMobil is one of the world’s largest energy companies providing energy that helps underpin growing economies and improve living standards around the world.
But aside from that, we’re a hip crew of technologically smart and savvy individuals, and we make a great team. One that fosters a diverse and inclusive culture and that focuses on collaboration, encourages creativity, and embraces change. We’re continuously advancing across multiple platforms, driving strategy and innovation through global digitization and technology enablement, in order to keep ExxonMobil at the top and to make you proud and excited to come to work each day.
An ExxonMobil career is one designed to last, with benefits built to support every stage of life. That means world-class compensation and benefits, teammates who support and inspire, and the flexibility to explore multiple challenges and roles.
Where you start your career is only the beginning.

Responsible for working with the Research & Engineering 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.


Job Role Responsibilities

• 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)

Expected Level of Proficiency

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
• 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

Preferred Candidate should have:
• 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.
• Experience with DevOps/Agile development and application to data centric architecture and solutions
• 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





Job Segment: Database, Engineer, Developer, Computer Science, Technology, Engineering, Research