Sr. Power BI Developer

Job summary

Design, develop, and maintain data warehousing and Snowflake solutions, including ETL processes, optimized data models, and complex SQL queries. Build Power BI dashboards and OLAP cubes, automate data processing with Python, and support system integration through APIs while collaborating with stakeholders and cross-functional teams.

Job details

Role Title: Sr. Power BI Developer Location: Mississauga, Hybrid 3 days onsite Contract Role: Sr. Power BI Developer 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. Work on data manipulation and transformation tasks to support analytical projects. 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. Must have experience on DAX Proficient in advanced SQL and experience with Snowflake. Handson 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.

What you’ll do

Design, develop, and maintain data warehousing and Snowflake solutions, including ETL processes, optimized data models, and complex SQL queries. Build Power BI dashboards and OLAP cubes, automate data processing with Python, and support system integration through APIs while collaborating with stakeholders and cross-functional teams.

Requirements

Requires 10 years of experience in BI development, data warehousing, and analytical queries, along with DAX, advanced SQL, Snowflake, Python, and intermediate Power BI skills. API development familiarity is desirable, cube development is a plus, and relevant certifications or cloud data experience are preferred.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• REST APIs · Preferred
• Problem solving · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Power BI
• DAX
• Advanced SQL
• Snowflake
• Python
• Data Warehousing
• ETL
• Data Modeling
• Data Visualization
• OLAP Cube Development
• PowerShell
• REST APIs
• Analytical Queries
• Data Processing
• Problem-Solving

Job areas

• Data & Analytics
• Technology
• Software

More jobs from Epsilon Solutions Ltd.