Barr Engineering Company
Business Intelligence Analyst (Hybrid)
Barr Engineering Company, Duluth, Minnesota, United States, 55806
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 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-HybridOpen 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.
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-HybridOpen 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.