Senior FP&A & BI Analytics Lead

EcoShield Pest; Gilbert, Northern (AZ, KY); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Weekly Pay

Paid time off

Medical, dental, vision benefits

401(k) match

Employee Assistance Program

Discounted pest control

Job summary

EcoShield Pest Solutions in Gilbert, AZ seeks a Senior FP&A Business Intelligence Analyst to bridge Finance, Operations, and IT by designing and maintaining data, reporting, and analytics that drive business decisions.

You will develop Power BI and Fabric solutions, build forecasting models, ensure data quality, automate reporting, and collaborate across teams; 5+ years of BI experience required.

Qualifications

• 5+ years of experience in BI, analytics, reporting, or data management.
• Advanced SQL skills including data transformation, troubleshooting, optimization, and analytical model development.
• Experience developing analytical, forecasting, or decision-support models using SQL, Python, or similar technologies.
• Strong experience with Power BI, including semantic models, DAX, dashboards, and reporting solutions.
• Experience with Microsoft Fabric and cloud-based analytics platforms.
• Knowledge of data modeling, governance, validation, and reporting best practices.

Responsibilities

• Build and maintain enterprise datasets, semantic models, dashboards, and reporting solutions.
• Develop Power BI and Microsoft Fabric solutions, including semantic models, reporting, and self-service analytics capabilities.
• Design and maintain analytical, forecasting, and decision-support models using SQL, Python, and other technologies.
• Partner with business and technology teams to translate requirements into actionable data and reporting solutions.
• Ensure data quality through validation, reconciliation, and monitoring processes.
• Automate reporting, analysis, and recurring business processes using AI and modern productivity tools.

Skills

SQL

Power BI

Python

Data modeling

Data governance

DAX

Education

Bachelor’s degree or equivalent

Tools

Microsoft Fabric

Power Query

Microsoft Copilot

SAP

Job description

EcoShield Pest Solutions in Gilbert, AZ seeks a Senior FP&A Business Intelligence Analyst to bridge Finance, Operations, and IT by designing and maintaining data, reporting, and analytics that drive business decisions.

You will develop Power BI and Fabric solutions, build forecasting models, ensure data quality, automate reporting, and collaborate across teams; 5+ years of BI experience required.