Business Intelligence Analyst

Summary

Join our Business Intelligence team as a Business Intelligence Analyst and play a key role in supporting firm leadership by translating complex business questions into actionable insights. You will focus on front-end development, designing intuitive visualizations for better decision-making. Collaborate with stakeholders to gather and document business requirements, and contribute to light back-end development tasks. Support all project phases, from planning to implementation, working independently with limited oversight. This unique opportunity allows you to advance professionally, bring fresh perspectives, and balance personal and professional ambitions. The role involves designing dashboards and reports in Power BI, applying data visualization best practices, and ensuring data accuracy and integrity.

Requirements

• Bachelor’s Degree in Data Analytics, Accounting, or Business-related field
• 2-5 years of business analysis or related experience
• Experience with Power BI, or other data visualization tools
• Proven ability to synthesize complex or diverse information
• Strong analytical stills and ability to ask effective questions
• Strong attention to accuracy and details
• Strong project management skills and ability to multitask
• Creative thinker with vision and passion to innovate
• Proficiency in Microsoft Office Suite (specifically Excel)

Responsibilities

• Interface with business stakeholders to understand objectives, define reporting needs, and translate into technical requirements
• Leverage internal data to improve processes, gain insights, and produce actionable recommendations
• Assist with solving unique business challenges, trends, or inquires through ad hoc analysis
• Design and develop intuitive, interactive dashboards and reports in Power BI, pulling data from our Boulay databases (built in Microsoft SQL Server)
• Apply data visualization best practices to ensure clarity, accessibility, and insight
• Strengthen product adoption and support business users through on-going training for Business Intelligence products
• Maintain and optimize existing reports to meet evolving business requirements, improve performance and relevance
• Collaborate with Business Intelligence Developer on data modeling tasks as needed to support front-end development
• Develop ad hoc queries and views in SQL Server to extract and validate data across multiple sources
• Assist with quality assurance through testing, verifying, documenting results, and maintenance of Business Intelligence products
• Validate data accuracy and integrity in reports and dashboards
• Create documentation for report logic, data definitions, and dashboard usage

Preferred Qualifications

• Experience with MS SQL or a similar query language
• Experience with Azure Power Platform
• Experience with Deltek Maconomy
• Ability to understand pre-existing SQL codes generated by others
• Willingness to go above and beyond what is expected

Benefits

• 401(k)
• Dental insurance
• Disability insurance
• Employee assistance program
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Parental leave
• Tuition reimbursement
• Vision insurance
• Work from home