Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Data Engineer - Security Evolution

Expert In Recruitment Solutions

Job Description

Job Description

We are seeking a Senior Data Engineer with deep Informatica PowerCenter, Oracle and Microsoft SQL Server experience to deliver secure identity and access management (IAM) data integrations. The engineer will design and operate ETL workflows that extract application accounts, users, roles and entitlements from databases, APIs, and file-based sources; transform them into accurate, auditable outbound feeds; and support delivery to SailPoint or other IAM/identity governance platforms. Success requires strong SQL tuning, robust batch operations and a hands-on approach to source-system discovery and production issue resolution.



Required Skills - 6-7 years of data integration, ETL or enterprise data engineering experience preferred.
Strong hands-on Informatica PowerCenter mapping, workflow and session development, deployment and troubleshooting.
Advanced Oracle and Microsoft SQL Server SQL development and performance tuning.
Job Responsibilities

Job Duties - ETL and identity data integration
Design, develop, enhance and support Informatica PowerCenter mappings, sessions and workflows for enterprise identity and entitlement data.
Build source-to-target mappings and transformation rules across Oracle, Microsoft SQL Server, APIs and flat-file sources.
Extract, normalize and reconcile user accounts, role assignments, permissions, service accounts and access relationships from legacy and modern systems.
Develop outbound IAM/identity governance feeds, including scheduled access certification files and entitlement data extracts.
Implement reliable, controlled flat-file creation and secure file transfer, including file naming, validation, delivery tracking and exception handling.
Coordinate with SailPoint/IAM teams to agree target formats, required attributes, data quality rules, delta/full-load behavior and reconciliation processes.
Database engineering and operational quality
Develop advanced SQL and database objects for Oracle and SQL Server; tune joins, extraction queries, indexing strategy and ETL throughput.
Investigate source schemas to identify identity and role tables, interpret custom authorization structures and document lineage.
Build workflow scheduling, monitoring, restart/recovery procedures, failure alerts, control totals, audit trails and idempotent reprocessing.
Troubleshoot failed ETL jobs, malformed files, connectivity failures, missing entitlements and source-to-target discrepancies.
Execute data profiling, quality checks, deduplication, completeness testing, reconciliation and system/integration testing.
Partner with DBAs, developers, cybersecurity, IAM and support teams to manage performance, database access and operational stability.
Legacy sources and migration support
Support discovery and integration of legacy feeds and mainframe-derived user/access information where required.
Collaborate with mainframe specialists on DB2, COBOL, JCL and z/OS interfaces and batch extract schedules, without requiring ownership of mainframe program development.
Document end-to-end lineage, schedules, control mechanisms, mappings and support procedures; enable repeatable delivery across application portfolios.



Job Requirements - Required Qualifications & Technical Skills
6-7 years of data integration, ETL or enterprise data engineering experience preferred.
Strong hands-on Informatica PowerCenter mapping, workflow and session development, deployment and troubleshooting.
Advanced Oracle and Microsoft SQL Server SQL development and performance tuning.
Experience building, validating and scheduling secure flat-file and database-driven ETL interfaces.
Experience with source-to-target mappings, data quality rules, transformation logic, reconciliation and batch restart/recovery.
Familiarity with enterprise security/entitlement data models, or demonstrated ability to map complex reference and relationship data.
Strong incident troubleshooting, stakeholder communication, technical documentation and production-support skills.
Working knowledge with AI tools like Claude, Cursor or Copilot.



Desired Skills & Experience - Preferred Qualifications


Experience integrating identity and access data with SailPoint or a similar IAM/identity governance platform.
Experience developing daily account/entitlement certification extracts and outbound security data feeds.
Knowledge of Informatica Intelligent Data Management Cloud (IDMC), Python or shell scripting.
Exposure to JDBC, REST/SOAP APIs, secure transfer protocols and service-account authentication.
Experience with mainframe data sources (DB2/z/OS), JCL batch outputs, COBOL-based systems or fixed-width flat files.
Familiarity with GCP/BigQuery, cloud data pipelines or insurance-sector data platforms.


NOTES ON MUST HAVES:


