Cyber Managed Services - Data Engineer - Senior
EY · Dallas, TX, US, 75219
- 5 days ago
EY is hiring for the Cyber Managed Services - Data Engineer - Senior position in Dallas, TX, US, 75219, United States, in technology & it. The advert does not state the pay. The advert gives no closing date.
Apply on the employer's website
At a glance
- Role
- Cyber Managed Services - Data Engineer - Senior
- Employer
- EY
- Where
- Dallas, TX, US, 75219, United States
- Field
- Technology & IT
- Pay
- Not stated in the advert
- Posted
- 5 days ago
- Closes
- No closing date given
- How to apply
- Directly on the employer's own careers site
The employer's advert
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.
Apply on the employer's website
More openings at EY
- Consulting - Managed Services - SAP Pursuit & Delivery - Senior Manager New York, NY, US, 10001-8604
- Technology Consulting - Managed Services - Digital Engineering Operations Services - Senior Manager Atlanta, GA, US, 30309
- Technology Consulting - Managed Services - ServiceNow & Service Management - Senior Manager Atlanta, GA, US, 30308
- Senior Tax Manager - Private Tax - Calgary Calgary, AB, CA, T2P 1M4
- Senior Manager: Centre of Excellence (COE) Audit Delivery Johannesburg, Gp, ZA, 2146
Similar jobs in United States
- Staff Software Engineer Washington, District of Columbia, United States
- Sr. System Engineer - Power Electronics Farmington Hills, MI, United States
- Hardware Systems Engineer, Tooling Austin, TX
- Strategic Account Director, Developer Platform Austin, TX; New York, NY; San Francisco, CA; Seattle, WA
- Software Integration Engineer (Multiple Positions) REF301293H Plymouth, MI, United States
- Manager, Machine Learning Engineering Remote US