Senior FP&A & BI Analyst: Power BI & Forecasting

EcoShield Pest Solutions; Gilbert (AZ); On-site; USD 90,000 - 150,000; Full time

Benefits offered by this job

Weekly pay

Paid sick and vacation time

10 company-paid holidays

Medical, dental, and vision options

401(k) with match

Employee Assistance Program (EAP)

Discounted pest control services

Job summary

EcoShield Pest Solutions is seeking a Senior FP&A Business Intelligence Analyst to bridge Finance, Operations, and IT by delivering data, reporting, and analytics that drive decisions across the organization.

You will build enterprise datasets, dashboards, and models using SQL, Python, Power BI, and Microsoft Fabric, ensuring data quality and governance while enabling self-service analytics for business users.

Qualifications

• 5+ years of experience in business intelligence, 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 Microsoft Power BI, including semantic models, DAX, dashboards, and reporting solutions.
• Experience with Microsoft Fabric and cloud-based analytics platforms.
• Strong understanding of data modeling, governance, validation, and reporting best practices.
• Ability to independently investigate problems, validate findings, and develop effective solutions with minimal supervision.
• Excellent communication and collaboration skills across business and technical teams.
• Experience using AI and automation tools to improve efficiency while exercising sound business judgment and validating results.
• Experience with SAP or other ERP systems preferred.
• Experience with Python, Microsoft Copilot, Power Query, and workflow automation tools preferred.
• Experience working with relational databases, data modeling, data integration, and enterprise reporting environments preferred.
• Bachelor’s degree or equivalent experience in Business Intelligence, Information Systems, Computer Science, Data Analytics, Statistics, Mathematics, Finance, or a related field.

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 modern 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.
• Manage data models, reporting frameworks, and key business hierarchies.
• Automate reporting, analysis, and recurring business processes using AI and modern productivity tools.
• Continuously improve reporting standards, governance, and analytical methodologies.

Skills

Advanced SQL

Power BI

Python

Data modeling

Data governance

Analytics

Communication

AI & automation

Problem solving

Education

Bachelor's degree

Tools

Microsoft Fabric

Power Query

Microsoft Copilot

ERP systems (SAP)

Workflow automation

Job description

EcoShield Pest Solutions is seeking a Senior FP&A Business Intelligence Analyst to bridge Finance, Operations, and IT by delivering data, reporting, and analytics that drive decisions across the organization.

You will build enterprise datasets, dashboards, and models using SQL, Python, Power BI, and Microsoft Fabric, ensuring data quality and governance while enabling self-service analytics for business users.