Data Analyst / Modeler Job at Fidelity TalentSource in Merrimack

Must have

• Bachelor’s Degree or equivalent in a technology-related field (e.g., Computer Science, Engineering) with a focus on data analysis, data structures, or data modeling.
• Expert-level analysis skills in research, gap analysis, data mining, and data profiling.
• Solid understanding of data lineage and ability to 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, including designing new platforms on cloud technologies/architecture like Snowflake and AWS.
• Proficient with ERD/Data Modeling tools (e.g., SAP Power Designer or Erwin).
• Experience in carrying out projects in an Agile environment.
• Outstanding interpersonal skills with experience collaborating and influencing across all levels of the organization, including effective written, verbal, and technology illustrations.
• Ability to perform autonomously on tasks while sharing knowledge with coworkers and partners.
• Self-sufficient and a go-getter, with a willingness to exhaust all research avenues before seeking help.
• Comfort with uncertainty and capability to combine various information sources, including personal data experimentation, research, and dialogues, to formulate answers.
• Valuing pace over perfection and demonstrating incremental progress in analysis and research through tangible artifacts.
• Ability to balance multiple contending priorities.
• Familiarity with the financial industry or a strong desire to learn about 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 is also a plus.