Senior PowerBI Developer Lead

Position Description:

Founded in 1976 CGI is among the worlds largest independent IT and business consulting services firms. With 94000 consultants and professionals globally CGI delivers an end-to-end portfolio of capabilities from strategic IT and business consulting to systems integration managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more .

Job Title: Senior PowerBI Developer / Lead
Position: SSE / LA / AC
Work Type: Hybrid
Category: Software Development/ Engineering
Main location: Bangalore Chennai
Position ID: J1125-0634
Employment Type: Full Time / Permanent
Qualification: Bachelors degree in Computer Science or related field with 4 to 6 years of relevant experience in PowerBI / data analytics / BI development.

We are in search of an accomplished Sr. PowerBI Developer to enrich our team. The ideal candidate will demonstrate a passion for creating dynamic and effective datavisualizations and insights.

As a Sr. PowerBI Developer you will collaborate closely with our crossfunctional teams including backend developers designers data engineers and business stakeholders to deliver impactful solutions aligned with our clients requirements. Your role will involve transforming raw data into compelling insights through intuitive and visually appealing reports and dashboards as well as resolving data-related issues and inconsistencies.

Responsibilities:
. Gather and understand business requirements in a BI context and design data models to convert raw data into meaningful insights.
. Create dashboards and interactive visual reports using PowerBI.
. Strong understanding in Power BI Desktop Power BI service Power BI dataflows.
. Identify key performance indicators (KPIs) with clear objectives and continuously monitor these KPIs.
. Analyze data and present it via reports that aid decisionmaking across functions.
. Translate business requirements into technical specifications estimate timelines and deliver accordingly.
. Develop relationships among data building data models like star schema snowflake galaxy schema .
. Document algorithms parameters models relationships and create appropriate charting and visual documentation.
. Design develop test and deploy PowerBI scripts data models and reports.
. Perform advanced DAX queries and functions within PowerBI as required.
. Analyze current ETL processes identify improvements and design enhanced systems for data loading transformation and refresh.
. Design develop and optimize data modelling ETL and analytics pipelines ensuring performance and scalability.
. Apply technical/strategic improvements to existing Business Intelligence systems to keep them current and efficient.
. Work closely with users and team members at all levels to gather feedback improve performance and deliver suggestions for enhancements.

Must-Have Skills:
. Advanced mastery of DAX (Data Analysis Expressions) in Power BI.
. Expertise in Power Query / ETL processes including: Debugging refresh failures & data loading errors. Implementing incremental refresh policies. Optimizing ETL steps to minimize data redundancy and transformation time.
. Strong data modelling expertise (tabular models relationships performance optimization).
. Experience with Power BI Service Governance & Administration including gateways dataset refresh and Row-Level Security (RLS).
. Monitoring performance-troubleshooting and advanced debugging of Power BI reports/datasets to ensure fast and reliable delivery.
. Skilled in designing impactful visualizations choosing appropriate charts formatting and user-friendly dashboards.

Good-to-Have Skills:
. Exposure to Power BI Dataflows and self-service data-preparation frameworks.
. SQL for data preparation and extraction.
. Familiarity with ServiceNow .
. Experience working with Azure services (e.g. Azure Data Factory Azure Synapse Azure Analysis Services).
. Basic proficiency in Python for data manipulation scripting or analytics tasks.

CGI is an equal opportunity addition CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

#LI-GB9

Skills:

• Data Analysis
• PowerBuilder
• SQLite

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.