BI Analyst

Intersources Inc.
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Tech stack

Google BigQuery
PostgreSQL
MicroStrategy
Performance Tuning
Query Optimization
SQL Databases

Job description

  • Developing, enhancing and maintaining MicroStrategy dashboards and reports.

  • Designing and optimizing advanced SQL queries (including CTEs and window functions) for reporting and analytics.

  • Monitoring and managing data-quality controls, validations and issue resolution.

  • Automating manual reporting processes to improve efficiency and reduce operational risk.

  • Collaborating with business stakeholders, data engineers and product teams in an Agile environment.

  • Driving analytics initiatives that provide actionable insights and continuously improving reporting frameworks and data processes.

Requirements

  • Advanced SQL expertise with complex query optimization and performance tuning.

  • Hands-on MicroStrategy dashboard development.

  • Strong working knowledge of BigQuery and PostgreSQL.

  • Experience in regulatory reporting environments.

  • Data-quality monitoring and validation expertise.

  • Experience automating reporting processes.

  • Strong analytical, problem-solving, collaboration and communication skills.

Apply for this position