Barr Engineering Company
Business Intelligence Analyst (Hybrid)
Barr Engineering Company, Saint Paul, Minnesota, United States, 55130
Job Description: 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 eagerto 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 teamsto 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 Proficiencyin 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 verbalcommunication 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 Open positions at Barr Engineering Co. do not have application deadlines. Barr Engineering Co. is an equal opportunity employer, and all applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Barr is proud to be an affirmative action/equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, gender identity, sexual orientation, age, national origin, disability, protected veteran status, or any other lawfully protected status.