Senior Business Intelligence Analyst

Parexel International; Remote; CAD 70,000 - 90,000; Full time

Job summary

A leading global biopharmaceutical services organization seeks an experienced Data Analyst to design and maintain Power BI reports. The successful candidate will analyze complex business requirements, write SQL queries, and collaborate in Agile development environments. A Bachelor's degree in computer science or a related field is required, along with at least 5 years of experience in Power BI. Strong analytical skills and problem-solving abilities are essential.

Qualifications

• 5+ years of experience with the entire Power BI stack required.
• Proficiency in Power Query, DAX, and data modeling is essential.
• Must have excellent analytical, problem-solving, and interpersonal skills.

Responsibilities

• Design, develop, and maintain Power BI reports for enterprise users.
• Analyze complex business requirements and recommend solutions.
• Write and optimize SQL queries for reporting purposes.

Skills

Power BI

SQL

Data visualization best practices

Analytical skills

Problem-solving

Agile methodologies

Interpersonal skills

Education

Bachelor’s degree in computer science or related field

Tools

Power BI Service

SQL Server

Azure SQL

Databricks

Job description

Key Accountabilities

• Responsible for the design, development, and maintenance of Power BI reports and dashboards for enterprise-wide users.
• Work closely with business users, business analysts, data engineers, stakeholders to gather requirements and translate them into technical solutions.
• Analyze complex business and operational system requirements and recommend solution options. Integrate data from various sources into Power BI using SQL queries, SharePoint, and Dataflows to provide comprehensive insights.
• Write and optimize SQL queries to extract and manipulate data for reporting purposes.
• Participate in meetings and discussions to understand business needs and provide technical insights.
• Stay updated with the latest developments and best practices in Power BI, SQL, and Power Platform.
• Propose and implement improvements to existing reports, dashboards, and processes.
• Experience working in Agile development software methodology, authoring technical documents / specifications. Responsible to support the production environment to assist the business users for any issues related to data and reporting.

Skills

• A minimum of 5 years’ experience with the entire Power BI stack is required.
• Proficiency in Power BI, including Power Query, DAX, and Power BI Service.
• Strong understanding of data modeling, data warehousing, and ETL/ELT processes.
• Experience working with data sources like SQL Server, Oracle, Azure SQL, Azure Synapse, Databricks, Blob Storages & Data Lakes.
• Strong understanding of data visualization best practices.
• Excellent analytical and problem-solving skills.
• Familiarity with Agile development methodologies. Knowledge of standard ITL process.
• Excellent interpersonal, verbal and written communication skills.
• A flexible attitude with respect to work assignments and new learning.
• Ability to manage multiple and varied tasks with enthusiasm and prioritize workload with attention to detail.
• Willingness to work in a matrix environment.

Education

• Bachelor’s degree in computer science, data science, software development, or another related field or equivalent work experience.