Principal, Data Engineer-Data Architect / ETL Developer

Fmr LLC
Westlake, United States of America
8 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Remote
Westlake, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Azure
Big Data
Computer Security
Continuous Integration
Data Architecture
Information Engineering
Data Integration
ETL
Data Systems
Data Warehousing
Database Development
Fraud Prevention and Detection
Hadoop
Python
Metadata
NoSQL
Cloud Services
Salesforce
SQL*Plus
SQL Databases
SQL Server Integration Services
Distributed Temperature Sensing (DTS)
Data Processing
Scripting (Bash/Python/Go/Ruby)
Cloud Platform System
Informatica Powercenter
Snowflake
Oracle SQL Loader
Sap Business Objects
Data Strategy
Data Lake
Cybercrime
Enterprise Integration
REST
Splunk
Data Pipelines
Api Management

Job description

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., 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.

Requirements

  • 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.

Apply for this position