This job has been expired a while ago. Please use your discretion.
BASIC

Tc-ea-data Architect Modeller-oracle-senior

Ey
Noida
Posted on: 08 Oct 2021

Job details


  • NATURE OF JOB Hybrid — WFH / WFO / CW
  • CATEGORY Programming
  • SALARY RANGE Best in the industry Annual
  • EXPERIENCE 1 – 3 Years
  • JOB TYPE Full Time
  • REGIONAL PREFRENCES India
  • NO. OF VACANCIES 1

Job description


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. Description EY-Consulting – Data Architect/Modeller-Oracle – Senior Consultant The opportunity We’re looking for Senior Consultant with expertise in Dimension/Data Modelling, Data warehousing & Database Design to join the EA group of our consulting Team.This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering. We are seeking experienced and motivated Dimension Modeller with a strong track record of Dimension Modelling, business analytics and data warehousing to join our team providing deep technical expertise in Data Modelling and Data warehousing, Analytics, Business Intelligence and Database across all industry sectors. Our Data Modellers work closely with external clients, presales, other architects and internal teams to design, build and enable solutions on different domains This role demands a highly technical, extremely hands-on Dimension Modelling who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on different business needs. The ideal candidate must have a good understanding of the value of data and analytics and proven experience in delivering solutions to different lines of business and technical leadership. From top to bottom approach, the Cloud data Engineer will engage with a customer to discover business problems and goals, and develop solutions using different cloud services. Your Key Responsibilities Analysing and translating business needs into long-term solution data models. Evaluating existing data systems. Working with the development team to create data models and data flows. Developing best practices for data coding to ensure consistency within the system. Reviewing modifications of existing systems for cross-compatibility. Implementing data strategies and developing physical data models. Updating and optimizing local and metadata models. Evaluating implemented data systems for variances, discrepancies, and efficiency. Model new features and subject areas and integrate them with existing structures to provide a consistent solution as well as develop and maintain documentation of the data architecture, data flows and data models. Deliver high quality client solutions that meet and exceed client and EY expectations and are delivered on-time and on-budget. Manage client solution delivery, including defining project approach, leading and motivating project teams, monitoring and managing project risks, managing client and EY key stakeholders, and successfully delivering client solutions. Identifying new business opportunities, including building strong client relations, understanding client needs and EY solution offerings, communicating client opportunities to EY leadership, and helping develop client opportunities. Skills And Attributes For Success Primary focus on structured approach to gather business requirements, ability to break down business requirement into KPIs, Dimensions and Facts. Expertise in Data warehousing patterns (Kimball/Inmon) and dimension modelling to develop, define and maintain different abstract layers of data models like conceptual, logical and physical. Expertise in Identifying the Business Process, Grain, Dimensions, Facts and build schemas. Hands on experience in data analysis and dimension modelling for analytical databases. Proficiency in Identifying new information capabilities needed to support business capabilities of a given business domain and to suggest and implement improvements in architecture. Strong knowledge of database structure systems and data mining. In-depth understanding of RDBMS concepts like 3NF, and expertise in writing advanced SQL queries Expertise in implementing different types of facts like- Additive, Non-Additive and Semi Additive fact and dimensions like - Conformed, Outrigger, Shrunken, Role-playing, Junk, Degenerate, Swappable and Step Dimensions Good knowledge of metadata management, data modelling, and related tools (Erwin or ER Studio or others) required. Experience in team management, communication, and presentation. To qualify for the role, you must have Minimum of 8 years of experience in Dimension/Data Modelling Minimum of 8 years of consulting experience in DW ,SQL,Oracle. Overall 8-10 years of industry experiences with sound knowledge of Data warehousing & Data Modelling using oracle tools Nice, you’ll also have Engaging with business partners and IT to understand requirements from various parts of an organization to drive the design, programming execution, and UAT for future state capabilities within the platform. Working in a fast-paced and dynamic environment while managing multiple projects and strict deadlines Good understanding of outsourcing and off shoring, building win/win strategies and contracts with suppliers Knowledge of Reporting Tools like – OBIEE/Power BI/Tableau Experience with Cloud data bases and ETL tool. What We Look For Consulting experience, including assessments and implementations Documenting requirements and processes (e.g., process flows) Working collaboratively in a team environment Excellent oral and written communication skills Strong analytical and problem-solving skills B.E. / Master’s degree required. What Working At EY Offers At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer: Support, coaching and feedback from some of the most engaging colleagues around Opportunities to develop new skills and progress your career The freedom and flexibility to handle your role in a way that’s right for you Responsibilities, Qualifications, Certifications EY-Consulting – Data Architect/Modeller-Oracle – Senior Consultant The opportunity We’re looking for Senior Consultant with expertise in Dimension/Data Modelling, Data warehousing & Database Design to join the EA group of our consulting Team.This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering. We are seeking experienced and motivated Dimension Modeller with a strong track record of Dimension Modelling, business analytics and data warehousing to join our team providing deep technical expertise in Data Modelling and Data warehousing, Analytics, Business Intelligence and Database across all industry sectors. Our Data Modellers work closely with external clients, presales, other architects and internal teams to design, build and enable solutions on different domains This role demands a highly technical, extremely hands-on Dimension Modelling who will work closely with our EY Partners and external clients to develop new business as well as drive other initiatives on different business needs. The ideal candidate must have a good understanding of the value of data and analytics and proven experience in delivering solutions to different lines of business and technical leadership. From top to bottom approach, the Cloud data Engineer will engage with a customer to discover business problems and goals, and develop solutions using different cloud services. What Working At EY Offers At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer: Support, coaching and feedback from some of the most engaging colleagues around Opportunities to develop new skills and progress your career The freedom and flexibility to handle your role in a way that’s right for you 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.

No Results Found

Similar jobs not available at this moment.

Search Jobs