Senior Data Engineer

Senior Data Engineer
Location: Evendale, Ohio
Compensation: $90,000.00 - $120,000.00
Work Model: Hybrid – onsite 3 Days and 2 remote
No Sponsorship offered,  W2 only, must already reside in the area. 

Join a forward-thinking engineering team where you’ll bridge the gap between complex data architecture and actionable business intelligence.

As a Senior Data Engineer, you won’t just move data—you’ll architect the flow of information for our entire enterprise. You will lead the design of scalable ETL/ELT pipelines, optimize high-performance database schemas, and empower our leadership with governed, high-quality data via Power BI.

The Essentials

• Compensation: $90,000 – $120,000 (Based on experience)

• Work Model: Hybrid (3 days onsite in Evendale, OH / 2 days remote)

• Type: Direct Hire | Full-Time (40 hrs/week)

• Location: Must reside in the Greater Cincinnati Metropolitan area

Core Responsibilities

• Pipeline Architecture: Design and maintain robust ETL/ELT pipelines using Boomi and other iPaaS tools to integrate on-premise (SQL Server, Oracle) and cloud-based API systems.

• Database Leadership: Lead decisions on database architecture, including logical/physical schema design, indexing strategies, and partitioning to ensure peak performance.

• BI Enablement: Architect efficient data models and maintain datasets that serve as the backbone for Power BI reporting and enterprise analytics.

• Optimization & Governance: Perform deep query tuning and implement strict data governance, lineage, and security policies to ensure a “single source of truth.”

• Mentorship: Act as a technical pillar for the team, mentoring junior engineers and contributing to the long-term data platform roadmap.

What You Bring to the Table

• Experience: 6+ years in Data Engineering or Database Development.

• Integration Expertise: Proven mastery of Boomi (or equivalent iPaaS) for complex enterprise integrations.

• Database Depth: Expert-level command of SQL Server and Oracle. You should be comfortable navigating both T-SQL and PL/SQL environments.

• Reporting Power: Strong experience designing data models specifically optimized for Power BI.

• Technical Toolkit: Proficiency in scripting (Python, PowerShell, or Bash) and familiarity with CI/CD workflows and version control (Git).

• Education: Bachelor’s degree in CS, Data Engineering, or a related field (Master’s preferred).

Technical Environment

System One, and its subsidiaries, including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we also offer eligible employees health and welfare benefits, including medical, dental, vision, spending accounts, life insurance, voluntary plans, and participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#M2
#LI-DH1
Ref: #861-Cincinnati-S1