E

Ernst & Young

Global professional services: consulting, assurance, tax

Data Analyst - Cyber Managed Services, IAM Operational Reporting

Data Management +1Posted on Nov 14
Full-timeDallas, TX, USA$77.5k - $160.5k

About the Job

Requirements

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

Responsibilities

  • Engage with IAM data-source owners and stakeholders to gather requirements, identify authoritative data, and define the 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 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.

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

About the Company

Ernst & Young

Global professional services: consulting, assurance, tax

EY (Ernst & Young) provides professional services at a global scale, offering consulting, assurance, tax, and transaction advisory services. It serves clients across industries such as technology, media, real estate, hospitality, and construction. Instead of selling a single product, EY works with clients through tailored engagements where cross-disciplinary teams analyze challenges, design strategies, perform audits, help with tax planning, and assist with mergers or divestitures. What sets EY apart is its worldwide reach and integrated service model, industry-specific expertise, and focus on responsible business practices like sustainability, cybersecurity, and workforce flexibility. EY’s goal is to help organizations improve performance, manage risk, and achieve sustainable growth while building a better working world.

Company size
5,001-10,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Boston, MA
Founded
1991

Recently Posted Jobs

Explore more opportunities at Ernst & Young

See more jobs