Senior Data Modeler consultant - Durham, United States - Trident Consulting

Description

Trident Consulting is seeking a "
Senior Data Modeler consultant " for one of our clients in
"Durham, NC
" A global leader in business and technology services


Positon:
Senior Data Modeler consultant

Location:
Durham, NC


Fulltime


Experience:
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 Power-Designer and define all database objects.


Qualifications:

• Atleast 9 years of work experience in Data Modeling in software industry.
• Bachelor's 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 design-oriented 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.
• Go-getter, self-sufficient, 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.

About Trident: Trident Consulting is an award-winning IT/engineering staffing company founded in 2005 and headquartered in San Ramon, CA. We specialize in placing high-quality vetted technology


Some of our recent awards include:
2022, 2021, 2020 Inc. 5000 fastest-growing private companies in America 2022, 2021 SF Business Times 100 fastest-growing private companies in Bay Are