Job Specifications
Role: Power BI Developer
Location – Mississauga, ON
In-person interview required.
Job Description:
We are seeking an experienced Power BI Developer with a strong background in SQL, data warehousing, and enterprise analytics. The ideal candidate will excel in designing, developing, and optimizing complex dashboards and reports, while collaborating closely with business stakeholders to deliver actionable insights. The role also requires additional expertise in scripting, REST API, and familiarity with DevOps practices to support automation, deployment, and troubleshooting.
Key Responsibilities:
Design, develop, and maintain interactive reports, dashboards, and ad-hoc queries using Power BI.
Collaborate with business users and analysts to gather requirements and translate them into data solutions.
Utilize Power Query, Power Pivot, and data modeling techniques to create efficient data models.
Develop and optimize DAX queries for performance and analytical depth.
Create and manage Paginated Reports using Power BI Report Builder or similar tools.
Manage and query SQL Server or other relational databases to extract and analyze data.
Support script-based jobs and automation workflows through scripting and REST API integrations.
Assist in deploying solutions using Azure DevOps, GIT, and related CI/CD practices, with a conceptual understanding of deployment pipelines.
Troubleshoot data-related issues and provide quick resolutions to ensure system reliability.
Participate in the full project life cycle, from requirement gathering to deployment and maintenance.
Must-Have Skills:
Extensive experience in data modeling using Power Query and Power Pivot.
Proficiency in DAX for creating complex measures and calculated columns.
Strong SQL skills, especially with SQL Server or similar relational databases, including query optimization.
Proven experience in developing reports and dashboards for enterprise-level systems.
Solid understanding of Fixed Income, Equity, and Derivatives businesses.
Ability to analyze user requirements, recommend solutions, and implement them effectively.
Experience supporting REST API integrations and scripting for automation purposes.
Basic understanding of DevOps principles, version control (GIT, Azure Repos), and deployment pipelines.
Excellent communication, presentation, and interpersonal skills.
Self-driven with strong troubleshooting skills and the ability to work under pressure.
Nice-to-Have Skills:
Working knowledge of Data Flows within Power BI.
Experience with Power BI Report Server (PBRS).
Familiarity with Power BI Service (Power On) and cloud-based analytics solutions.
Experience with Snowflake data warehouse or other cloud data platforms.
Qualifications:
Minimum of 8+ years of experience in data warehousing, business intelligence, analytics, and reporting.
At least 3+ years of experience with relational and multi-dimensional (OLAP) data modeling.
Proficient in SQL, including query optimization and database design.
Strong understanding of financial products, including Fixed Income, Equity, and Derivatives.
Ability to prioritize tasks and manage multiple projects in a high-pressure environment.
About the Company
Conflux Systems, Inc. is a business consulting firm specializing in software development and business intelligence. We are transforming how companies and agencies use data, analytics, and technology to gain a competitive advantage by delivering customized enterprise solutions.
Staffing Services
We are the leading provider of business information and technology solutions, specializing in matching clients with top talent in the most in-demand technologies of the present day. We provide staffing solutions for leading organiz...
Know more