AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Engaged Employer
i
This company page is being actively managed by
Ernst & Young Team. If you also belong to the team, you
can get access from
here
Ernst & Young
Compare
All Filters
25 Ernst & Young Senior Analyst Jobs
SaT-DnA-Data Engineer - Senior Analyst
6-8 years
₹ 4 - 15L/yr (AmbitionBox estimate)
This is an estimate of the average salary range for this
position. It has not been reviewed by the company, and
the actual salary may differ.
Bangalore / Bengaluru
1 vacancy
SaT-DnA-Data Engineer - Senior Analyst
Ernst & Young
posted 2d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
This role will be instrumental in designing, developing, and evolving the modern data warehousing solutions and data integration build-outs using cutting edge tools and platforms for both on-prem and cloud architectures. In this role you will be coming up with design specifications, documentation, and development of data migration mappings and transformations for a modern Data Warehouse set up/data mart creation and define robust ETL processing to collect and scrub both structured and unstructured data providing self-serve capabilities (OLAP) in order to create impactful decision analytics reporting.
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 driven tools to create workflows)
- Experience in design documentation (data mapping, technical specifications, production support, data dictionaries, test cases, etc.)
- Provides technical leadership 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 6 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, modeling and integration experience with relational data sources, such as SQL Server databases ,Oracle/MySQL, Azure SQL and Azure Synapse
- Strong in PySpark, SparkSQL
- 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.
- Aggressive 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 lifecycle (SDLC) and principles of product development such as installation, upgrade and namespace management
- Willingness to mentor team members
- Solid analytical, technical and problem-solving skills
- Excellent written and verbal communication skills
To qualify for the role, you must have
- Bachelor s or equivalent degree in computer science, or related field, required. Advanced degree
- or equivalent business experience preferred
- Fact driven and analytically minded with excellent attention to details
- Hands-on experience with data engineering tasks such as building analytical data records and experience manipulating and analyzing large volumes of data
- Relevant work experience of minimum 6 to 8 years in a big 4 or technology/ consulting set up
Ideally, you ll 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
- Experience in Snowflake
Employment Type: Full Time, Permanent
Read full job descriptionErnst & Young Interview Questions & Tips
Prepare for Ernst & Young Senior Analyst roles with real interview advice
Top Ernst & Young Senior Analyst Interview Questions
Q1. Valuations multiples understanding & how to use them
asked in
Senior Analyst interview
Q3. Is Winzip a free or paid software for commercial purpose?
asked in
Senior Analyst interview
What Senior Analyst at Ernst & Young are saying
Rating based on 216 Senior Analyst
reviews
Anonymous · Risk Management & Compliance
in Mumbai
Likes
Leaves can be taken anytime as they are self approved.
Dislikes
Unnecessary people connect team, forces to join. HRs doesn't respond. Working hours depends on team/client.
- Skill development - Poor
+2 more
Senior Analyst salary at Ernst & Young
reported by
3k
employees
₹4.5
L/yr - ₹17
L/yr
20%
more
than the average Senior Analyst Salary in India
View more details
What Ernst & Young employees are saying about work life
based on 10.8k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Ernst & Young Benefits
View more benefits
Compare Ernst & Young with
Deloitte
Compare
PwC
Compare
EY Global Delivery Services ( EY GDS)
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Amazon
Compare
Wipro
Compare
Capgemini
Compare
IBM
Compare
Compare
Microsoft Corporation
Compare
Infosys
Compare
KPMG India
Compare
Bain & Company
Compare
McKinsey & Company
Compare
BCG
Compare
ZS
Compare
Mercer
Compare
Willis Towers Watson
Compare
Similar Jobs for you
Ernst & Young Bangalore / Bengaluru Office Locations
Bangalore Office
Ernst & Young, 3rd Floor, Tower C, RMZ Infinity Municipal No. 3, Survey No 1477/2 & 10, Old Madras Road, Benniganahalli, K.R. Puram
Bangalore
Karnataka 560016
Karnataka 560016
Bengaluru Office
Ernst & Young
Tower C, 3rd Floor, RMZ Infinity
Municipal No. 3, Old Madras Road
Survey No 1477/2 & 10
Benniganahalli, K.R. Puram
560016 Bengaluru
Ernst & Young
UB City, Canberra Block
12th & 13th Floor
No. 24, Vittal Mallya Road
Bengaluru
Bengaluru
560001
560001
Share an Interview