Senior Business Intelligence Analyst

Caliber Collision - Lewisville, TX

Full-time - Mid Level

Lewisville, TX

Repair and Maintenance

About the position

The Senior Business Intelligence Analyst serves as a vital business partner within the Finance Department, tasked with designing, developing, and implementing advanced analytics tools and data solutions. This role requires a comprehensive understanding of business data needs, where the analyst will gather requirements, analyze data, and manage robust enterprise-level Business Intelligence (BI) solutions for complex projects. The position emphasizes self-service analytics and the extraction of actionable insights from data in a timely manner, all while adhering to high standards and best practices in a fast-paced organizational environment. The ideal candidate is a purpose-driven team player focused on professional growth, leveraging their expert knowledge, leadership, and managerial skills to reach their full potential. In this role, the Senior Business Intelligence Analyst will be responsible for supporting various projects and change management initiatives across key project owners, including IT, Finance, Operations, Human Resources, and Marketing. The analyst will identify, research, and resolve complex business problems, applying analytical techniques to develop solutions that drive outcomes in Sales, Finance, and Operations. They will also design, implement, and maintain complex BI solutions, including data models in Microsoft SQL Server Analysis Services (SSAS), Excel Power Pivot, and Power BI, while creating and maintaining reporting tools and troubleshooting improvement opportunities. The analyst will define relevant data points, manage data extraction, transformation, calculations, and visualizations, and support the Finance organization in building the necessary roles, skills, processes, and collaboration with other teams to enhance BI solution delivery speed, accuracy, and insightfulness. They will facilitate conversations to integrate third-party data to drive key metrics and share knowledge related to finance, operations, business intelligence, and data tools. Additionally, the analyst will help manage financial tools, reporting, and data analytics systems, ensuring governance, security, consistency, integrity, and accuracy of all end-user data. Participation in system maintenance, user support, upgrade activities, and integrations is also a key aspect of this role.

Responsibilities

• Act as a business intelligence partner for the Finance Department, supporting projects and change management initiatives.
• Identify, research, and resolve complex business problems using analytics techniques to develop solutions that drive outcomes.
• Design, implement, and maintain complex BI solutions including data models in Microsoft SSAS, Excel Power Pivot, and Power BI.
• Create and maintain reporting tools, troubleshoot improvement opportunities, and process change requests as needed.
• Define relevant data points, data extraction, transformation, calculations, and visualizations.
• Support the Finance organization in building roles, skills, processes, and collaboration necessary for improved BI solution delivery.
• Facilitate conversations to integrate third-party data to drive key metrics and share knowledge related to finance and data tools.
• Manage financial tools, financial reporting, and data analytics systems while ensuring data governance and accuracy.
• Participate in system maintenance, user support, upgrade activities, and integrations.

Requirements

• Bachelor's degree in Finance, Business Analytics, Engineering, or related field, or equivalent work experience.
• 3-5 years of experience in developing business solutions combining business intelligence, dashboards, and reporting.
• Understanding of Finance and Accounting methodologies, concepts, and principles.
• Experience in DAX/data modeling with Microsoft Power BI, Power Pivot, and/or SSAS Tabular.
• Relevant experience with Microsoft Excel, data modeling, and data visualization tools.
• Knowledge in data mining, machine learning, artificial intelligence, predictive analytics, and/or big data.
• Demonstrated ability to turn end-user requirements into actionable tools and insights.
• High standards of accuracy, precision, and organization.
• Strong verbal and written communication skills.

Nice-to-haves

• Master's degree/MSBA/MBA/MIS or PhD would be considered a plus.
• Experience in process improvement and automation.
• Ability to think creatively and be self-motivated.
• Comfortable in a high growth and strong customer service environment.