Business Intelligence - Senior Analyst
Job Summary
The Business Intelligence – Senior Analyst designs, develops, and maintains scalable BI solutions that transform raw data into actionable insights for Finance and Operations stakeholders. This role partners with Strategic Finance Advisors, Forecast Operations, and cross-functional teams to deliver accurate, timely, and visually compelling reporting through Power BI, Power Automate, and Python-based analytics. The Senior BI Analyst drives continuous improvement in data quality, process automation, and self-service reporting capabilities across the organization.
Key Tasks & Responsibilities (Essential Functions)
- Designs, builds, and maintains Power BI dashboards and reports, including data models, DAX measures, and automated refresh schedules to support monthly close, forecasting, and operational reporting needs
- Develops and maintains Power Automate workflows to streamline data collection, report distribution, and recurring Finance Operations processes, reducing manual effort and improving cycle time
- Builds and maintains Python scripts and pipelines for data extraction, transformation, and loading (ETL) from ERP, cloud, and other enterprise data sources, ensuring data integrity and consistency
- Pairs with Finance Advisors, FP&A, and Operations teams to gather requirements, identify root causes of data quality issues, and deliver self-service analytics solutions that improve decision-making
- Prepares BI-driven content for Finance presentations, supports ad hoc analytical requests, and documents data definitions, report logic, and process standards
Skills and Minimum Experience Required
- Bachelor's Degree or equivalent experience
- Bachelor's Degree in Computer Science, Information Systems, Finance preferred
- 4+ years experience in BI development, data analytics, or FP&A roles in mid-size or large organizations
- Travel up to 25%
- Experience with Power BI, Power Automate, and Python in a corporate environment preferred
- Advanced proficiency in Power BI, including data modeling, DAX, and Power Query (M language)
- Hands-on experience with Power Automate for workflow automation and process integration
- Proficiency in Python for data manipulation, ETL development, and analytics (pandas, numpy, etc.)
- Strong analytical and problem-solving skills with the ability to translate business requirements into technical solutions
- Ability to manage data accuracy, completeness, and governance across multiple data sources and platforms
- Effective written and verbal communication skills; ability to present complex data insights to non-technical stakeholders
- Familiarity with ERP platforms, SQL, and cloud data environments (e.g., Azure, Snowflake, or similar)
Pay
The range for this position is $83,000 to $164,000. Placement within this range may vary, depending on the applicant’s experience and geographic location.
Benefits
Acuity offers generous benefits including health care, dental coverage, vision plans, 401K benefits, and commissions/incentive compensation depending on the role. For a list of our benefits, click here.
About the Role
We value diversity and are an equal opportunity employer. All qualified applicants will be considered for employment without regards to race, color, age, gender, sexual orientation, gender identity and expression, ethnicity or national origin, disability, pregnancy, religion, covered veteran status, protected genetic information, or any other characteristic protected by law.
Contact Information
Accommodation for Applicants with Disabilities: As an equal opportunity employer, Acuity Inc. is committed to providing reasonable accommodations in its application process for qualified individuals with disabilities and disabled veterans. If you have difficulty using our online system due to a disability and need an accommodation, you may contact us at (770) 922-9000, select option 4. Please clearly indicate what type of accommodation you are requesting and for what requisition.
Application Instructions
Unsolicited resumes sent to Acuity Inc. from a third party, such as an Agency recruiter, including unsolicited resumes sent to an Acuity Inc. mailing address, fax machine or email address, directly to Acuity Inc. employees, or to Acuity Inc. resume database will be considered Acuity Inc. property. Acuity Inc. will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
Equal Opportunity Employer
We value diversity and are an equal opportunity employer. All qualified applicants will be considered for employment without regards to race, color, age, gender, sexual orientation, gender identity and expression, ethnicity or national origin, disability, pregnancy, religion, covered veteran status, protected genetic information, or any other characteristic protected by law.