Data Warehouse Modeler Mid Sr Level

Job Overview: Data Warehouse Modeler
Duration: 9 months contract

Location: Plano TX (Hybrid Tues Thurs)

Project:

Line of business is Financial Services. Data standardization. We are product of enterprise data strategy team. We plan to standardize high critical most valued data sets which we will include lot of remodeling of existing datasets. At the same time lot of goverance around how to define an attributes like loan application accounts and dealerships and all key datasets will be sent. This will eventually inable our journey to machine learning with a standardized managed well governed data. We already completed 2 data products and other teams caught up as a data product. We are planning to developer multiple products this year. We may need to hire 1 more data Modeler in future. We refer 510 years of experience as a Data Modeler. This candidate needs to work with SMEs & BAs.

Must have for Data Warehouse Modeler

SQL

Erwin

Hackolade

Exp working with Traditional & Modern data modelling

Postgres

Snowflake

Logical Data modelling

Physical Data Modelling

Data Profiling

Relational DB

Comm skills

Team work

Best practices

Collaborative

Job Description:

Data Modeler
Primary Responsibilities:
Model documentation and recommendations
Communicate with key stakeholders to facilitate discussions about data modeling
Develop DDLs for physical implementation and views
Data mapping and data discovery
Analyze source system data using profiling tools
Translates and transforms business requirements into data models (conceptual logical and physical)
Track technical debt in the data design and recommend approaches to minimize and reduce technical debt
Synchronize models with physical implementations
Adhere to existing naming and design standards as well as recommend new standards
Design data models in data modeling tools (e.g. ERWin)
Produce data model documentation using leading modeling tools at various levels including story subject area and full data model
Work
Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks
Work with business and application/solution teams to implement data strategies build data flows and develop conceptual/logical/physical data models
Lead and/or participate in data model reviews with various stakeholders
Evaluates database and data and develops the data model appropriately

Requirements:
Minimum of 1 year experience in modeling in an analytical environment
Minimum of 5 years of experience with Logical Design demonstrated with large scale multiple business solutions across divisions or enterprise
Minimum of 5 years prior experience as a data analyst and data modeler
Document target state endend data flows and representations
Ability to create and maintain conceptual data models high complexity logical and physical data models
Experience with SQL
Bachelors degree in information science computer science engineering or related discipline
Experience in Agile Frameworks (SAFe)
Experience with Erwin Hackolade or ER/Studio
Strong analytical skills
Ability to translate business requirements to technical requirements
Financial Services experience a plus
Comfortable working in ambiguity
Experience as Data Modeler on OLTP relational and data warehouse projects
Understanding of emerging technologies and their associated impact on enterprise environments