Business Data Analyst Job at Silco Fire & Security in Cincinnati

Overview

Job Title: Business Data Analyst

Location: Cincinnati, OH

Silco Fire & Security isn’t just a company, it’s a mission. Every day, our team plays a vital role in protecting lives and property for over 45,000 businesses across Ohio, Kentucky and surrounding states. We design, install, maintain and monitor fire protection and security systems that keep people safe and businesses compliant. As the market leader in the Midwest, Silco is a growing, family-owned company with over 400 employees. We operate from our headquarters in Cincinnati and branches in Dayton, Columbus, Akron, Cleveland and Louisville. We are recognized as a Top Workplace and named to the Inc. 5000 list of fastest-growing private companies. Our impact extends beyond fire alarms and sprinklers; we provide peace of mind to the communities we serve.

Position Overview: The Business Data Analyst will work closely with Silco’s President, CIO, Data Architect, and leaders of other departments on data projects including data migration/conversions from acquisitions, data transformations from business changes, and projects supporting other departments with data analysis and transformations. The analyst will spend time shadowing various departments to learn the business and develop into a valuable resource across the company, combining knowledge of Silco’s data structure with the context of how the business operates. The role focuses on ensuring accuracy, consistency, and usability of data across business processes and systems, analyzing and normalizing data from diverse sources, identifying trends and anomalies, and implementing corrective actions to improve data integrity. The analyst will collaborate with cross-functional teams to design and enforce data standards, create processes for ongoing data validation, and provide insights that support business decision-making.

Responsibilities

• Analyze, migrate, and transform data in and out of Salesforce and other software platforms to support changes in the business and provide key reporting to business stakeholders.
• Analyze and reconcile data from multiple platforms to identify discrepancies, gaps, or patterns.
• Normalize data into standardized formats to ensure consistency across systems.
• Investigate anomalies, perform root cause analysis, and apply corrective actions.
• Develop and maintain data quality metrics, dashboards, and reports.
• Collaborate with stakeholders to define data governance standards and best practices.
• Work closely with IT and business teams to design processes & controls that improve accuracy and reduce duplication.
• Document processes and contribute to continuous improvement initiatives around data management.

Qualifications

• Strong analytical and problem-solving skills with attention to detail.
• Proficiency in SQL, Excel, and/or data integration tools.
• Experience with data cleansing, normalization, and quality frameworks.
• Ability to communicate findings clearly to both technical and non-technical stakeholders.
• Familiarity with data governance and master data management concepts is a plus.

Benefits

In addition to a competitive compensation package, Silco offers medical, dental, vision, Aflac and a Flexible Spending Account (FSA). Company-paid short-term disability and life insurance, company-paid training, a 401(k) program with company matching, tuition reimbursement, paid holidays and generous paid time off.

Employment at Silco is contingent upon completing and passing a background check and drug screen. Silco is an Equal Opportunity Employer.

Employment details

• Seniority level: Entry level
• Employment type: Full-time
• Job function: Information Technology
• Industries: Facilities Services

Referrals increase your chances of interviewing at Silco Fire & Security by 2x