Business Intelligence Analyst

SUMMARY DESCRIPTION: The Business Intelligence Analyst works side by side with multiple business divisions and engineering teams. The role's major responsibilities include building reports and dashboards, digging into data, automating repetitive work, and helping business teams get answers quickly. The Business Intelligence Analyst sits across multiple divisions, Engineering and leadership, and spends as much time understanding the business and finding process improvement opportunities as working with data.

ESSENTIAL JOB FUNCTIONS:

• Build and maintain Power BI reports and dashboards used across various teams and leadership
• Write and optimize SQL to pull, clean and shape data, including views and temp tables that support reporting
• Automate manual work and reduce time spent on repetitive tasks
• Help design and improve data models in the Microsoft Fabric environment
• Turn loose business questions into clear requirements, then into working solutions
• Work across multiple divisions, Engineering and other teams to fix data issues at the source, not just patch them in reports
• Test and apply AI tools where they save real time
• Participate in special projects and completes other duties as assigned

EXPERIENCE/QUALIFICATIONS:

• Hands-on experience with Power BI and the wider Microsoft analytics stack (Fabric, Excel, Power Query, DAX)
• Strong SQL: joins, CTEs, temp tables, views and performance tuning
• Python for data work, from basic scripting up to more advanced automation
• Day-to-day experience working with Git
• Practical experience using AI products at work
• Solid grasp of data modeling and architecture (star schemas, fact and dimension tables, slowly changing dimensions)
• Good understanding of how BI works end to end, from source data to the final report
• Communicates clearly with both technical and non-technical people
• Interest in how the business runs, and the curiosity to ask, “why does this number look like that?”

PREFERRED QUALIFICATIONS:

• Exposure to invoicing, billing, and other operational data
• Experience with JIRA for project management
• Experience using Confluence for process documentation
• Experience or basic understanding of on-demand intelligence

Why Join RENFROE?

We believe that success starts with our people. By joining our team, you’ll become part of a culture built on strong values:

• Excellence: We are dedicated to excellence in every aspect of our work. We seek the best minds and talents and provide them with opportunities for professional growth and continuous learning.
• Growth: Growth is the cornerstone of our company’s mission. By driving innovation, expanding our reach, and continuously improving our services, we ensure the company’s progress and success. At the same time, we remain dedicated to supporting the personal growth of our employees, fostering a dynamic and thriving workplace for all.
• Curiosity: We foster curiosity and innovation, encouraging creative thinking and exploration of new ideas to remain at the forefront of our industry.
• Empathy: A supportive and understanding workplace is key to our success. We value empathy and build relationships based on trust and mutual respect.
• Integrity: Transparency and honesty are at the core of our business practices. We uphold the highest ethical standards in all that we do.
• Service: Service is at the heart of our values. We are committed to making a positive impact on our clients, our community, and each other.