EY Consulting AI and DATA Manager - Power BI Architect
As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance
The opportunity
We re looking for Senior with strong technology and data understanding having proven delivery capability and client experience. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.
Education/Qualification
Bachelor s degree in Computer Science or related field, or equivalent education and experience
Requirements
- 8+ years of relevant consulting or industry experience
- 5+ years of hands-on development experience with Microsoft Business Intelligence stack especially Power BI
- 2+ years of hands-on development experience on Snowflake
- Ability to thrive in a fast-paced, dynamic, client-facing role where delivering solid work products to exceed high expectations is a measure of success
- Excellent leadership and interpersonal skills
- Eager to contribute in a team-oriented environment
- Strong prioritization and multi-tasking skills with a track record of meeting deadlines
- Ability to be creative and analytical in a problem-solving environment
- Effective verbal and written communication skills
- Adaptable to new environments, people, technologies and processes
- Ability to manage ambiguity and solve undefined problems
- Demonstrates proficiency in the development and administration at least one of the following areas
- Back-end data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development, and performance tuning
- Front-end reporting and analytics platforms including OLAP cube design, tabular data modeling, Performance Point, Power Pivot, Power View, Power BI Report and Dashboard development
- Extremely strong SQL skills
- Expertise in Snowflake
- Foundational knowledge of the following areas
- Metadata management
- Master Data Management
- Data Governance
- Data Analytics
- Deep experience in Kimball and Inmon modeling techniques
- Experience leading or working with Agile development methodology
- Willing to establish strong work relationships with clients and team members
- Ability to generate ideas and understand different points of view
Job Summary
- Oversee and support the design, development and implementation of data warehousing, reporting and analytics solutions that deliver information efficiently, with the end goal to solve business challenges and achieve business objectives
- Provide oversight and expertise in Data Modeling and Database Design
- Architect and develop data models, ETL packages, OLAP cubes, and reports utilizing Power BI applying best practices to the development lifecycle
- Documentation of source-to-target mappings, data dictionaries, and database design
- Identify areas of improvement to optimize data flows
- Installation and Administration of Microsoft SQL Server
- Lead and mentor junior resources
- Support business development efforts (proposals and client presentations)
- Identify opportunities to add value to the clients organization by effective use of information management
- Build relationships with key stakeholders responsible for information and performance management in clients organization
- Estimate effort and cost
Skills
- Power BI
- Data Modelling
- MS BI Product Suite
- Snowflake
Ideally, you ll also have
- Minimum 5 years of experience as Architect on Analytics solutions and around 2 years of experience with Snowflake.
- People with technical experience and enthusiasm to learn new things in this fast-moving environment