Senior Power Bi Developer

Monark Group; White Rock; On-site; CAD 80,000 - 100,000; Full time

Job summary

A data solutions company in White Rock, BC is seeking a Senior BI Developer to enhance their data analytics team. The role requires extensive experience in Power BI and Streamlit for creating BI dashboards and reports. Candidates should possess strong SQL and Python skills, and familiarity with Snowflake data warehouse. This is an on-site opportunity with potential for hybrid work arrangements.

Qualifications

• 3+ years of hands-on experience with Power BI Desktop, Service, and Premium features.
• 2+ years developing interactive Python-based web applications with Streamlit.
• Advanced proficiency in SQL for complex data manipulation and analysis.

Responsibilities

• Design and develop interactive Power BI dashboards and reports.
• Build dynamic Streamlit applications for advanced analytics.
• Partner with business stakeholders to understand reporting requirements.

Skills

Power BI

Streamlit

SQL

Python

DAX

Data Visualization

Problem-Solving

Communication

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field

Tools

Snowflake

Git

Job description

Job Summary

We are seeking an experienced Senior BI Developer to join our data analytics team. The ideal candidate will be proficient in Power BI and Streamlit development, with solid knowledge of Snowflake for creating comprehensive BI dashboards and tabular reporting solutions. You will be responsible for transforming complex data into actionable insights through interactive visualizations and reports.

Key Responsibilities

Dashboard & Report Development

• Design and develop interactive Power BI dashboards and reports to meet business requirements
• Build dynamic Streamlit applications for advanced analytics and data visualization
• Create tabular reports and KPI scorecards for executive and operational reporting
• Implement responsive designs that work across desktop, tablet, and mobile devices

Data Integration & Modeling

• Connect to and query Snowflake data warehouse to extract relevant datasets
• Design and optimize data models for efficient report performance
• Create and maintain DAX calculations, measures, and calculated columns in Power BI
• Implement data refresh schedules and monitor data quality

Collaboration & Requirements Gathering

• Partner with business stakeholders to understand reporting requirements and KPIs
• Translate business needs into technical specifications and visual designs
• Conduct user training sessions and create documentation for end-users
• Provide ongoing support and maintenance for existing BI solutions

Performance & Optimization

• Optimize query performance and dashboard load times
• Implement best practices for data modeling and visualization design
• Monitor and troubleshoot BI solutions to ensure optimal performance
• Maintain version control and deployment processes for BI assets

Required Skills & Experience

Technical Skills

• Power BI: 3+ years of hands-on experience with Power BI Desktop, Service, and Premium features
• Streamlit: 2+ years developing interactive Python-based web applications with Streamlit
• Snowflake: Working knowledge of Snowflake data warehouse, including:
  • Writing efficient SQL queries for data extraction
  • Understanding of Snowflake architecture and performance optimization
  • Experience with Snowflake connectors and data loading processes
• SQL: Advanced proficiency in SQL for complex data manipulation and analysis
• Python: Strong Python skills for Streamlit development and data processing
• DAX: Proficiency in writing complex DAX formulas and measures

Additional Technical Knowledge

• Experience with data visualization best practices and UI/UX principles
• Familiarity with version control systems (Git)
• Understanding of data warehousing concepts and dimensional modeling
• Experience with agile development methodologies

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication skills for presenting to technical and non-technical audiences
• Ability to manage multiple projects and prioritize competing demands
• Detail-oriented with strong quality assurance practices
• Collaborative mindset for working in cross-functional teams

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field
• Microsoft Power BI certification (DA-100 or equivalent)
• Experience with other BI tools (Tableau, Looker, etc.)
• Knowledge of cloud platforms (AWS)