BI Analyst / BI Engineer

Job Title: BI Analyst / BI Engineer

Location: Phoenix, AZ (Onsite)
Employment Type: Contract
Experience Required: 8+ Years

Position Overview

We are seeking a highly analytical BI Analyst / BI Engineer with advanced SQL expertise and strong experience in regulatory reporting environments. This role will support FLARE regulatory reporting, analytics, and Data Quality (DQ) monitoring initiatives , ensuring accurate, timely, and optimized reporting solutions.

The ideal candidate will have deep experience in SQL optimization, MicroStrategy dashboard development, BigQuery, PostgreSQL , and automation of reporting processes.

Key Responsibilities

Regulatory Reporting & Analytics

• Support FLARE regulatory reporting and analytics initiatives .

• Ensure timely and accurate submission of regulatory reports.

• Drive insights through advanced analytics and reporting enhancements.

SQL Development & Optimization

• Design, develop, and optimize complex SQL queries.

• Utilize advanced SQL techniques including:

  • CTEs (Common Table Expressions)

  • Window functions

  • Query performance tuning

• Optimize queries for large-scale data environments (BigQuery/PostgreSQL).

BI & Dashboard Development

• Develop, enhance, and maintain MicroStrategy dashboards and reports .

• Translate business requirements into scalable BI solutions.

• Improve reporting frameworks to enhance usability and performance.

Data Quality & Governance

• Monitor and manage Data Quality (DQ) controls and validation processes .

• Identify and resolve data discrepancies in collaboration with upstream teams.

• Implement automation to improve reporting accuracy and reduce operational risk.

Automation & Process Improvement

• Automate manual reporting processes to improve efficiency.

• Continuously enhance data workflows and reporting pipelines.

• Align reporting improvements with Agile delivery practices.

Collaboration & Communication

• Partner with business stakeholders, data engineers, and product teams.

• Communicate analytical findings in a clear and actionable manner.

• Participate actively in Agile ceremonies and cross-functional initiatives.

Required Skills & Qualifications

• Advanced proficiency in SQL , including:

  • CTEs and window functions

  • Query optimization and performance tuning

• Hands-on experience with MicroStrategy dashboard development .

• Strong working knowledge of BigQuery and PostgreSQL .

• Experience in regulatory reporting environments .

• Strong expertise in Data Quality monitoring and validation .

• Experience automating manual reporting processes.

• Strong analytical and problem-solving skills.

• Experience working in Agile environments.

• Excellent stakeholder communication skills.

Technical Skills

SQL | CTEs | Window Functions | Query Optimization | MicroStrategy | BigQuery | PostgreSQL | Regulatory Reporting | Data Quality (DQ) | Agile