Senior, Data Modeler

Company: Fidelity Investments
Location: Durham
Posted on: March 17, 2023

Job Description:

Job Description:Senior Data ModelerThe RoleWe are seeking a highly motivated Senior Data Modeler to join our Data Solutions Center of Excellence. As a skilled Modeler + Analyst, you will provide data analysis leadership on multiple projects simultaneously. You will help conduct data analysis/Modeling across different projects with diverse scope, complex business and technical requirements in a multi-platform and highly integrated data environment. This role is analysis and design centric; crafting and detailing data solutions/models, which are then handed to developers, engineers, and DBAs to implement.The Expertise and Skills You Bring

• 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. MBA is a plus.
• 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.
• Consistent 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.
• Proficient with ERD/Data Modelling 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 maximize the value of our data.
• Experience with Kimball Data Warehouse design techniques is a plus.
• Experience with cloud native data warehousing and data lake solutions using Snowflake is a plus.The TeamWe 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 PowerDesigner and define all database objectsPlease see below for the salary range for work locations in Colorado only:N/APlease see below for the salary range for work locations in New York City, Westchester County, NY and Jersey City, NJ only:N/APlease see below for the salary range for work locations in California only:N/APlease see below for the salary range for work locations in Washington only:N/ACertifications:Company OverviewFidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.Join UsAt Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts peoples' lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees' Choice Award, we have been recognized by our employees as a Best Place to Work in 2023. And you don't need a finance background to succeed at Fidelity-we offer a range of opportunities for learning so you can build the career you've always imagined.At Fidelity, our goal is for most people to work flexibly in a way that balances both personal and business needs with time onsite and offsite through what we're calling "Dynamic Working."We invite you to Find Your Fidelity at fidelitycareers.com.Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to accommodations @fmr.com, or by calling 800-835-5099, prompt 2, option 3. We welcome those with experience in jobs such as Software Developer, Computer Technician, and Computer User Support Specialist and others in the Computers and Technology to apply.

Keywords: Fidelity Investments, Durham , Senior, Data Modeler, Accounting, Auditing , Durham, North Carolina