Data Engineer - Senior
Ernst and Young1 month ago
Bengaluru, IndiaSenior
Responsibilities
- Design, architect, and implement data solutions using SQL Server Integration Services and related Microsoft data technologies.
- Develop and maintain SSAS tabular and multidimensional models for analytics and reporting.
- Create, deploy, and manage ETL/ELT pipelines while ensuring data accuracy and integrity.
- Develop interactive, tabular, graphical, and free-form reports using SSRS and Power BI dashboards.
- Design and optimize data warehouses and SQL and NoSQL storage solutions, including distributed storage and parallel processing approaches.
- Build new data platforms and integrate internal and external data sources to meet business needs.
- Participate in client-facing Risk Assurance engagements, assess IT control effectiveness, and facilitate remediation activities.
- Test IT general controls, IT application controls, IPE-related controls, and interface controls, and help design IT risk control frameworks such as IT SOX.
- Direct daily engagement progress, communicate status to engagement managers, and manage staff performance.
- Communicate findings, recommendations, risks, and opportunities to technical and non-technical audiences.
Requirements
- At least 4 years of experience designing and implementing end-to-end business solutions using Big Data technologies and data engineering practices.
- Demonstrated expertise with SSIS, SSAS, SSRS, Power BI, and planning or architecting solutions based on business requirements.
- Proficiency with Logic Apps, complex stored procedures, triggers, SSIS event handlers, and audit and configuration logging.
- Competency in at least one data engineering language such as Python, SQL, R, or Scala, with preference for multiple languages.
- Strong SQL skills for data manipulation, reporting, and query optimization.
- Preferred experience with Azure Data Factory and Synapse Analytics for data extraction, transformation, and pipeline development.
- Familiarity with Spotfire or Tableau is advantageous.
- Knowledge of Git, JIRA, change and release management, and CI/CD practices using Azure DevOps.
- Exposure to IT controls, risk, compliance, internal audit, IT security, and client-facing work.
- A bachelor’s degree or higher in mathematics, information systems, statistics, computer science, or a related discipline is preferred, and relevant certifications and AI/ML experience are a plus.
- Strong written, verbal, communication, and collaboration skills.
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.