Senior IT Data Analytics Lead

Fidelity; Smithfield (RI); On-site; USD 115,775 - 166,000; Full time

Job summary

Fidelity is seeking a Senior Principal IT Data Analyst to drive analytics architecture onsite in Smithfield, RI. The role focuses on building curated data repositories, analyzing complex data from diverse sources, and translating business needs into technical solutions using SQL, Python, and BI tools.

The candidate will lead data modeling efforts, mentor junior analysts, and contribute to governance, documentation, and standards across multiple data environments.

Qualifications

• End-to-end data-driven solution design using SAP Power Designer; experience with AWS-S3, Kafka, Snowflake; SQL/PL/SQL; data modeling in Oracle, Snowflake, MySQL, and PostgreSQL.
• Data profiling frameworks using SQL and Python; end-to-end data analysis and sourcing using Oracle, Snowflake, ICEDQ; governance and dictionary data practices using Alation and Collibra.
• Data movement for data warehouses/datalakes with ETL workflows using Informatica, Apache NiFi, or Control-M; code deployment with Github or Jenkins; testing and development of PL/SQL and Python code; optimized SQL queries and batch processes.
• Data wrangling with Python, R, Alteryx, and Jupyter; data visualization with BI tools (Power BI, Tableau, Excel); development of ML models using AI/ML in Python and R; Agile methodologies (Jira) in a financial services compliance environment.

Responsibilities

• Develops and maintains curated data repositories for an enterprise analytics platform. Analyzes complex datasets from multiple sources (demographics and investments) using SQL, Python, and front-end analytics (Tableau).
• Writes and updates design documentation using Confluence. Translates business requirements into technical solutions by developing complex software applications and studying alternatives.
• Analyzes and recommends changes in project development policies, procedures, standards, and strategies to development teams and management.
• Recommends design changes to complex, interrelated systems to meet requirements, improve performance, or reduce total ownership costs.
• Designs new systems based on requirements gathered during the analysis phase.
• Mentors other analysts in documenting large and complex projects and monitors the quality and progress of documents.
• Documents formal specifications describing solutions to meet requirements.
• Analyzes data across transactional, data warehouse, and data lake environments and communicates findings to senior management.
• Plans and designs computer systems using structured analysis, data modeling, and information engineering.
• Develops, documents, and revises system design procedures, test procedures, and quality standards. Consults with management to ensure agreement on system principles.

Skills

Data analysis

Data modeling

Mentoring

Documentation

Stakeholder communication

Education

Bachelor's degree in CS/Engineering/IT

Master's degree in CS/Engineering/IT

Tools

SAP Power Designer

AWS S3

Kafka

Snowflake

Oracle

MySQL

PostgreSQL

Informatica

Apache NiFi

Control-M

GitHub

Jenkins

Jira

Alation

Collibra

Alteryx

Jupyter Notebook

Tableau

Power BI

Job description

Fidelity is seeking a Senior Principal IT Data Analyst to drive analytics architecture onsite in Smithfield, RI. The role focuses on building curated data repositories, analyzing complex data from diverse sources, and translating business needs into technical solutions using SQL, Python, and BI tools.

The candidate will lead data modeling efforts, mentor junior analysts, and contribute to governance, documentation, and standards across multiple data environments.