DataJobs.io
← Back to all jobs

Job Description

Use identity and access data to strengthen operational reporting and deliver actionable insights into an access-risk posture.

Responsibilities

  • Partner with IAM data-source owners and stakeholders to gather requirements, identify authoritative data, and define data needed for risk reduction and access-governance processes.
  • Analyze business and technical needs and translate them into conceptual, logical, and physical data models focused on data quality, performance, lineage, and scalability.
  • Create, maintain, and scale repeatable data-ingestion patterns to support operational reporting across thousands of enterprise systems.
  • Profile, map, reconcile, and validate IAM data covering identity, account, entitlement, credential, inventory, activity, and control information 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 IAM risk insights.
  • Define data-quality rules, metrics, and exception-handling processes; investigate discrepancies and support remediation with source owners and engineering teams.
  • Use SQL and scripts to query, manipulate, reconcile, and profile data across cloud and on-premises environments.
  • Support engineers with ETL pipeline design and validation, data transformations, operational data-store structures, and reporting datasets.
  • Develop requirements, user stories, acceptance criteria, test scenarios, and evidence for new data sources, reporting features, and control enhancements.
  • Build dashboards, reports, and visualizations to communicate access-risk posture, control coverage, data quality, operational trends, and remediation priorities.
  • Participate in Agile ceremonies including backlog refinement, sprint planning, demonstrations, testing, release readiness, and continuous improvement.
  • Maintain data dictionaries, requirements documentation, analytical findings, process flows, operating procedures, and stakeholder-ready materials.
  • Work independently through ambiguity by proactively seeking decisions, clarifications, and support when needed.

Requirements

  • 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.
  • 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 plus scripting experience with Python, R, Unix shell scripting, or PL/SQL.
  • Working knowledge of 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.
  • Ability to combine complex data across systems, identify meaningful trends, and translate findings into clear recommendations.
  • Experience developing dashboards and data visualizations using Tableau, Power BI, or comparable 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 in a fast-paced Agile environment with changing business and technology priorities.

Technology Environment

  • SQL and scripting: SQL, PL/SQL, Python, R, Unix shell scripting
  • Data platforms: Snowflake, Oracle, Microsoft SQL Server
  • Integration and modeling: ETL pipelines, repeatable ingestion patterns, source-to-target mapping, data profiling, reconciliation, transformation, lineage management
  • Reporting and visualization: Tableau, Power BI, operational dashboards, control reporting, data-quality metrics
  • IAM ecosystem: SailPoint IdentityIQ, AccessHub, identity and access data sources (identity, account, entitlement, credential, inventory, activity, certification, lifecycle)
  • Delivery and collaboration: Jira, Confluence, ServiceNow, Agile delivery methods, documentation repositories
  • Emerging analytics: Neo4j graph analytics and AI-assisted use cases for IAM insights and remediation decision support

Location

  • Dallas (onsite)
  • Other locations: Anywhere in Region

Salary

  • New York City, Boston, Washington DC Metro Areas, Washington State, Southern California offices: $92,900 to $153,900
  • Bay Area California offices: $96,000 to $160,500
  • All other US offices, including Sacramento: $77,500 to $140,900
  • Individual salaries determined by factors including education, experience, knowledge, skills, and geography.
  • Salary range shown: USD 92,900 - 153,900 per year

Benefits

  • Medical and dental coverage
  • Pension and 401(k) plans
  • Paid time off options

Preferred Qualifications

  • Experience with identity and access management, identity governance, cybersecurity, technology risk, or access-control data.
  • Familiarity with IAM data domains: 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.

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 improving visibility into access risk, control coverage, operational trends, and remediation priorities.
  • Well-defined requirements, user stories, acceptance criteria, and test evidence enabling successful engineering delivery.
  • Timely resolution of data issues through 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.

Similar Jobs