The Role
Fidelity’s Fraud Risk & Controls (FRC) Unit is seeking an experienced Data Architect / ETL Developer to design, develop, and support enterprise data warehouse and integration solutions across on‑premise and cloud platforms. The ideal candidate will have deep expertise in data warehousing, ETL development, data modeling, data quality, big data, and cloud-based data platforms, working in large-scale, heterogeneous environments. This role requires hands-on development, strong analytical thinking, and the ability to collaborate with distributed teams to deliver reliable, scalable, and high‑performance data solutions.
- Deep expertise in enterprise data architecture, ETL, and data warehousing, with hands-on experience across relational and NoSQL databases, Snowflake, Hadoop, Splunk, and hybrid on‑prem/cloud data platforms including AWS, S3, Azure, and data lake services.
- Strong database development and data engineering background using SQL, Python, scripting, RESTful APIs, and API integrations, with a focus on scalable, high‑performance data processing and automation.
- Extensive experience designing and developing ETL and data integration solutions using Informatica PowerCenter, SSIS, DTS, SQLPlus, SQLLoader, Business Objects Data Integrator, Salesforce integrations, Informatica Data Quality, and Metadata Manager.
- Proven ability to design dimensional data models, optimize SQL and ETL performance, and implement robust data quality, validation, cleansing, and governance practices.
- Demonstrated success supporting cloud and big data ecosystems, CI/CD pipelines, scheduling, and operational support for enterprise data solutions.
- Strategic and analytical problem solver who thrives in fast‑paced environments, independently researches complex technical challenges, and continuously identifies opportunities for improvement.
- Strong collaborator and communicator, skilled at partnering with business, analytics, engineering, and cybersecurity teams to translate business needs into secure, scalable data solutions.
- Experience defining technology and data strategies, managing short‑ and long‑term deliverables, measuring progress, and clearly reporting outcomes to senior leadership.
- Domain expertise supporting cyber fraud detection initiatives, including integrating new data sources, designing fraud detection data solutions and rules engines, and serving as a trusted data specialist for fraud analysts with strong institutional knowledge of financial services data.
The Team
Fraud Risk & Controls team deploys advanced analytics to detect and combat cybercrime for Fidelity’s enterprise-wide financial products and services. The team works closely with Cyber Fraud Investigators and technology groups including enterprise cyber security and customer protection teams to assemble and analyze fraud and risk signals in near real time manner, with a goal to prevent or reduce monetary losses for our clients and protect Fidelity reputation.
Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.
Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
Skills Required
- Deep expertise in enterprise data architecture, ETL, and data warehousing
- Hands-on experience with relational and NoSQL databases
- Experience with Snowflake, Hadoop, and Splunk
- Experience with cloud platforms and services (AWS, S3, Azure, data lake services)
- Strong database development and data engineering using SQL and Python
- Experience with RESTful APIs and API integrations
- Extensive ETL development experience with Informatica PowerCenter, SSIS, DTS, SQLPlus, SQLLoader, Business Objects Data Integrator
- Experience with Salesforce integrations
- Experience with Informatica Data Quality and Metadata Manager
- Ability to design dimensional data models and optimize SQL/ETL performance
- Implement robust data quality, validation, cleansing, and governance practices
- Experience supporting cloud and big data ecosystems, CI/CD pipelines, scheduling, and operational support
- Domain expertise in cyber fraud detection and related data solutions
- Strong collaboration and communication skills with business, analytics, engineering, and cybersecurity teams
- Experience defining technology and data strategies and reporting to senior leadership
Fidelity Investments Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Fidelity Investments and has not been reviewed or approved by Fidelity Investments.
-
Strong & Reliable Incentives — Bonuses, commissions, and profit-sharing are presented as generous and meaningful components of total compensation, with certain roles achieving high total earnings through multiple pay streams. Variable pay is consistently framed as a positive contributor beyond base salary.
-
Retirement Support — A 401(k) match up to 7% alongside additional profit-sharing up to 10% materially enhances long-term compensation. These retirement features are highlighted as standout strengths of the overall package.
-
Parental & Family Support — Generous paid parental leave (16 weeks maternity, 12 weeks parental), backup dependent care, and adoption assistance provide robust family support. Hybrid work and caregiving resources further ease family responsibilities.
Fidelity Investments Insights
What We Do
At Fidelity, our goal is to make financial expertise broadly accessible and effective in helping people live the lives they want. We do this by focusing on a diverse set of customers: - from 23 million people investing their life savings, to 20,000 businesses managing their employee benefits to 10,000 advisors needing innovative technology to invest their clients’ money. We offer investment management, retirement planning, portfolio guidance, brokerage, and many other financial products. Privately held for nearly 70 years, we’ve always believed by providing investors with access to the information and expertise, we can help them achieve better results. That’s been our approach- innovative yet personal, compassionate yet responsible, grounded by a tireless work ethic—it is the heart of the Fidelity way.
