Senior IT Data Analyst

Job Description: Position Description: Maintains datasets to obtain valuable insights using SQL or Python. Coordinates various databases and data warehouses using Extract, Transform and Load (ETL) testing. Works in an Agile environment using Agile methodologies and tools -- Jira / Jira Align to manage databases. Improves data engineering solutions in cloud environments and enterprise data lakes using database technologies -- Snowflake. Translates business requirements into data solutions by defining use cases and simplifies complex concepts by writing SQL queries in Snowflake. Primary Responsibilities: Analyzes, designs, and develops data analysis services to support integrated enterprise analytics platforms. Identifies and defines data needs and contributes to data ingestion. Delivers high value data products for enterprise analytics initiatives. Translates business requirements into data solutions by defining use cases and simplifying complex concepts. Identifies data quality issues, risks, and overall trends by leveraging data analysis and data profiling methods. Defines robust test scenarios by analyzing test data. Builds and provides robust data solutions by leveraging data management and data modeling practices. Defines user stories and validates the impact of changes to datasets and data models. Identifies alternative approaches and makes recommendations on the benefits and shortcomings in datasets and data models to support integrated enterprise analytics platforms. Analyzes data to write requirement and user stories for developers. Builds data analytics and reporting platforms to deliver end-to-end cloud-native digital solutions for the enterprise. Creates Data models in Power designer to define user stories and validates the impact of changes to datasets and data models. Creates a data catalog that helps organize, identify, understand, and manage the data sets in Alation. Education and Experience: Bachelor’s degree (or foreign education equivalent) in Business Administration, Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Senior IT Data Analyst (or closely related occupation) performing data analysis, profiling, and modeling in a financial services domain, using SQL, PL/SQL, and Python. Or, alternatively, Master’s degree (or foreign education equivalent) in Business Administration, Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one (1) year of experience as a Senior IT Data Analyst (or closely related occupation) performing data analysis, profiling, and modeling in a financial services domain, using SQL, PL/SQL, and Python. Skills and Knowledge: Candidate must also possess: Demonstrated Expertise (“DE”) translating business requirements into data driven solutions (to create conceptual and physical models) using SAP Power Designer; supporting unstructured and semi structured data storage design patterns using AWS-S3, Kafka, and Snowflake; and parsing out attributes from data to identify patterns, using SQL, KSQL, or PL/SQL. DE developing data profiling frameworks using SQL and Python; performing end-to-end data analysis and sourcing (to target data mapping) using Oracle, Snowflake, and ICEDQ; and establishing governance and dictionary data practices using Alation and Collibra. DE designing and implementing data movement processes for data warehouses or datalakes by developing mappings and ETL workflows, using Informatica, Apache Nifi, or Control-M; and deploying code changes using Github or Jenkins. DE performing story creation, backlog refinement, and sprint planning according to Agile methodologies (Jira), within a financial services compliance environment. Salary: $111,850.00 - $127,500.00/year. #PE1M2 Certifications: Category: Information Technology Fidelity’s hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office. At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. 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 please contact the following: For roles based in the US: Contact the HR Leave of Absence/Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 2 For roles based in Ireland: Contact AccommodationsIreland@fmr.com For roles based in Germany: Contact Accommodationsgermany@fmr.com Fidelity Privacy Policy

Salary : $111,850 - $127,500