Business Intelligence Analyst

$72,000 - $93,000/Yr

Potter Electric - Maryland Heights, MO

Full-time - Mid Level

Maryland Heights, MO

Specialty Trade Contractors

About the position

Join the 125-year legacy of Potter Electric Signal Company! Potter has been a part of the St. Louis community since 1898, and we are very proud of our rich history in the fire and life safety industry. Potter's mission is to be the "Symbol of Protection" for fire and life safety solutions worldwide by combining the latest technology in fire protection with the dedicated manpower for which we have been known for over one hundred years. Our vision is to provide industry-leading quality solutions, products, and services for the protection of life, property, and the environment. With unwavering dedication to our customers, Potter looks to continue as the industry standard in both product and service with increased focus on international expansion. Each employee at Potter takes great pride in knowing that every product we assemble, service, and sell is for the purpose of saving lives around the world. We strive to provide employment opportunities to those individuals who are performance-driven, team players, take pride in their work, and are enthusiastic and passionate about their job. The Business Intelligence Analyst is responsible for creating, maintaining, and deploying all forms of reporting for internal customers. You will work collaboratively with the BI (Business Intelligence) Staff, other IT staff, and business stakeholders with the goal of delivering actionable data analytics. This position plays multiple roles including data architect, data modeler, SQL programmer, report writer, report designer, and project manager. Essential Functions include designing, building, and deploying business intelligence reports, self-service reports, and dashboards using a variety of front-end visualization tools such as Tableau, SSRS, and Crystal Reports. You will test and validate underlying report data, conveying the key insights or “story” the data reveals in a visual format that is grouped, summarized, or formatted to be easily consumed, understood, insightful, and actionable. You will also provide direction and guidance to other Business Intelligence Analysts, work with large, messy, disparate datasets, and conduct ad-hoc analyses to quickly inform critical business decisions. Additionally, you will create ETLs or processes that pull data from multiple places and centralize it in one data source, review and optimize existing queries written by other developers, and participate in innovative technology evaluation to ensure alignment of business unit data and analytics practices with enterprise data processes and practices. This role requires excellent communication skills and the ability to work cross-functionally, as well as a proactive approach to continuous improvement efforts for all reports and their operation. This is a full-time position, on-site at Potter Headquarters, with a hybrid work format option after a thorough understanding of the Potter Global Technologies global network.

Responsibilities

• Design, build, and deploy business intelligence reports, self-service reports, and dashboards using a variety of front-end visualization tools such as Tableau, SSRS, and Crystal Reports.
• Test and validate underlying report data; convey the key insights or 'story' the data reveals in a visual format that is grouped, summarized, or formatted to be easily consumed, understood, insightful, and actionable.
• Provide direction and guidance to other Business Intelligence Analysts.
• Work with large, messy, disparate datasets and conduct ad-hoc analyses to quickly inform critical business decisions.
• Create ETLs or processes that pull data from multiple places and centralize it in one data source.
• Review and optimize existing queries written by other developers; perform ongoing monitoring and refinement of reports and BI solutions.
• Participate in innovative technology evaluation and ensure alignment of business unit data and analytics practices with enterprise data processes and practices.
• Develop and maintain operating procedures and support documentation for all reporting infrastructure.
• Proactively engage in continuous improvement efforts for all reports and their operation.
• Perform other duties as assigned.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Mathematics, or a related field.
• 3-5 years of experience in IT and Business Intelligence creating advanced reports using tools such as Tableau (or other BI tools like Power BI, Qlik, or Tibco), SSRS, SSIS, T-SQL, MS SQL Server preferred.
• A minimum of 3 years of experience designing, writing, and maintaining Crystal Reports.
• Experience with remediating end point virus related issues and network/email virus issues.
• Experience with end user Cyber Training and a desire to continue to grow and develop Cyber skills.

Nice-to-haves

• Prior experience in Business Intelligence development, planning, design, configuration, coding, and troubleshooting of BI tools preferred.
• Strong understanding of database systems and data warehouse architecture preferred.
• Familiar with any ERP database schemas and departmental processes preferred.
• Experience with Python or other scripting language is a plus.

Benefits

• Participation in an ownership program of Potter Global Technologies through KKR.
• Opportunities for professional development and growth.
• A collaborative work environment focused on innovation and improvement.