Job Description

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose - the relentless pursuit of a world that works better for people - we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.Inviting applications for the role of Principal Consultant, Power BI/Snowflake
In this role, you will be responsible for coding, testing, and delivering high quality deliverables, and should be willing to learn new technologies.Responsibilities

• Understand fundamentals of data preparation/data modelling necessary for visualization purposes.
• Gather reporting requirements from various stakeholders, architect the solution/report, Understand/analyze the source data and deliver the reports in timely manner
• Strong expertise in Designing intuitive and interactive reports and dashboards using Power BI for data driven decisions.
• Performance Monitoring, fine-tuning and optimization of dashboards
• Knowledge on connecting to multiple data sources through Power BI is required.
• Experience in publishing and sharing the dashboards, scheduling data refreshes.
• Should have handled complexity around visualization or data.
• Should have strong SQL skills, preferably over SQL Server. Strong Data Warehousing and Business Intelligence concepts.
• Experience on any ETL tool preferably SSIS is a plus.
• Interpret written business requirements and technical specification documents
• Strong understanding of Power BI user and group security configuration

Qualifications we seek in you!
Minimum Qualifications

• BE/B Tech/MCA
• Excellent written and verbal communication skills

Preferred Qualifications/ Skills

• Good conceptual knowledge and experience in other BI tools is an added advantage.
• Experienced Power BI developer including experience in Azure environment.
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and understand how to use these features.
• Creating, monitoring and optimization of ETL/ELT processes (Talend, Informatica) migrating solutions from on-premises to public cloud platforms.
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot.
• Hands-on experience with Scripting language like Python/Perl
• Experience in migrating SSRS reports/Tabular reports to Power BI Paginated Reports.
• Good understanding of Power Query M and hands-on experience in building sophisticated DAX queries
• Experience in implementing static and dynamic Row Level Security, extensive experience with Dataset design, Data Cleansing and Data Aggregation
• Understanding of relational database structures, theories, principles, and practices
• Solid SQL reporting skills with the ability to create SQL views and write SQL queries to build custom datasets for reporting or analysis
• Able to nurture robust working relationships with the team, peers and clients, scheduling flexibility required.
• Overall candidate should have problem solving, macro-level research and analytics approach and good in numbers.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com . Follow us on Twitter, Facebook, LinkedIn, and YouTube.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,\' paying to apply, or purchasing equipment or training.

Genpact