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