Your key responsibilities - Evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management and warehouse administration for both on-prem and cloud based engagements
- Strong working knowledge across the technology stack, including ETL, ELT, data analysis, metadata, data quality, audit and design
- Design, develop, and test in ETL tool environment (GUI/canvas steered tools to create workflows)
- Experience in design documentation (data mapping, technical specifications, production support, data dictionaries, test cases, etc.)
- Provides technical guidance to a team of data warehouse and business intelligence developers
- Coordinate with other technology users to design and implement matters of data governance, data harvesting, cloud implementation strategy, privacy, and security
- Adhere to ETL/Data Warehouse development Best Practices
- Responsible for Data orchestration, ingestion, ETL and reporting architecture for both on-prem and cloud (MS Azure/AWS/GCP)
- Assisting the team with performance tuning for ETL and database processes
.
Skills and attributes for success
- Minimum of 7 years of total experience with 3+ years in Data warehousing/ Business Intelligence field
- Solid hands-on 3+ years of professional experience with creation and implementation of data warehouses on client engagements and helping create enhancements to a data warehouse
- Strong knowledge of data architecture for staging and reporting schemas, data models and cutover strategies using industry standard tools and technologies
- Architecture design and implementation experience with medium to complex on-prem to cloud migrations with any of the major cloud platforms (preferably AWS/Azure/GCP)
- Minimum 3+ years experience in Azure database offerings [Relational, NoSQL, Datawarehouse]
- 2+ years hands-on experience in various Azure services preferred Azure Data Factory, Kafka, Azure Data Explorer, Storage, Azure Data Lake, Azure Synapse Analytics, Azure Analysis Services & Databricks
- Minimum of 3 years of hands-on database design, modelling and integration experience with relational data sources, such as SQL Server databases, Oracle/MySQL, Azure SQL and Azure Synapse
- Minimum of 3 years of hands-on Programming language preferably Python
- Knowledge and direct experience using business intelligence reporting tools (Power BI, Alteryx, OBIEE, Business Objects, Cognos, Tableau, MicroStrategy, SSAS Cubes etc.)
- Strong creative instincts related to data analysis and visualization.
- Curiosity to learn the business methodology, data model and user personas.
- Strong understanding of BI and DWH best practices, analysis, visualization, and latest trends.
- Experience with the software development life cycle (SDLC) and rules of product development, such as installation, upgrade and namespace management
- Willingness to mentor team members
- Solid thoughtfulness, technical and problem solving skills
- Excellent written and verbal communication skills
To qualify for the role, you must have
- Bachelors or equivalent degree in computer science, or related field, required. Advanced degree
- or equivalent business experience preferred
- Fact steered and thoughtfulness with excellent attention to details
- Hands-on experience with data engineering tasks such as building analytical data records and experience manipulating and analysing large volumes of data
- Relevant work experience of minimum 7 to 9 years in a big 4 or technology/ consulting set up
Ideally, youll also have
- Ability to think strategically/end-to-end with result-oriented mindset
- Ability to build rapport within the firm and win the trust of the clients
- Willingness to travel extensively and to work on client sites / practice office locations
What we look for
- A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
- An opportunity to be a part of market-prominent, multi-disciplinary team of 1400 + professionals, in the only integrated global transaction business worldwide.
- Opportunities to work with EY SaT practices globally with prominent businesses across a range of industries
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. Well introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career.
-
Continuous learning:
Youll develop the mindset and skills to navigate whatever comes next. -
Success, as defined by you
:
Well provide the tools and flexibility, so you can make a meaningful impact, your way. -
Transformative leadership
:
Well give you the insights, coaching and confidence to be the leader the world needs. -
Diverse and inclusive culture:
Youll be embraced for who you are and empowered to use your voice to help others find theirs.
EY | Building a better working world
EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.
Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.
EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.
.outershelley div.searchwell a:hover, .outershelley div.searchwell a:focus, .outershelley div.search a:hover, .outershelley div.search a:focus { color: rgba(53, 164, 232, 1.0) !important;}.job-page .jobDisplay > .content .job h1:after, .job-page .jobDisplay > .content .job h2:after { content: ""; position: absolute; bottom: -0.6em; left: 0; width: 2em; border-bottom: solid 4px rgba(53, 164, 232, 1.0) !important;}#body .outershelley .btn, #body .outershelley input[type="submit"] { background-color: rgba(53, 164, 232, 1.0) !important; border-color: rgba(53, 164, 232, 1.0) !important;}#body .outershell .btn, #body .outershell input[type="submit"] { background-color: rgba(53, 164, 232, 1.0);border-color: rgba(53, 164, 232, 1.0) !important;} a.btn.btn-primary.btn-large.btn-lg.apply.dialogApplyBtn { border-color: rgba(53, 164, 232, 1.0) !important; background-color: rgba(53, 164, 232, 1.0) !important;}button#savesearch-link { background-color: rgba(53, 164, 232, 1.0) !important; border-color: rgba(53, 164, 232, 1.0) !important;}#savesearch .savesearch-buttons-wrapper .btn { border-radius: 0; color: black !important;}a.btn.btn-primary.btn-large.btn-lg.apply.dialogApplyBtn { color: White !important;}.jobDisplay { padding-top: 40px;}div#search-wrapper { display: none;}