MUST-data integration, ETL or enterprise data engineering experience preferred.
MUST- Strong hands-on Informatica PowerCenter mapping, workflow and session development, deployment and troubleshooting.
MUST- Advanced Oracle and Microsoft SQL Server SQL development and performance tuning.
MUST- AI tools like Claude, Cursor or Copilot.
MUST- Experience integrating identity and access data with SailPoint or a similar IAM/identity governance platform.
MUST- Senior enough with ability communicate and work without direct supervision
MUST- Experience working with offshore team




- Blend of skills and can think on feet, have analysis conversations (format for data to go into Identity IIQ)
- Ability to do reverse engineering
- Will use Claude for analysis, develop queries and code but not push to production


NOTES ON THE PROJECT:
"We're upgrading our internal security infrastructure by integrating our applications with Identity IQ. The core goal is to automate access management ensuring employees have the exact permissions they need as they join the company, change roles, or leave. We're looking for someone to help build out these integrations and give our security team better visibility. "


Key Project Details:


The Technical Focus: Managing "CRUD " access (Create, Read, Update, Delete) so the security team has full visibility into privileged actions.


The Full Scope: Out of a portfolio of 108 applications, 34 have been identified as needing remediation to integrate with Identity IQ.


Immediate Phase 1: The team is starting by integrating a priority batch of 10 applications through direct queries to Identity IQ.


Business Impact: Preventing security gaps by ensuring access is instantly updated or revoked as personnel changes happen.

