Job Description

Line of Service AdvisoryIndustry/Sector Not ApplicableSpecialism Data, Analytics & AIManagement Level Senior 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 concepts
a. Concept of data warehousing, difference with traditional databases, difference with
data lake
b. Data Model concepts, facts and dimension, measures and references, normalization
and denormalization
c. Knowledge of data warehouse fundamentals, indexes, views and materialized views
d. Incremental data loading concepts, change data capture, row level and column level
security fundamentals.
e. SQL concepts, fundamental and moderate - Different types of joins and
aggregations, analytical functions, data time and typecasting functions, grouping logic
a. Proficient in data analysis using different visualization tools such as Power
BI/Tableau/Qlik
b. Usages of buttons, bookmarks, custom tables
c. Depth knowledge on data modeling approach
d. Knowledge of Power BI copilot and NLQ function or any other equivalent in other BI
tools
e. Knowledge of Row level security
4. Large scale engagement experience
a. Agile program management
b. Owning delivery of end to program with complex BI needs
c. Strong stakeholder management
d. Ability to groom team for parallel engagements
Experience (Must have)
1. 12+ years of IT experience in DWH and BI projects
2. 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 experience
6. Basic knowledge and experience with Machine Learning and associated projects
Experience (good to have):
1. Knowledge of different tools in fabric
2. Experience of azure synapse, GBQ, SQL server
3. Designing, developing, and researching Machine Learning systems, models, and
schemes through data science and data analytics prototypes
4. Understanding of Natural Language Processing(NLP), Natural Language
Understanding(NLU) and Natural Language Generation(NLG)
5. Data Quality and MDM concepts, data qualityMandatory Skill Set-DWH and BI projects
Preferred Skill Set-DWH and BI projects
Year of experience required-14+
Qualifications-Btech/MCA/MBA/MtechEducation (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 Skills Business Intelligence (BI), Data Warehousing (DW)Optional SkillsDesired Languages (If blank, desired languages not specified)Travel RequirementsAvailable for Work Visa Sponsorship?Government Clearance Required?Job Posting End Date

PwC