Senior FP&A Business Intelligence Analyst

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

**Senior FP&A Business Intelligence Analyst****Position Summary**The Senior FP&A Business Intelligence Analyst serves as a critical bridge between Finance, Operations, and IT by designing, developing, and maintaining data, reporting, analytics, and automation solutions that support business decision-making across the organization.**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.**Qualifications and Requirements*** 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.**Why Work for EcoShield Pest Solutions?**The Shield Co. Management / EcoShield Pest Solutions is one of the fastest-growing pest control companies in the country! Our mission is to create the world’s happiest family, and our purpose is to spread happiness. We do this by delivering exceptional experiences to our customers, employees, partners, and communities—treating everyone like family.EcoShield Pest Solutions is proud to offer competitive pay and full benefits!* Weekly Pay – get paid every Friday!* Paid sick and vacation time along with 10 company-paid holidays.* Comprehensive benefits package including medical, dental, and vision options.* 401(k) with a competitive match.* Access to the Employee Assistance Program (EAP).* Discounted pest control services for employees and their friends and family.**Physical Demands and Working Requirements**The physical demands and working conditions outlined here are typical requirements for an employee to effectively carry out the essential duties of this job. Reasonable accommodations may be provided to assist individuals with disabilities in performing these essential functions.* Requires prolonged periods of sitting at a desk or workstation* Frequent use of hands and fingers for typing and using a computer mouse* Occasionally lift and carry office materials or supplies up to 25 pounds* Requires clear vision for reading documents, computer screens, and other office materials* Work is inside a climate-controlled office with quiet to moderate noise levelThe above statements are meant to outline the general nature and scope of work performed by employees in this role. They should not be interpreted as an exhaustive list of all responsibilities, duties, and skills required for this position.