Cyber Managed Services - Data Engineer - Senior
Ernst and Young3 days ago
Base Salary
$78k - $141k/yr
Responsibilities
- Design, develop, test, maintain, and support data pipelines and database solutions for the IAM Operational Data Store.
- Analyze enterprise source data and create conceptual, logical, and physical relational and dimensional data models.
- Develop and optimize Microsoft SQL Server and Azure SQL queries, stored procedures, views, functions, indexes, partitions, and transformation logic.
- Build SnapLogic ETL and ingestion pipelines for identity, account, entitlement, credential, inventory, activity, certification, lifecycle, and control data.
- Integrate cloud and on-premises sources through databases, APIs, Microsoft Graph, flat files, Active Directory, and enterprise integration patterns.
- Implement data-quality checks, reconciliation, exception handling, logging, retries, monitoring, lineage, and operational support processes.
- Tune database queries, pipelines, and data models for performance, scalability, reliability, and cost effectiveness.
- Apply secure database design, least-privilege access, secrets management, encryption, and appropriate data-handling practices.
- Build and maintain CI/CD pipelines and automated deployment processes across development, QA, pre-production, and production environments.
- Perform unit, integration, regression, data-quality, and production-validation testing and troubleshoot data, application, database, API, and deployment issues.
- Collaborate with analysts, product owners, architects, data-source owners, reporting engineers, security teams, and business stakeholders.
- Create technical designs, data models, source-to-target mappings, lineage documentation, test evidence, runbooks, and support materials.
Requirements
- 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 SQL development experience involving complex queries, stored procedures, performance tuning, indexing, and relational database design.
- Recent hands-on experience within the last three years with Microsoft SQL Server, Azure SQL Database, or Azure SQL Managed Instance.
- Strong knowledge of relational and dimensional modeling, normalization, data warehousing, operational data stores, fact and dimension structures, and slowly changing dimensions.
- Experience designing and supporting ETL pipelines and high-volume, multi-source enterprise ingestion solutions.
- Experience with SnapLogic or a comparable enterprise integration platform.
- Proficiency with one or more of Python, PowerShell, Unix shell scripting, or PL/SQL.
- Experience with Microsoft Azure data services, cloud databases, data quality, reconciliation, monitoring, Git-based source control, CI/CD, Jenkins, and Docker.
- Experience testing database changes, transformations, and end-to-end ingestion flows across multiple environments.
- Familiarity with Agile delivery practices and Jira and Confluence.
- Preferred qualifications include IAM, identity governance, privileged access management, cybersecurity, technology-risk, Microsoft Graph, REST APIs, LDAP, Active Directory, Azure Data Factory, Azure Databricks, PySpark, Informatica, Snowflake, Oracle, PostgreSQL, YugabyteDB, CockroachDB, DB2, Power BI, Tableau, Neo4j, data governance, and regulated financial-services experience.
- Relevant Microsoft Azure, database, data-engineering, or cybersecurity certifications are preferred.
Benefits
- Medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.
- Professional growth opportunities, personal fulfillment, and an inclusive culture.
- The role is based in Dallas, Alpharetta, Charlotte, Jacksonville, or San Antonio offices; applications are accepted on an ongoing basis.
Tech Stack
Categories
Data Engineering
About Ernst and Young
Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.