Job description

Job Title: Data Analytics Engineer 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 working from our headquarters in Cincinnati and branches in Dayton, Columbus, Toledo, Akron, Cleveland and Louisville. Recognized as a Top Workplace and named to the Inc. 5000 list of fastest-growing private companies, we have a long-standing track record of success and ambitious goals for the future. Our impact extends beyond fire alarms and sprinklers; we provide peace of mind to the communities we serve. At Silco, you’re not just doing a job, you’re making a difference. Position Overview: We are seeking an Data Analytics Engineer to join our data team as we continue to evolve our data platform and analytics capabilities. This role is ideal for someone who already has a solid foundation in SQL and reporting tools and is ready to grow their skills in cloud data technologies and modern data development. As an Data Analytics Engineer, you’ll work with both structured SQL environments and newer tools like Power BI, Azure Data Factory, and Databricks. You’ll help bridge the gap between traditional reporting and scalable, modern analytics pipelines. Responsibilities: • Support the design and development of data models, datasets, and reporting layers • Build and maintain Power BI dashboards and DAX measures • Assist with data pipeline development using Azure Data Factory and Databricks • Write and optimize SQL queries, views, and stored procedures • Help document and validate business logic and metrics • Collaborate with team members on data quality, consistency, and usability • Support production data processes Qualifications: • Proficiency in SQL (T-SQL or similar) • Hands-on experience with Power BI (building visuals, using DAX) • Familiarity with at least one cloud-based data tool (e.g., ADF, Databricks, Synapse, etc.) • Understanding of data modeling concepts (star/snowflake schema, facts/dimensions) • Desire to grow into advanced data engineering, DevOps, or analytics automation • Additional considerations: • Familiarity with Agile development methodologies • Exposure to Python, notebooks, or version-controlled data workflows • Experience using Git for code management • Comfort working with large datasets in cloud storage (e.g., Delta Lake) • Atlassian Jira experience Benefits: In addition to a competitive compensation package, Silco offers a wide range of benefits such as medical, dental, vision, Aflac and a Flexible Spending Account (FSA). Silco offers company paid short-term disability and life insurance, as well as company paid training. The Company also boasts a 401(k) program with company matching and tuition reimbursement. Silco provides 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.

Requirements