Senior, Data Modeler
Company: Fidelity Investments
Posted on: March 17, 2023
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,
- 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
- 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
- Experience with Kimball Data Warehouse design techniques is a
- 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
Didn't find what you're looking for? Search again!
Loading more jobs...