Location: Dallas, Alpharetta, Charlotte, Jacksonville, and San Antonio
At EY, we're all in to shape your future with confidence.
We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.
Position Summary
This role will help consolidate identity and access data across enterprise systems, strengthen operational reporting, and provide timely insights into the client's access-risk posture.
The analyst will engage with data-source owners, engineers, product owners, architects, and business partners to define data requirements, profile and validate source data, document lineage, and translate business needs into scalable data models and ingestion patterns. The role will support access-governance applications, enterprise controls, remediation activities, and data-driven decision-making.
Key Responsibilities
- Engage with IAM data-source owners and stakeholders to gather requirements, identify authoritative data, and define data needed to support risk-reduction objectives and access-governance processes.
- Analyze business and technical requirements and translate them into conceptual, logical, and physical data models that address data quality, performance, lineage, and scalability.
- Create, maintain, and scale repeatable data-ingestion patterns supporting operational reporting across thousands of enterprise systems.
- Profile, map, reconcile, and validate identity, account, entitlement, credential, inventory, activity, and control-related data from multiple source systems.
- Document source-to-target mappings, data lineage, transformation logic, control points, and data-flow diagrams.
- Combine data from multiple sources to identify trends, patterns, anomalies, coverage gaps, and actionable IAM risk insights.
- Define data-quality rules, metrics, and exception-handling processes; investigate data discrepancies and support remediation with source owners and engineering teams.
- Write and interpret SQL and scripts to query, manipulate, reconcile, and profile data across cloud and on-premises platforms.
- Support engineers in designing and validating ETL pipelines, data transformations, operational data-store structures, and reporting datasets.
- Develop requirements, user stories, acceptance criteria, test scenarios, and supporting evidence for new data sources, reporting features, and control enhancements.
- Create dashboards, reports, and visualizations that clearly communicate access-risk posture, control coverage, data quality, operational trends, and remediation priorities.
- Participate in Agile ceremonies, backlog refinement, sprint planning, demonstrations, testing, release readiness, and continuous-improvement activities.
- Maintain data dictionaries, requirements documentation, analytical findings, process flows, operating procedures, and stakeholder-ready materials.
- Work independently through ambiguity while proactively seeking decisions, clarifications, and support when necessary.
Required Qualifications
- Bachelor's degree in computer science, information technology, information systems, data analytics, or a related field, or equivalent practical experience.
- Approximately 6-9 years of experience in data analysis, systems analysis, business analysis, data engineering support, or a related role.
- Demonstrated experience with requirements elicitation, gap analysis, data mining, data profiling, source-to-target mapping, and data-quality assessment.
- Strong understanding of dimensional, relational, and unstructured data-modeling concepts.
- Experience developing conceptual, logical, and physical data models, including third normal form in relational database environments.
- Strong SQL skills and experience with one or more scripting languages such as Python, R, Unix shell scripting, or PL/SQL.
- Working knowledge of database and data-platform technologies such as Snowflake, Oracle, and Microsoft SQL Server.
- Experience supporting data warehouses, operational data stores, ETL processes, data pipelines, or comparable data-integration solutions.
- Demonstrated ability to combine complex data from multiple systems, identify meaningful trends, and translate findings into clear recommendations.
- Experience developing dashboards and data visualizations using Tableau, Power BI, or comparable reporting tools.
- Ability to communicate complex data concepts, issues, and recommendations to both technical and non-technical audiences.
- Strong analytical, problem-solving, documentation, collaboration, and stakeholder-management skills.
- Ability to operate effectively in a fast-paced Agile environment with changing business and technology priorities.
Preferred Qualifications
- Experience working with identity and access management, identity governance, cybersecurity, technology risk, or access-control data.
- Familiarity with IAM data domains such as identities, accounts, entitlements, applications, credentials, access activity, certifications, and lifecycle events.
- Experience with SailPoint IdentityIQ or AccessHub and related access-governance reporting.
- Experience with ServiceNow, Jira, Confluence, or comparable workflow and Agile-delivery platforms.
- Experience with Snowflake and modern cloud-based data platforms.
- Experience using data-modeling or lineage-documentation tools.
- Familiarity with graph databases or analytics platforms such as Neo4j.
- Experience in a regulated financial-services environment.
- Familiarity with audit evidence, control reporting, data governance, and risk-remediation processes.
Technology Environment
- Data analysis and scripting: SQL, PL/SQL, Python, R, and Unix shell scripting.
- Data platforms: Snowflake, Oracle, Microsoft SQL Server, relational databases, operational data stores, and enterprise data warehouses.
- Data integration: ETL pipelines, repeatable ingestion patterns, source-to-target mapping, data profiling, reconciliation, transformation, and lineage management.
- Reporting and visualization: Tableau, Power BI, operational dashboards, control reporting, and data-quality metrics.
- IAM ecosystem: SailPoint IdentityIQ / AccessHub and identity, account, entitlement, credential, inventory, activity, certification, and lifecycle data sources.
- Delivery and collaboration: Jira, Confluence, ServiceNow, Agile delivery methods, documentation repositories, and cross-functional engineering processes.
- Emerging analytics: Neo4j graph analytics and AI-assisted use cases for IAM insights, analysis, impact assessment, and remediation decision support.
Success Measures
- Accurate, timely, and scalable data-ingestion patterns supporting IAM operational reporting across in-scope systems.
- Improved completeness, quality, traceability, and reliability of identity and access data.
- Clear source-to-target mappings, lineage documentation, and data-quality controls.
- Actionable dashboards and analyses that improve visibility into access risk, control coverage, operational trends, and remediation priorities.
- Well-defined requirements, user stories, acceptance criteria, and test evidence that enable successful engineering delivery.
- Timely resolution of data issues through effective collaboration with data-source owners, engineers, architects, product owners, and business partners.
- Consistent delivery against sprint and release commitments while adhering to Fidelity security, data, architecture, and engineering standards.
What we offer you
At EY, we harness our collective strength to empower you to shape your future with confidence through professional growth, personal fulfillment and an inclusive culture. Learn more at ey.com/us/careers.
The salary range for this job is:
New York City, Boston, and Washington DC Metro Areas, Washington State, and Southern California offices - $92,900 to $153,900
Bay Area California offices - $96,000 to $160,500
All other offices locations in the US, including Sacramento - $77,500 to $140,900
Individual salaries within these ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.
Are you ready to shape your future with confidence? Apply today.
- To make the most of your application experience, please limit yourself to two applications within a six-month period.
- EY accepts applications for this position on an on-going basis.
- For those living in California, please click here for additional information.
- At EY, our values set the foundation for how we work and the behaviors we expect of our people. Any misrepresentation or falsification of information or lack of integrity at any point in the recruiting process may result in withdrawal of your candidacy, revocation of an offer or immediate termination of employment.
EY | Building a better working world
EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.
Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.
EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.
All in to shape the future with confidence.
EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law.
EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY's Talent Shared Services Team (TSS) or email the TSS at ssc.customersupport@ey.com.