BI Analyst
Role details
Job location
Tech stack
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.