Senior FP&A Business Intelligence Analyst

The Shield Companies; Gilbert (AZ); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Weekly pay

Paid time off (sick & vacation)

Company-paid holidays

Comprehensive benefits

401(k) with match

Employee Assistance Program (EAP)

Discounted pest control services

Job summary

EcoShield Pest Solutions seeks a Senior FP&A Business Intelligence Analyst to bridge Finance, Operations, and IT by building data, reports, and analytics that drive strategic decisions.

You will develop semantic models and dashboards in Power BI and Fabric, design forecasting models with SQL and Python, and lead data governance and automation initiatives across the organization.

Qualifications

• 5+ years in BI, analytics, or data management.
• Advanced SQL, data transformation, troubleshooting, modeling.
• Experience with Power BI semantic models, DAX, dashboards and reporting.

Responsibilities

• Build and maintain enterprise datasets, semantic models, dashboards and reporting.
• Develop Power BI and Microsoft Fabric solutions for analytics.
• Design forecasting and decision-support models using SQL, Python, and related tech.
• Partner with business/IT to translate requirements into data solutions.
• Ensure data quality through validation, reconciliation, and monitoring.

Skills

Analytical thinking

Cross-functional collaboration

Communication

Education

Bachelor's degree or equivalent

Tools

SQL

Python

Power BI

Microsoft Fabric

DAX

Power Query

Job description

275 E Rivulon Blvd Ste 106 Gilbert, Arizona 85927Senior FP&A Business Intelligence AnalystPosition SummaryThe 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.ResponsibilitiesBuild 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 Requirements5+ 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 RequirementsThe 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 workstationFrequent use of hands and fingers for typing and using a computer mouseOccasionally lift and carry office materials or supplies up to 25 poundsRequires clear vision for reading documents, computer screens, and other office materialsWork 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.EcoShield is an equal opportunity employer, committed to diversity and inclusion. We make employment decisions based on merit and business needs, without discrimination based on race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.Americans with Disabilities Act (ADA): The Shield Co. Management, LLC is committed to providing reasonable accommodations to qualified individuals with disabilities during both the hiring process and throughout employment, in accordance with applicable laws.