Cyber Managed Services - Data Analyst - IAM Operational Reporting - Senior
Senior
Analytics
Business Intelligence
Cloud
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Data Warehousing
Database
Databases
Digital Marketing
ETL
Graph Databases
Identity and Access Management
Identity Governance
Informatica
Information Technology (IT)
It Service Management
IT Services
ITSM
Reporting and Analytics
Sailpoint Identityiq
Service Desk Tool
Service Management
ServiceNow
Servicenow
Software Development
SQL
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.