Power BI Developer in Mississauga

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms.

We are seeking a skilled BI Developer with a strong background in data warehousing, advanced SQL, and analytics to join our dynamic team. The ideal candidate will have hands-on experience with Snowflake integration, Python programming, and Power BI. Familiarity with API development, especially using PowerShell and REST APIs, is a plus. Experience with Cube Development will be highly regarded.

The challenge for a Power BI Developer is to design and implement scalable, high-quality data warehousing and analytics solutions that seamlessly integrate Snowflake, Python, and APIs, while delivering insightful, user-friendly reports and dashboards. They must optimize data models and cubes for performance, ensure data accuracy and accessibility, and collaborate effectively with stakeholders to meet evolving business intelligence needs.

Key Responsibilities

• Design, develop, and maintain data warehousing solutions.
• Implement ETL processes to ensure data quality and integrity.
• Optimize data models and storage solutions for performance and scalability.
• Write complex SQL queries for data extraction, transformation, and loading.
• Utilize advanced SQL techniques for analytical queries, ensuring efficient data retrieval and reporting.
• Implement and manage Snowflake data solutions.
• Collaborate with cross-functional teams to integrate Snowflake with existing systems.
• Develop scripts to automate data processing and analysis using Python.
• Create and maintain Power BI dashboards and reports.
• Collaborate with stakeholders to gather requirements and provide insights through data visualization.
• Assist in the development and integration of APIs using PowerShell and RESTful services.
• Ensure data accessibility and interoperability between systems.
• Design and develop OLAP cubes to support business intelligence needs.
• Optimize cube performance and ensure accurate data representation.

Experience

• 10 years of experience in BI development, data warehousing, and analytical queries.
• Proficient in advanced SQL and experience with Snowflake.
• Hands-on experience with Python for data processing.
• Intermediate knowledge of Power BI for reporting and visualization.
• Familiarity with API development (PowerShell, REST APIs) is desirable.
• Experience with Cube Development is a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and as part of a team.

Preferred Qualifications

• Certifications in relevant technologies (e.g., Snowflake, Power BI).
• Experience with cloud-based data solutions.
• Detail-oriented, ability to turn deliverables around quickly with a high degree of accuracy.
• Strong analytical skills, ability to interpret business requirements and produce functional and technical design documents.
• Good time-management skills – Ability to prioritize and multi-task, handling multiple efforts at once.
• Strong desire to understand and learn domain.
• Experience in a financial services/banking industry.
• Ability to work in a fast-paced environment; to be flexible and learn quickly.
• Ability to multi-task with attention to detail/ prioritize tasks.

We can offer you

• A highly competitive compensation and benefits package.
• A multinational organization with 58 offices in 21 countries and the possibility to work abroad.
• Laptop and a mobile phone.
• 15 days of paid annual leave (plus national holidays).
• Maternity & Paternity leave plans.
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability.
• RRSP with employer’s contribution.
• A higher education certification policy.
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
• Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
• A flat and approachable organization.
• A truly diverse, fun-loving, and global work culture.

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all.