Senior Data Modeler

Title : Senior Data Modeler

Location : Dallas TX (Onsite)

Type : Contract

Day to Day Job Duties :

• Design high-quality domain (canonical) data models consumption-layer dimensional models ensuring compliance with Client data architecture and governance standards.
• Collaborate with business and technical stakeholders to define document and govern how data flows across the organization supporting analytics reporting operational use cases and advanced data science initiatives.
• Work under the guidance of client Core Data Architects to create data models for the different layers (Domain and Consumption) of our enterprise data platform hosted in Databricks on Azure.
• Collaborate with Application Data SMEs to understand the complete structure and business definition of the source data.
• Collaborate with business analysts and business analytics SMEs to understand the BUS Matrix and associated requirements definition for the data needs.
• Create and maintain data model using ER Studio tool complete with DDL generation.
• Define end to end data lineage (S2T) and document them on Confluence pages as per given Client standards.
• Generate SQL query snippets for explaining data transformation logic.
• Profile and analyze source data to ensure data quality and recommend data refinement and cleansing methods.
• Perform necessary reviews and obtain sign offs prior to delivery to the DEV and QA teams.
• Perform handoff walkthroughs of model and S2T to the DEV team and participate in design review sessions for any refinements as necessary.
• Perform handoff walkthroughs of model and S2T to the QA team and participate in defect triage sessions as necessary.
• Build SQL queries for end consumption business views in alignment with the business requirements.
• Participate with business UAT teams to clarify data model questions and business view questions.
• Provide any other necessary support through the engineering build QA and UAT phases.

Basic Qualifications :

Nice to Have :

Key Skills

Atl,CMMS,ABAP,Community Support,CRM,Fleet

Employment Type : Full Time

Experience : years

Vacancy : 1