At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

 

 

 

 

Career Family
SQL Data Warehouse
Role Type: Data Analytics
 

The opportunity
This role will be responsible for creating Data orchestration with Azure Data Factory Pipelines & Dataflows. The key role is to understand the business requirements and implement the requirements using Azure Data Factory.
 

Your key responsibilities

Working with the client team, perform development and provide L3 support to database integrations and data warehouse using SQL Server, SSIS, Azure, 3rd party tools, etc. Good research, analysis and problem-solving skills Ability to estimate work items in a systemic manner Strong understanding of Software Development Life Cycle (including agile development methodology) Hands on development and maintenance of the SQL based systems and various associated components for data ingestion, transformation and processing. Hands on development and maintenance of integrations with various (including bespoke) Financial (Applications and Management Information Systems), Underwriting and Claims Management Systems and other systems based on business requirements. Ensure data quality and accuracy by implementing business and technical reconciliations via scripts, profiling and data analysis; analyze and create data mappings. Develop and support objects and code for data profiling, extraction, load and updates. Provide and maintain documentation for all developed objects and processes, in strict timelines. Integration testing of deliverables. Develop and run test scripts to ensure the quality of code and integrity. Use source code control repository (using VSTS,GIT) – preferred GIT  Following data / integration design patterns and architecture as prescribed by the Architects. Come up with suggestions and recommendations where required. 

 

Skills and attributes for success

Minimum of 3 years of ETL development on SQL Integration Projects using SQL Server Integration Services (SSIS) and SQL Server database objects Experience in implementing Type 2 Dimension Data models and data warehouse ETL techniques for historical data  Experience in development of complex / enterprise data warehouse implemented over standard RDBMS (using SQL Server Integration Services (SSIS) and SQL Server database objects)  Ability to understand/re-write nested complex SQL script  Experience of analysis and resolution of data quality and integration issues Experience of Database queries (SQL) and performance tuning Experience in providing and maintaining technical documentation, specifically Data Mapping and Low Level / ETL Design Documentation Experience of working both independently and collaboratively with various teams and global stakeholders (Business Analysts/Architects/Support/Business) in an agile approach while working on projects or data quality issues Experience of upgrading/converting SQL based system to new versions (SQL Code and Objects) – preferable Microsoft Azure - PaaS fundamental knowledge - preferable   Experience in Attunity tools (e.g. Compose, replicate) – preferable   Insurance Domain Experience – nice to have Experience working on SSAS Cubes (development & design), along with troubleshooting performance and processing issues – nice to have Experience in BIML based development – nice to have Experience in source control using GIT  Possess and demonstrate deep knowledge of data warehouse concepts, techniques, various design alternatives, and overall data warehouse strategies. Knowledge of Type 2 Dimension Data model and data warehouse ETL techniques for historical data Excellent communication and interpersonal skills Ability to work in a geographically dispersed team environment. Demonstrable ability to work on multiple activities simultaneously, and work to deadlines. Good written and verbal communication and interpersonal skills. Good understanding of development methodologies, frameworks and best practices. Ability to work outside of regular working hours where necessary to ensure global migrations are successfully tested. 

 

To qualify for the role, you must have

Degree in Engineering, IT, Computer Science Cloud Computing – Azure / AWS Relational databases – SQL Server Integration Service - SSIS, Azure ADF Power BI

 

Ideally, you’ll also have

Certification in Azure Data Engineering

 

Technologies and Tools 

Azure, AWS SSIS, Azure ADF, SQL Server SSDT, SSMS, Azure Data Studio

 

What we look for 

Seeks opportunities to drive Customer Success and business results by collaborating with multiple team members. Identifies opportunities to articulate business value and grow customer relationships in alignment with Customer Success business priorities and stakeholder management principles. Provides and drives actionable feedback across groups about the customer experience and competitor threats. Delivers given feedback, modifies existing intellectual property (IP) or, where applicable, creates new content. Seeks opportunities to drive Customer Success and business results by collaborating with multiple team members.  

What we offer
EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across six locations – Argentina, China, India, the Philippines, Poland and the UK – and with teams from all EY service lines, geographies and sectors, playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants, we offer a wide variety of fulfilling career opportunities that span all business disciplines. In GDS, you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. We’ll introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career. 

Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.  Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.  Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.  Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs. 

 

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.