Sr. Power BI Developer

$61,000 - $150,200/Yr

CGI - Fort Lauderdale, FL

Full-time - Mid Level

Fort Lauderdale, FL

1,001-5,000 employees

Professional, Scientific, and Technical Services

About the position

The Senior Power BI Developer role at CGI Group, Inc. is designed for a highly skilled professional who will enhance technical systems and perform comprehensive requirement analysis for enterprise-level clients. This position involves designing SQL data warehouse solutions, creating reports and dashboards, and optimizing ETL processes using various tools including Power BI, SSIS, and Tableau. The role supports a hybrid work model, requiring on-site presence three days a week in Fort Lauderdale, FL, while allowing remote work for the remaining days.

Responsibilities

• Perform requirement analysis and review related to database enhancements for enterprise-level clients.
• Design and develop SQL data warehouse solutions for effective reporting and analysis using SQL Server Analysis Services (SSAS) and Tableau.
• Develop reports/dashboards using SQL Server Reporting Services (SSRS), Tableau, and MS Power BI.
• Design, develop, optimize, and troubleshoot SQL Server Integration Services (SSIS) packages to implement complex ETL processes.
• Design and develop API and data integration solutions using systems like Salesforce, SAP, and other source applications using App Connect and SSIS.
• Develop and create database objects such as schemas, tables, views, stored procedures, triggers, and functions.
• Design SQL extracts to support SSIS packages to automate the data extraction and harmonization process.
• Create and maintain source-to-target mappings and implementation documents to support the ETL development process.
• Provide proofs of concept and technical guidance to the development team.
• Interact with different project teams to finalize the release scope for project delivery.
• Analyze and fix defects/issues reported in the production environment during deployment and hyper care support.
• Develop technical enhancements, system documentation, and implement procedures for quality improvement.

Requirements

• Bachelor's degree in computer science, Engineering, or related field of study.
• 5 years of experience designing and developing technical reporting solutions using various Business Intelligence tools and technologies including Microsoft BI stack.
• 5 years of hands-on experience across all stages of the BI life cycle including system analysis, design, development, testing, deployment, post-production support, maintenance, documentation, and end-user training.
• Proficiency in creating different reports using SQL Server Reporting Services (SSRS).
• Experience creating complex ETL packages using SSIS.
• Experience developing SQL stored procedures.
• Experience creating complex BI reports and dashboards using MS Power BI, Tableau, and SAP HANA preferred.
• Strong statistical analysis and forecasting skills with the ability to use data to solve complex business problems.
• Excellent verbal and written communication skills.

Nice-to-haves

• Experience with Salesforce and SAP integration.
• Familiarity with App Connect for data integration.

Benefits

• Dental insurance
• Health insurance
• Pet insurance
• Vision insurance
• 401(k) Plan and Profit Participation
• Generous holidays, vacation, and sick leave plans
• Comprehensive insurance plans including life and disability coverage
• Back-up childcare
• Member Assistance Program
• 529 college savings program
• Personal financial management tool
• Lifestyle management programs