Senior IT Data Analyst
skillventory - A Leading Talent Research Firm
full-time
Posted on:
Location Type: Hybrid
Location: Durham • North Carolina • Rhode Island • United States
Visit company websiteExplore more
Job Level
About the role
- Partner with Business Stakeholders, Product Owners, Architecture, and Engineering teams to analyze business and operational data needs
- Understand upstream and downstream data flows
- Translate business requirements into system and data requirements
- Convert business ask into system-ready user stories when required
- Analyze enterprise data workflows and system dependencies to identify performance bottlenecks across applications and integration layers
- Translate business performance needs into implementation-ready system and data requirements
- Define source-to-target data mappings, interface contracts, and end-to-end data lineage across upstream and downstream systems
- Support performance optimization by conducting data analysis, profiling, and validation using SQL
- Convert complex business and data requirements into user stories with clearly defined acceptance criteria and test conditions
- Partner with engineering teams to ensure system and data solutions meet performance, scalability, and operational requirements
- Perform impact analysis related to schema changes, integration logic updates, and data pipeline enhancements
- Lead backlog refinement sessions to ensure stories are clear, testable, and ready for sprint planning
- Support quarterly planning and backlog management for performance-focused system and data initiatives
- Collaborate with Architecture, Data Engineering, and Application teams to align on data contracts, integration dependencies, and SLAs
- Identify and manage risks and dependencies impacting application and data processing performance
- Support end-to-end testing to validate performance improvements and functional alignment with defined requirements.
Requirements
- Hands-on experience with relational databases and SQL for data analysis, profiling, validation, and root cause analysis
- Strong understanding of data modeling concepts such as star and snowflake schemas, dimensions, and facts
- Experience collaborating with business stakeholders to gather and analyze business and functional requirements using structured artifacts such as BRDs, process flows, and data flow diagrams
- Ability to translate business goals into end-to-end system and data requirements including field-level definitions, data rules, and non-functional requirements
- Experience partnering with engineering teams to define and maintain source-to-target data mappings, interface contracts, and data lineage across integration layers
- Experience documenting and maintaining end-to-end data and process lineage across platforms such as Oracle, Snowflake, and S3 through operational workflows
- Ability to perform impact analysis related to upstream schema changes, data pipeline updates, and integration logic changes
- Experience performing cost-benefit analysis to ensure technology investments are aligned with business objectives and deliver measurable value
- Ability to convert business requirements into actionable delivery plans with defined milestones and timelines for both system and data initiatives
- Experience identifying and managing risks and dependencies related to data workflows, system integrations, and processing pipelines
- Experience supporting delivery through quarterly planning and backlog management activities
- Experience managing product backlogs using tools such as JIRA, Confluence, Excel, and SharePoint
- Ability to translate complex business and data requirements into user stories with clearly defined business value, acceptance criteria, and test conditions
- Experience leading refinement sessions to ensure user stories are implementation-ready for sprint planning
- Ability to define story acceptance tests in collaboration with engineering teams using Acceptance Test Driven Development (ATDD) principles.
Benefits
- Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles. Some roles may have unique onsite requirements.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLdata analysisdata profilingdata validationdata modelingstar schemasnowflake schemadata lineageimpact analysisAcceptance Test Driven Development
Soft Skills
collaborationcommunicationproblem-solvingrisk managementbacklog managementleadershiprequirements gatheringanalytical thinkingplanningstory refinement