Barr Engineering Co. - Minneapolis, MN
posted 4 months ago
Barr Engineering Co. is seeking a business intelligence (BI) analyst to enhance our BI and data analysis capabilities. This position will play a crucial role in supporting our internal data warehouse and reporting requirements, as well as addressing the data needs of our external clients. The successful candidate will lead the advancement of our rapidly expanding data-related capabilities using the latest cloud-based tools. This role is ideal for individuals who are passionate about data and are eager to work in an environment that offers significant growth opportunities. The BI analyst will be responsible for the design, development, and documentation of Barr's enterprise data warehouse, dashboarding, and self-service reporting ecosystem utilizing the Microsoft BI toolset, which includes SQL Server, SSIS, SSAS tabular, Power BI, and Azure. The role involves engaging cross-functional teams to elicit and document BI requirements clearly. The analyst will also design and develop database objects such as databases, tables, views, and stored procedures within a normalized and dimensional data warehouse environment. In addition, the BI analyst will develop, maintain, and support ETL processes using tools like SSIS and Azure Data Factory. They will create intuitive data visualizations using Power BI, Excel, and other reporting tools, and will be responsible for developing auditing and quality assurance practices to ensure the accuracy of the data warehouse and reporting. The analyst will perform data analysis to extract insights from complex datasets and communicate findings to business stakeholders through clear and concise presentations and reports. Furthermore, the role includes creating and maintaining system documentation, such as data dictionaries and procedures documents, and mentoring other data-focused staff to enhance their data capabilities and understanding.