Vacancy posted 21 days ago
Similar jobs that could be interesting for youBased on the Senior Data Engineer - Security Evolution in Atlanta, GA vacancy
  • $150k - $200k

     ...with experience as, or applicable to, a Senior Data Engineer role with significant demonstrated...  ...version control Contribute to the evolution of our Lakehouse architecture to support...  ...Understanding of data governance, security, and compliance best practices Benefits... 
    Senior
    Full time
    Work experience placement
    Remote work

    Plum AI

    Atlanta, GA
    4 days ago
  •  .... Job Purpose and Impact The Senior Data Engineering job designs builds and maintains complex...  ...concepts like SCD and schema evolution. DATA TRANSFORMATION: Strongbackground...  ...principles including data quality privacy and security considerations for data product... 
    Senior
    Full time
    Work experience placement
    Visa sponsorship
    Work visa

    Cargill

    Atlanta, GA
    2 days ago
  • $134.9k - $224.9k

     ...experienced and dynamic hands-on Sr. Manager, Data Engineering, Data Science and AI to lead our...  ...data structures. Lead the design and evolution of a robust data warehouse architecture...  ...best practices in data governance, security, compliance, and quality management across... 
    Senior
    Work at office
    Visa sponsorship

    Cox

    Atlanta, GA
    2 hours ago
  •  ...you too. About the Team The Enterprise Security Engineering team is the frontline of Workday's...  ...team is for you. About the Role As a Senior Cybersecurity Engineer on the Enterprise...  ...procedures that protect information and data from unauthorized access or damage. Experience... 
    Senior
    Full time
    Work at office
    Remote work
    Home office
    Flexible hours

    Workday

    Atlanta, GA
    12 days ago
  • ## Senior Data EngineerApply: Atlanta, Georgia: Full time: Posted Today: R16429Atlanta, Georgia...  ...nationwide. As a Senior Data Engineer, you'll help shape the future of our data...  ...solutions.* Ensure data quality, integrity, security, and performance across data platforms.*... 
    Senior
    Full time
    Temporary work
    Work at office
    Flexible hours

    Guardian Pharmacy

    Atlanta, GA
    3 days ago
  •  ...Job Description We are seeking a Senior Java Developer to support enterprise...  ...legacy and modern applications. The engineer will investigate how applications store...  ...service-based integrations, and deliver secure user/entitlement data feeds to SailPoint or similar IAM platforms... 
    Senior

    Expert In Recruitment Solutions

    Atlanta, GA
    21 days ago
  • $160.06k - $216.5k

     ...Workday's structured enterprise data. Architect and integrate the...  ...advanced analytics, prompt engineering for large language models, and...  ...practices for the creation, evolution, and governance of semantics...  ...candidates' privacy and data security. Workday will never ask candidates... 
    Senior
    Work at office
    Remote work
    Flexible hours

    Workday

    Atlanta, GA
    3 days ago
  • $115k - $184k

     ...wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation...  ...governments realize their greatest potential. Title and Summary Senior Data Engineer Overview: Marketing Services Technology is seeking a... 
    Senior
    Full time
    Part time
    Worldwide
    Flexible hours

    Mastercard

    Atlanta, GA
    12 days ago
  • $175.5k - $180k

     ...and leading the implementation of scalable data architectures for cutting-edge AI and...  ...development of robust data pipelines, manage secure and governed data environments, and...  ...spearhead the design of complex feature engineering workstreams, ensuring our data assets are... 
    Senior
    Apprenticeship
    Easy work

    McKinsey & Company

    Atlanta, GA
    13 hours ago
  • $195.3k - $199.2k

     ...design, develop, and maintain scalable data pipelines and systems using Databricks on...  ...You will be leading and executing data engineering projects from inception to completion, ensuring...  ..., etc.)Experience with data governance, security, and compliance in a cloud... 
    Senior
    Apprenticeship
    Easy work

    McKinsey & Company

    Atlanta, GA
    3 days ago
  • $130k - $178k

     ...but building what comes next.Job Title:Senior Semantic Data EngineerCompany:PrologisA day in the...  ...operations. As a Senior Semantic Data Engineer on the Data Solutions team, you will help...  ...data quality, usability, performance, security, and production readiness.Develop and... 
    Senior
    Full time

    Prologis

    Atlanta, GA
    3 days ago
  •  ...percentage of time spent on each key responsibility. Advanced Data Engineering and Solution Design (80%) Architect and implement...  ...reporting. Implement Power BI best practices including Row-Level Security (RLS), deployment pipelines, performance optimization, and... 
    Senior

    ProArch

    Atlanta, GA
    3 days ago
  •  ...production-grade batch and streaming data pipelines across SQL Server,...  ..., backfills, replay, schema evolution, and data reconciliation....  ...-backed/external tables, secure sharing, and downstream data...  ...closely with Product, Application Engineering, Quality Assurance, DevOps/... 
    Senior
    Local area

    Robotic Process Automation

    Atlanta, GA
    3 days ago
  •  ...jobs, and grow. What You’ll Bring to the Team: Lead the design and delivery of large, cross-functional data engineering initiatives. Build scalable, reliable, secure, and well-governed data solutions that support analytics, reporting, business applications, and emerging... 
    Senior
    Work experience placement
    Work at office

    Florence

    Atlanta, GA
    2 days ago
  • $111k - $138.7k

     ...Role Summary Rivian is seeking a passionate and data-driven Senior Analytics Engineer to join our People Systems Team. In this pivotal role,...  ...Quality & Governance: Experience with data quality, data security, and monitoring initiatives. Data Ingestion Tools: Experience... 
    Senior
    Full time
    Contract work
    Temporary work
    Part time
    Local area
    Shift work

    Rivian

    Atlanta, GA
    13 hours ago
  • $110k - $130k

     ...We are looking for an experienced Senior Data Engineer with strong expertise in Databricks, Python, PySpark, Apache Spark, and large-scale data engineering. The ideal candidate will be responsible... 
    Senior
    Full time

    Neshent Technologies

    Atlanta, GA
    8 days ago
  • $147k

     ...Job Description Job Description Senior Data Engineer Location: Preference will be given to candidates located in Atlanta, GA or the D.C...  ...the organization’s analytical operations rest on a robust and secure foundation. This is a role for a highly technical and driven... 
    Senior
    Permanent employment
    Contract work
    Local area

    System One

    Atlanta, GA
    9 days ago
  • Job PurposeThe Senior Engineer, Information Security, GRC is part of a team responsible for the global Information Security program. The role would gain...  ...TechnologiesExcel, Workflow automation tools, Data collection, normalization, indexing, correlation, and visualization... 
    Senior

    Intercontinental Exchange

    Atlanta, GA
    2 days ago
  • $140k - $155k

     ...Job Description Job Description Senior Data Engineer Atlanta, GA or Washington, DC - ONSITE Compensation: $140,000.00 - $155,000.00Must...  ...Permanent Resident (Green Card Holder) per government contract Security Clearance: Must be able to obtain Public Trust In this... 
    Senior
    Permanent employment
    Contract work
    Local area

    System One

    Atlanta, GA
    27 days ago
  • $106.9k - $176.5k

     ...Office of the CTO, the Advanced Forward Engineering (AFE) team is comprised of cells of Forward...  ...EY’s products. We are seeking a Data Engineer to join AFE delivery pods, where...  ...data pipelines comply with governance, security, lineage, and access control requirements... 
    Senior
    Summer holiday
    Work at office
    Flexible hours

    Ernst & Young

    Atlanta, GA
    8 hours ago
  • $186.07k - $218.9k

     ...“surges.”Learn more about working at Coinbase. As a Senior Software Engineer on the Data Platform team within the Platform group, you will help build...  ...platform infrastructure. Architect end-to-end data security and observability services, including access controls... 
    Senior
    Local area

    Coinbase

    Atlanta, GA
    2 hours ago
  •  ...following job description:Manages large, technical information security projects, programs, and processes aligned with organizational goals...  ...to protect technology assets and ensure compliance with data security and privacy regulations. ESSENTIAL DUTIES AND RESPONSIBILITIESFollowing... 
    Senior
    Full time
    Part time
    Shift work
    Day shift

    Truist

    Atlanta, GA
    13 hours ago
  • $105.4k - $207.8k

     ...Summary As a Sr Consultant: AI Data Security in Deloitte's Cyber for AI team, you will...  ...combine client advisory with hands-on engineering to translate requirements into...  ...development From entry-level employees to senior leaders, we believe there’s always room... 
    Senior
    Local area
    Visa sponsorship

    Deloitte

    Atlanta, GA
    13 hours ago
  •  ...full autonomy and the data that powers that future...  ...starts here. As a Lead Data Engineer on our Industrial AI &...  ...2 years in a lead or senior role, demonstrating...  ...collaborationKnowledge of data security and governance...  ...architectures handling schema evolution, backpressure, and... 
    Temporary work
    Relocation package
    Flexible hours

    Honeywell

    Atlanta, GA
    1 day ago
  •  ...grow and make an impact, we’d love to be on your team.As a Senior Data Engineer you will build the enterprise data foundation that our reporting...  ...including ERP migrations, source-to-target mapping, schema evolution, data contracts, or equivalent transformation workReal... 
    Senior
    Permanent employment
    Full time

    AWC

    Atlanta, GA
    3 days ago
  •  ...Minds' client is seeking a principal-level data engineering leader to own enterprise-scale...  ...skills, including the ability to advise senior stakeholders and support multidisciplinary...  ...troubleshooting. Advance Data Governance and security through access controls, encryption,... 
    Permanent employment
    Work experience placement

    Thinking Minds Inc.

    Atlanta, GA
    13 hours ago
  • $117.6k - $161.7k

    Become a part of our caring communityThe Senior Data Engineer Designs, builds, and maintains data processing architectures and solutions enabling...  ...our consumers. This role will focus on building scalable, secure, data & analytics solutions that power analytics, clinical... 
    Senior
    Full time
    Temporary work
    Apprenticeship
    Work at office
    Remote work
    Work from home
    Home office

    Humana

    Atlanta, GA
    13 hours ago
  •  ...all fun. About The Team The Enterprise Data & AI Platform team provides the data-...  ...What You Will Be Doing You will lead the engineering and operational delivery of enterprise...  ...practices to keep critical data services stable, secure, scalable and ready for business use.... 
    Full time

    Fidelity Information Services, LLC

    Atlanta, GA
    4 days ago
  •  ...Databricks Data Engineer Anywhere Type: Permanent Category: Development Industry: Energy Workplace Type: Remote Standard...  ...to design, build, and maintain scalable, reliable, and secure data pipelines, infrastructure, and systems that support consulting... 
    Hourly pay
    Permanent employment
    Full time
    Remote work

    Eliassen Group

    Atlanta, GA
    1 day ago
  •  ...Overview The Databricks Data Engineer will be part of the Data Services team and help transform the delivery of data driven insights...  ...datasets, optimizing performance, and ensuring our data is accurate, secure, and accessible when it matters most. Essential Functions... 

    Gentiva

    Atlanta, GA
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Data Engineer - Security Evolution. Be the first to apply!