Data ModelerLocation: Merrimack, NH OR Smithfield, RI OR Durham, NC OR Jersey City, NJ or Westlake, Texas (Hybrid- 3 days in A month)Duration: 12+ month long termThe Expertise and Skills You BringBachelor’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. MBA is a plus.Proficient with ERD/Data Modelling tools (e.g.
SAP Power Designer or Erwin).Experience designing new OLAP and/or OLTP models from scratch.Experience with Kimball Data Warehouse design techniques.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.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.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.Go-getter, self-sufficient, and willing to exhaust all research avenues before seeking help or discontinuing the search for 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 maximize the value of our data.Experience with cloud native data warehousing and data lake solutions using Snowflake is a plus.