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