Senior Business Intelligence Developer
- Mississauga, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 8-10 years of experience in BI development, data warehousing, and analytical queries.
- Posting language
- English
- Posted
Original job description
Role: Power BI Developer
Location- Mississauga, ON - 3 days onsite/week
Job Summary:
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 handson 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.
Our Challenge
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.
- 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:
- 8-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.
More about this job
Responsibilities
Design, develop, and optimize data warehousing, ETL processes, Snowflake solutions, SQL queries, and OLAP cubes to support accurate, scalable analytics. Build and maintain Power BI reports and dashboards, automate data processing with Python, and support system integration through APIs while collaborating with stakeholders.
Requirements
Requires 8–10 years of experience in BI development, data warehousing, and analytical queries, including DAX, advanced SQL, Snowflake, Python, and intermediate Power BI skills. API development and cube development experience are desirable, along with strong analytical, communication, and collaboration abilities.
Skills
- Data Warehousing
- Advanced SQL
- Snowflake
- Python
- Power BI
- DAX
- ETL
- Data Modeling
- Data Visualization
- API Development
- PowerShell
- REST APIs
- OLAP Cube Development
- Analytical Problem-Solving
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
Keywords
- Business Intelligence
- Data Warehousing
- Advanced SQL
- Snowflake
- Python
- Power BI
- DAX
- ETL
- Data Quality
- Data Integrity
- Data Modeling
- Data Transformation
- Data Visualization
- Analytics
- API Development
- PowerShell
- REST APIs
- OLAP Cubes
- Cube Development
- Cloud-Based Data Solutions
- Data Processing
- Data Integration
- Performance Optimization
- Reporting
- Snowflake Certification
- Power BI Certification