Job Description

Line of Service AdvisoryIndustry/Sector Not ApplicableSpecialism Data, Analytics & AIManagement Level Manager & Summary A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.Creating business intelligence from data requires an understanding of the business, the data, and the technology used to store and analyse that data. Using our Rapid Business Intelligence Solutions, data visualisation and integrated reporting dashboards, we can deliver agile, highly interactive reporting and analytics that help our clients to more effectively run their business and understand what business questions can be answered and how to unlock the answers.1. Understanding of data warehousing conceptsa. Concept of data warehousing, difference with traditional databases, difference with data lakeb. Data Model concepts, facts and dimension, measures and references, normalization and denormalizationc. Knowledge of data warehouse fundamentals, indexes, views and materialized viewsd. Incremental data loading concepts, change data capture, row level and column level security fundamentals.e. SQL concepts, fundamental and moderate \xe2\x80\x93 Different types of joins and aggregations, analytical functions, data time and typecasting functions, grouping logica. Proficient in data analysis using different visualization tools such as Power BI/Tableau/Qlikb. Usages of buttons, bookmarks, custom tablesc. Depth knowledge on data modeling approachd. Knowledge of Power BI copilot and NLQ function or any other equivalent in other BI toolse. Knowledge of Row level security4. Large scale engagement experiencea. Agile program managementb. Owning delivery of end to program with complex BI needsc. Strong stakeholder managementd. Ability to groom team for parallel engagementsExperience (Must have)1. 14-17 years of IT experience in DWH and BI projects2. Must have 6 + years of experience of Power BI or Tableau implementation.3. Must have SQL knowledge.4. Must have data modeling knowledge.5. Strong client management experience6. Basic knowledge and experience with Machine Learning and associated projectsExperience (good to have):1. Knowledge of different tools in fabric2. Experience of azure synapse, GBQ, SQL server3. Designing, developing, and researching Machine Learning systems, models, and schemes through data science and data analytics prototypes4. Understanding of Natural Language Processing(NLP), Natural Language Understanding(NLU) and Natural Language Generation(NLG)5. Data Quality and MDM concepts, data qualityMandatory skills-DWH and BI projects
Preferred skills-DWH and BI projects
Years of experience-13-17
Qualification-Btech/MCA/MBAEducation (if blank, degree and/or field of study not specified) Degrees/Field of Study required:Degrees/Field of Study preferred:Certifications (if blank, certifications not specified)Required SkillsOptional SkillsDesired Languages (If blank, desired languages not specified)Travel RequirementsAvailable for Work Visa Sponsorship?Government Clearance Required?Job Posting End Date

PwC