Data Modeler

Job Title: Data Modeler - W2 Only - We can provide sponsorship

Location: Merrimack, NH/Westlake, TX - Hybrid

Duration: Long Term

Must haves:

We are onboarding data sources from multiple Business units and databases and mastering the data.

This hire will support OLAP Data analysis and modeling

What are the top MUST haves:

Must have 8+ years of experience.

SQL, must be expert level and will be asked to write complex code/queries

OLAP modeling experience in: (Erwin / Power Center)

Analytical problem solver

The Role

We are currently sourcing for a highly motivated Data Modeler in Westlake or Merrimack to join our Analytics and Reporting team. The Data Analyst will provide data analysis leadership on sophisticated data analysis projects, often across the Enterprise. An opportunity to conduct data analysis across different projects with diverse scope, complex business and technical requirements in a multi-platform and highly integrated data environment.

Below are the skills that the Fidelity Institutional Technology team values!

The Expertise Required

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.

Proven track record of solving real world problems using data.

Understanding of different database platforms (e.g. Oracle, MySQL) usages (OLTP Recordkeeping, ODS, MDM, Warehousing and Data Lakes).

Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).

Demonstrated experience in SQL.

Experience with ERD/Data Modelling tools (SAP Power Designer or Erwin).

Experience in executing projects in an Agile environment.