Business Intelligence Analyst (Hybrid)

Summary:

Barr Engineering Co. seeks a business intelligence (BI) analyst to enhance our BI and data analysis capabilities. The position will support our internal data warehouse and reporting requirements, as well as the data needs of our external clients. This person will lead the advancement of our rapidly expanding data-related capabilities using the latest cloud-based tools. This role is well-suited for someone passionate about data and eager to work in an environment with significant growth opportunities.

Responsibilities include:

• Continuing the design, development, and documentation of Barr's enterprise data warehouse, dashboarding, and self-service reporting ecosystem using the Microsoft BI toolset (SQL Server, SSIS, SSAS tabular, Power BI, Azure)

• Leading the process of engaging cross-functional teams to elicit and clearly document BI requirements

• Designing and developing database objects (databases, tables, views, stored procedures, etc.) within a normalized and dimensional data warehouse environment

• Developing, maintaining, and supporting ETL processes (e.g., SSIS, Azure Data Factory)

• Creating intuitive data visualizations using Power BI, Excel, and other reporting tools

• Developing auditing and quality assurance practices to promote accuracy of the data warehouse and reporting

• Performing data analysis to extract insights from complex datasets

• Communicating findings and insights to business stakeholders through clear and concise presentations and reports

• Creating and maintaining system documentation (e.g., data dictionaries, procedures documents)

• Mentoring other data-focused staff members to advance their data capabilities and understanding

Minimum Qualifications:

• Bachelor's degree in computer science, statistics, or a related field, or equivalent work experience

• Five years of related work experience

• Proficiency in developing database queries in SQL

• Experience designing and developing ETL pipelines (e.g., SSIS, Azure Data Factory)

• Experience designing and developing interactive data visualizations (e.g., Power BI, Tableau, Plotly)

• Experience leading requirements-gathering efforts for BI projects

• Strong organizational skills, including ability to plan, monitor, and follow through on work commitments and confirm priorities with stakeholders

• High level of commitment to deliver exceptional client service

• Excellent written and verbal communication skills

• Strong analytical and problem-solving skills

• Legal authorization to work in the United States without the need for sponsorship from Barr, now or in the future

Preferred Qualifications:

• Experience developing data warehouse tools for business purposes

• Experience designing and developing dimensional data models

• Familiarity with Microsoft 365 and Azure technologies such as Fabric, Data Factory, Data Lake, Azure Analysis Services, and SharePoint Online

• Familiarity with data science concepts and tools (e.g., machine learning, AI, Python/R)

• Strong understanding of security in an integrated on-premises and cloud-based BI environment

A hybrid work arrangement may be considered for this position. A hybrid work arrangement refers to splitting time worked between a Barr office and a home office. This position can be based out of Barr's Duluth or Minneapolis, MN offices.

#LI-Hybrid