Role: Senior Data Modeler consultant
Location: US (Durham NC or Westlake TX)
Duration: Fulltime
Client: Hexaware/Fidelity
Work Model: Hybrid model 23 days per week onsite
No. of positions: 2
Experience: 1214 Years
Primary Skill: Data Modeling SQL Snowflake AWS Hadoop ERD/ Data Modeling OBIEE Power BI
Secondary Skill: Understanding of OLTP Recordkeeping ODS MDM Warehousing and Data Lakes Agile
JD: We are responsible for designing and delivering data mapping specifications and data models for large reporting and analytics platforms. Our mappings detail all data movement and transformation detailing business rules using a combination of SQL and pseudocode. Our data models (DDLs and model reports) are generated via SAP PowerDesigner and define all database objects.
Qualifications:
- Atleast 9 years of work experience in Data Modeling in software industry.
- Bachelors Degree or equivalent in a technology related field (e.g. Computer Science Engineering etc.) with a focus on data analysis data structures or data modeling.
- Expert level analysis skills in the form of research gap analysis data mining and data profiling.
- Solid understanding of data lineage. Ability to breakdown and detail the flow of data from origination to consumption.
- Proven track record of solving real world problems using a designoriented modeling approach in large data warehouses data marts and analytics/reporting platforms such as OBIEE and Power BI.
- Understanding of different database platforms (e.g. Oracle Snowflake Hadoop Microsoft SQL Server) usages (OLTP Recordkeeping ODS MDM Warehousing and Data Lakes).
- Understanding of modeling strategies (dimensional relational unstructured).
- Robust SQL experience used to design new platforms on cloud technologies/architecture including Snowflake AWS etc.
- Proficient with ERD/Data Modeling tools (e.g. SAP Power Designer or Erwin).
- Experience carrying out projects in an Agile environment.
- Having outstanding interpersonal skills with experience collaborating and influencing across all levels of the organization including written verbal and technology illustrations.
- Perform autonomously on tasks but are willing and able to share knowledge with coworkers and partners.
- Gogetter selfsufficient and willing to exhaust all research avenues before seeking help or discontinuing the search for answers.
- Accepts uncertainty and can combine various sources of information including personal data experimentation research and dialogues to formulate answers.
- Values pace over perfection and can show incremental progress of analysis and research through tangible artifacts.
- Capable of balancing multiple contending priorities.
- Familiar with the financial industry and/or have a strong desire to learn our brokerage business to enhance the value of our data.
- Experience with cloud native data warehousing and data lake solutions using Snowflake is a plus.
- Experience with Kimball Data Warehouse design techniques.