Sr. Data Engineer

Foundation Software; Strongsville (OH); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Paid vacation

401(k) with match

Tuition reimbursement

Medical, dental, vision

Job summary

Foundation Software in Strongsville is seeking a Senior Data Engineer to design, build, and standardize our data platform. You will lead scalable pipelines, data models, and governance while partnering with analysts, stakeholders, and tech teams.

You will move from architecture to production, implementing CI/CD, tuning performance, and driving best practices across the data ecosystem. A hands-on leader with strong SQL and cloud data warehousing is essential.

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, Mathematics, or related field.
• 7+ years of hands-on experience in data engineering or a closely related discipline.
• Expert-level SQL skills in database design, dimensional modeling, query optimization, indexing, and performance tuning.
• Experience with modern cloud data warehouses and Lakehouse architectures.
• Strong experience designing logical and physical data models including star and snowflake schemas.
• Background implementing CI/CD pipelines and automated deployment practices.
• Experience with programming languages used in data eng (Python, Java, or Scala).
• Excellent experience with modern ETL/ELT orchestration tools (Fivetran, Azure/Fabric Data Factory, dbt).
• Knowledge of cloud platforms and data services (AWS, Azure, Fabric).
• Proficient with version control systems (GitHub/Azure DevOps).
• Experience with BI tools (Power BI or Tableau).
• Comfortable working independently in a dynamic environment.

Responsibilities

• Architect, build, and manage data repositories, data integration solutions, and scalable pipelines.
• Implement CI/CD practices for data pipelines and transformations.
• Design and implement monitoring, observability, and operational support for data pipelines.
• Troubleshoot data pipeline failures, performance bottlenecks, and production incidents.
• Evaluate, select, deploy, and maintain data infrastructure components.
• Create and evolve data models and schemas for storage, retrieval, and analytics.
• Optimize storage, processing, and query performance while controlling cloud costs.
• Implement data validation, quality checks, and metadata management across pipelines.
• Ensure data governance, security, and compliance by design.
• Document architectures, pipelines, and data models for technical and non-technical audiences.
• Collaborate with stakeholders to define requirements and deliver trusted data products.
• Mentor and coach team members on engineering best practices.

Skills

SQL expertise

Data modeling

ETL/ELT

Cloud data

CI/CD

Programming: Python/Java/Scala

Mentoring

Education

Bachelor's degree

Tools

Fivetran

dbt

Azure Data Factory

Databricks

BigQuery

Fabric

GitHub Actions

Job description

Senior Data Engineer

We are a Microsoft heavy organization looking to build out and modernize our data ecosystem. We are seeking a Senior Data Engineer to help design, build, and establish the engineering standards for our data platform. This role requires a hands-on engineer with strong experience in data architecture, data modeling, ETL/ELT, cloud data platforms, and modern data engineering practices.

The Senior Data Engineer will design and implement scalable data pipelines, data models, and data platform solutions that support analytics, business intelligence, AI, and enterprise reporting. The role will also help establish best practices for data engineering, reliability, performance, governance, and deployment while partnering closely with business stakeholders, analysts, and technology teams.

This is a hands-on role for an experienced engineer who can move effectively from architecture and design through implementation and production support. We need someone who has done this before, understands what good looks like, and can help shape how we build, operate, and evolve our data environment.

Essential Functions and Responsibilities

Key Responsibilities

• Architect, build, and manage data repositories, data integration solutions, and scalable pipelines.
• Implement CI/CD practices for data pipelines and transformations.
• Design and implement monitoring, alerting, observability, and operational support processes for data pipelines and platforms.
• Troubleshoot and resolve data pipeline failures, performance bottlenecks, and production incidents.
• Assist in the evaluation, selection, deployment, and maintenance of data infrastructure components, including databases, data platforms, and pipeline tools.
• Create, maintain, and evolve logical and physical dimensional data models and schema designs in support of storage, retrieval, and analytics.
• Optimize data storage, processing, and query performance while managing cloud infrastructure costs.
• Execute strategies for workload tuning, partitioning, indexing, and resource utilization.
• Implement robust data validation, quality checks, and metadata management to monitor data accuracy, consistency, and reliability across pipelines aiding analytics, BI, and AI requirements.
• Ensure data governance policies, compliance requirements, and security requirements are met by design as code.
• Maintain proficiency with technology trends in data engineering, evaluating potential impacts.
• Document data architectures, infrastructure designs, pipelines, workflows, transformations, and data models for both technical and non-technical audiences.
• Collaborate with business and technical stakeholders to define requirements, prioritize initiatives, and deliver trusted, scalable data products and services.
• Mentor and coach team members while promoting engineering best practices, technical standards, and continuous improvement.

Required Skills and Experience

• Bachelor's degree in Computer Science, Data Engineering, Mathematics, or related field.
• 7+ years of hands-on experience in data engineering or a closely related discipline.
• Expert-level SQL skills in database design, dimensional modeling, query optimization, indexing, and performance tuning.
• Experience with modern cloud data warehouses ("Fabric Warehouse", "BigQuery", "Databricks", etc.), including Lakehouse architectures and large-scale data processing platforms.
• Strong experience designing logical and physical data models including star and snowflake schemas.
• Background implementing CI/CD pipelines and automated deployment practices (g. DevOps, GitHub Actions).
• Experience with programming skills in languages commonly used in data engineering (e.g. Python, Java, or Scala).
• Excellent experience with modern ETL/ELT orchestration tools (e.g. Fivetran, Azure/Fabric Data Factory, and dbt or similar tools).
• Strong experience and knowledge with cloud platforms and data services (e.g. AWS, Azure, Fabric).
• Proficient with version control systems (e.g. GitHub or Azure DevOps).
• Experience with BI tools (e.g. Microsoft Power BI or Tableau).
• Comfortable working independently in a dynamic environment, managing multiple priorities even in the face of ambiguity or evolving requirements.

Company Culture

What is great about working for Foundation? Plenty! We have a fun, casual, yet hard-working culture that invests in our employees, promotes creativity, and delivers on our reputation. Would you like to work for a company that offers manicures and pedicures in the office? We do! How about massages, laundry service, monthly car washes, catered lunches Wednesdays and a monthly happy hour - we offer all this and more!

At Foundation we believe in and promote a work-life balance with a top-notch workout facility, fitness classes and free personal training; and for those competitive types, a game room complete with table tennis, foosball, and video game systems. Also, some comforts of home, there is a full kitchen, free coffee and specialty flavors, soft drinks, and snacks.

Other employee rewards include tickets to Cleveland sporting events, a variety of lunch and learns, and various employee-appreciation events throughout the year. Benefits include paid vacation, paid holidays, 401(k) with match, and tuition reimbursement, plus medical, eye and dental. Now offering discounts on pet, home, and auto insurance through Liberty Mutual!

Foundation is constantly recognized as one of Northeast Ohio's top workplaces. We are a 21-time winner of the NorthCoast 99 award, a multi-year winner of The Plain Dealer's Top Workplaces award, and have been recognized multiple years on the Inc. 5000 list of fastest-growing private companies in the U.S.

Let us start your future at Foundation!

Foundation Software is an Equal Opportunity Employer.