Senior Data Modeler consultant

Trident Consulting
Durham, North Carolina
May 21, 2024
May 25, 2024
Position Type
Consultant, Scientist, Data
Full Time
Organization Type
Corporate, Consulting
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


Experience: 12-14+ 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.


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 Area