Senior Power BI Developer with DAX and Data Modelling experience to support the Global Wealth and Asset Management Team with a major insurance client- 1445

Senior Power BI Developer with DAX and Data Modelling experience to support the Global Wealth and Asset Management Team with a major insurance client- 14454

Location Address: Hybrid/Toronto - 3 days onsite, 2 days remote

Contract Duration: 6 Months (Possibility of extension & conversion)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Candidate Value Proposition

• The successful candidate will have the opportunity to have visibility at the highest leadership levels, providing key reporting to Executive Leadership
• Great opportunity for networking and exposure across all levels of the company and work with cutting edge latest technology

Responsibilities:

• We are seeking a versatile professional to join our high performing team in Global Wealth and Asset Management’s Data Office. This is a hybrid role offering opportunities to work with the latest technologies and provides growth and exciting challenges across a wide array of business areas. We require a candidate with expertise in Power BI, Python, SQL, Spark.
• The responsibilities are divided equally between data engineering and Power BI development:
• 50% Data Engineering: Utilize your skills in Python, SQL, and Spark to support various data engineering projects, ensuring robust data pipelines and efficient data processing.
• 50% Power BI Development: Leverage your Power BI expertise to create insightful, interactive and visually appealing dashboards, providing valuable business intelligence solutions.

Must Have Skills:

• 5+ years proficiency in Power BI: Advanced knowledge of Power BI for creating dashboards, reports, and visualizations.
• 2+ years’ experience in Data Modeling: Expertise in data modeling, including the creation and optimization of data models to enhance performance and usability.
• DAX (Data Analysis Expressions): Strong command of DAX for building complex calculations and aggregations.
• Power Query/M: 5+ years’ experience with Power Query for data transformation and cleaning.
• SQL: Ability to write complex SQL queries for data retrieval and manipulation from various databases, minimum 5 years’ experience.
• ETL Processes: Understanding of ETL (Extract, Transform, Load) processes and tools to integrate data from different sources.
• Programing language: Proficiency in some programing language like python (Understanding of data types, variables, loops, conditionals, and error handling. Familiarity with Python's standard library and commonly used modules.)
• Data Warehousing: Familiarity with data warehousing concepts and practices.
• Project Management: Experience leading BI projects, including planning, execution, and delivery and managing/maintaining the project backlog with stakeholders.

Nice to Have Skills:

• Microsoft Certified: Data Analyst Associate or relevant Power BI certifications to demonstrate proficiency and expertise.
• Power Automate

Education:

• Bachelor's degree required. Preference for degree in a technical field such as computer science, computer engineering or related field.

Candidate Review & Selection

• Step Process: In person interview is a requirement