$92.9K – $153.9K/yr

Open for applications
Cyber Managed Services - Data Engineer - Senior
- Pay · listed with the ad
- $92,900 – 153,900 a year
- Job type
- Not stated
- Work mode
- Not stated
- Experience
- 6–9 years
About the job
Location: Dallas, Alpharetta, Charlotte, Jacksonville, and San Antonio
At EY, we’re all in to shape your future with confidence.
We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.
Position Summary
The role will design, develop, test, deploy, and support secure, scalable data solutions that consolidate identity and access data from enterprise source systems into a centralized operational data store. The platform supports access visibility, operational reporting, risk analysis, remediation, automation, and decision-making across.
The engineer will contribute across the data-delivery lifecycle, including source-system discovery, data analysis, dimensional and relational modeling, ETL development, pipeline orchestration, data-quality validation, performance tuning, release automation, and production support. This role requires strong recent hands-on Microsoft SQL Server or Azure SQL engineering experience and the ability to deliver independently within an integrated Agile product team.
Key Responsibilities
- Design, develop, test, and maintain robust data pipelines and database solutions supporting the IAM Operational Data Store and related reporting applications.
- Analyze source-system data and translate business, reporting, risk, and control requirements into scalable conceptual, logical, and physical data models.
- Develop and optimize Microsoft SQL Server and Azure SQL objects, including complex queries, stored procedures, views, functions, indexing, partitioning, and transformation logic.
- Build repeatable ETL and ingestion patterns for identity, account, entitlement, credential, inventory, activity, certification, lifecycle, and control-related data.
- Develop and maintain SnapLogic pipelines and supporting scripts for data extraction, transformation, validation, reconciliation, and loading.
- Integrate data from cloud and on-premises sources using databases, APIs, Microsoft Graph, flat files, and other enterprise integration patterns.
- Create prepared-layer tables, source-to-target mappings, reusable transformation components, and reporting-ready datasets.
- Implement data-quality checks, reconciliation routines, health indicators, exception handling, logging, retry logic, and operational monitoring.
- Tune database queries, pipelines, and data models to improve performance, scalability, reliability, and cost effectiveness.
- Protect sensitive identity and access data by applying secure database design, least-privilege access, secrets-management, encryption, and data-handling practices.
- Build and maintain CI/CD pipelines and deployment processes supporting controlled promotion across development, quality-assurance, pre-production, and production environments.
- Perform unit, integration, regression, data-quality, and production-validation testing for ingestion pipelines and database changes.
- Troubleshoot data, application, pipeline, database, API, and deployment issues using logs, query plans, monitoring tools, and reconciliation evidence.
- Collaborate with analysts, product owners, architects, data-source owners, reporting engineers, security teams, and business stakeholders to define and deliver end-to-end data solutions.
- Participate in Agile ceremonies, backlog refinement, sprint planning, demonstrations, code and design reviews, release readiness, and continuous-improvement activities.
- Create and maintain technical designs, data models, lineage documentation, implementation procedures, test evidence, operational runbooks, and support materials.
Required Qualifications
- Bachelor’s degree in computer science, data engineering, information technology, information systems, or a related field, or equivalent practical experience.
- Approximately 6–9 years of enterprise data-engineering, database-development, or related experience.
- At least five years of strong SQL development experience, including complex queries, stored procedures, performance tuning, indexing, and relational database design.
- Recent hands-on development experience within the last three years using Microsoft SQL Server, Azure SQL Database, or Azure SQL Managed Instance.
- Strong understanding of relational and dimensional data modeling, normalization, data warehousing, operational data stores, fact and dimension structures, and slowly changing dimensions.
- Experience designing, developing, and supporting ETL pipelines and data-ingestion solutions for high-volume, multi-source enterprise data.
- Experience with SnapLogic or a comparable enterprise integration platform.
- Proficiency in one or more supporting languages or tools such as Python, PowerShell, Unix shell scripting, or PL/SQL.
- Experience with Microsoft Azure data services and cloud-based database solutions.
- Experience implementing data-quality checks, source-to-target reconciliation, error handling, logging, monitoring, and operational support processes.
- Experience with Git-based source control, CI/CD pipelines, automated deployment, and tools such as Jenkins and Docker.
- Experience testing database changes, transformations, and end-to-end ingestion flows across multiple environments.
- Familiarity with Agile delivery practices and tools such as Jira and Confluence.
- Strong analytical, problem-solving, documentation, communication, and stakeholder-management skills.
- Ability to work independently, review existing solutions, identify gaps, and deliver production-ready enhancements with limited ramp-up time.
Preferred Qualifications
- Experience delivering data solutions for identity and access management, identity governance, privileged access management, cybersecurity, or technology-risk use cases.
- Familiarity with IAM data domains such as identities, accounts, entitlements, applications, credentials, privileged access, certifications, and lifecycle events.
- Experience building centralized operational data stores that support reporting, risk analysis, remediation, automation, and audit evidence.
- Hands-on experience with SnapLogic, including API, database, file, and cloud integration pipelines.
- Experience integrating Microsoft Graph, REST APIs, LDAP or Active Directory data, and structured or semi-structured file sources.
- Experience with Azure Data Factory, Azure Databricks, PySpark, Informatica, Snowflake, Oracle, PostgreSQL, or comparable data technologies.
- Familiarity with Microsoft SQL Server, PostgreSQL variants such as YugabyteDB or CockroachDB, Oracle, DB2, and cloud-hosted database inventory or audit data.
- Experience creating reporting-ready datasets for Power BI, Tableau, or comparable analytics platforms.
- Experience with graph databases or analytics platforms such as Neo4j.
- Familiarity with data lineage, metadata management, control reporting, and enterprise data-governance practices.
- Experience in a regulated financial-services environment and knowledge of secure software development, change management, and production-readiness controls.
- Relevant Microsoft Azure, database, data-engineering, or cybersecurity certifications.
Technology Environment
- Database and query development: Microsoft SQL Server, Azure SQL Database, Azure SQL Managed Instance, stored procedures, complex SQL, indexing, partitioning, query optimization, and relational data modeling.
- Data integration and engineering: SnapLogic, ETL pipelines, source-to-target mapping, prepared-layer tables, data profiling, transformation, reconciliation, data-quality checks, and lineage management.
- Cloud and source systems: Microsoft Azure, Microsoft Graph, REST APIs, Active Directory, Oracle, PostgreSQL, YugabyteDB, CockroachDB, DB2, Snowflake, structured files, and enterprise application data.
- Development and automation: Python, PowerShell, Unix shell scripting, PL/SQL, Git, Jenkins, Docker, CI/CD pipelines, automated testing, and deployment automation.
- Reporting and analytics: Operational reporting datasets, Power BI, Tableau, dashboard enablement, Neo4j graph analytics, and AI-assisted IAM analysis and remediation use cases.
- IAM ecosystem: Data from identity, account, entitlement, credential, inventory, certification, lifecycle, database, server, privileged access, and access governance systems/sources.
Success Measures
- Reliable, secure, scalable, and maintainable data pipelines delivered against sprint and release commitments.
- Accurate and timely ingestion of IAM data into the Operational Data Store across development, quality-assurance, pre-production, and production environments.
- Improved completeness, quality, traceability, and usability of identity and access data.
- High-performing SQL solutions and data pipelines that meet operational reporting and analytics requirements.
- Clear source-to-target mappings, data lineage, technical documentation, testing evidence, and operational runbooks.
- Successful data reconciliation and resolution of exceptions across integrated source systems.
- Reduced manual effort through reusable ingestion patterns, automated data-quality controls, and deployment automation.
- Effective collaboration with analysts, product owners, architects, data-source owners, reporting engineers, security teams, and business stakeholders.
- Consistent adherence to Fidelity security, data, architecture, engineering, change-management, and production-readiness standards.
What we offer you
At EY, we harness our collective strength to empower you to shape your future with confidence through professional grow
Skills in this ad
Qualification · Bachelor’s degree in computer science, data engineering, information technology, information systems, or a related field, or equivalent practical experience
More like this
EY
Technology
EY provides consulting, assurance, tax and transaction services that help solve our client’s toughest challenges and build a better working world for all.
Similar jobs
All jobs$92.9K – $153.9K/yr
$92.9K – $153.9K/yr
$125.8K – $209.7K/yr
$73.1K – $109.2K/yr
Cyber Managed Services payCareer pathCheck my market payJobs that ask for a bachelor's degreeRoles in demandTailor your CV for this job
About this listing
- First seen by Jobiba 21 Nov 2026
Jobiba never charges you to apply. Never pay to apply or share OTPs, card or bank details.