ICAM Data Engineer – IGA Analytics & Reporting
About The Position
GDIT is hiring a Data Engineer to design, build, and optimize Power BI reporting solutions for enterprise Identity Governance & Administration (IGA) analytics. The role focuses on transforming complex identity and entitlement data into dashboards that support leadership insights, compliance reporting, access governance visibility, and Zero Trust metrics. It primarily involves Power BI dataset and report development, with a working understanding of upstream ETL processes. The successful candidate will work with data engineers, IGA operations, cybersecurity analysts, and mission stakeholders to represent identity data accurately and meet reporting needs. The work supports enterprise decision-making, audit readiness, access risk analytics, certification performance metrics, and the enterprise security posture. This is a fully remote position.
Requirements
- Active Secret clearance; interim Secret clearances are not allowed.
- Bachelor’s degree in a related technical discipline and 8 years of experience, or an equivalent combination of education, technical certifications or training, or work experience.
- DoD 8140 certification, such as Security+ CE or higher.
- Strong hands-on experience designing Power BI dashboards and semantic models.
- Proficiency with DAX, Power Query, data profiling, and visualization best practices.
- Understanding of relational SQL concepts and ability to read and interpret upstream data structures.
- High-level familiarity with Azure Synapse, data lakes, and parquet datasets.
- Ability to partner with ETL developers to ensure datasets are ready and aligned with reporting needs.
- Strong communication skills to explain complex data relationships to technical and non-technical audiences.
- Experience documenting reports, models, and data flows.
- U.S. citizenship is required.
Nice To Haves
- Familiarity with DoD identity ecosystems, authoritative identity governance, and enterprise ICAM modernization efforts.
- Understanding of identity governance metrics, role and entitlement models, access reviews, and certification reporting.
- Exposure to Python, Spark, SQL, or data transformation scripts.
- Familiarity with CI/CD practices for Power BI deployment pipelines.
- Knowledge of Zero Trust analytics, audit reporting, or enterprise compliance frameworks.
Responsibilities
- Design, build, and optimize Power BI dashboards, reports, and datasets for identity lifecycle, entitlements, access certifications, joiner/mover/leaver activities, and compliance workflows.
- Create and maintain semantic models, data relationships, DAX measures, and reusable reporting components.
- Partner with ETL engineers to understand Azure Synapse data pipelines that produce parquet datasets from SailPoint SQL sources.
- Validate that incoming parquet datasets contain complete, accurate, and appropriately structured data for reporting.
- Gather reporting requirements with stakeholders, design prototypes, refine KPIs, and ensure dashboards support mission needs.
- Establish data-quality validation checks and refresh monitoring to ensure reporting outputs are accurate and timely.
- Align reporting with governance, audit, and Zero Trust requirements in collaboration with IGA, cybersecurity, and operations teams.
- Document semantic models, business logic, data lineage, and visualization standards for enterprise use.
- Recommend improvements to datasets, transformations, and visualization techniques.
Benefits
- Comprehensive benefits and wellness packages.
- 401(k) with company match.
- Competitive pay and paid time off.
- Full-flex work weeks where possible.
- Medical plan options, including some with Health Savings Accounts.
- Dental and vision plans.
- Paid leave options including vacation, sick and personal time, holidays, paid parental, military, bereavement, and jury duty leave.
- Typically 15 days of paid leave per calendar year for new employees, prorated based on hire date.
- Typically 10 paid holidays per year, prorated based on hire date.
- Up to 160 hours of paid family leave in a rolling 12-month period for eligible employees.
- Short- and long-term disability benefits.
- Life, accidental death and dismemberment, personal accident, critical illness, and business travel and accident insurance are provided or available.
- Career growth resources, including an AI-powered career tool and an internal mobility team.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
