Senior Data Engineer: Build Modern Data Pipelines & Platforms

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

Benefits offered by this job

Paid vacation

Paid holidays

401(k) with match

Tuition reimbursement

Medical, dental, vision

Pet insurance discounts

Job summary

Foundation Software seeks a Senior Data Engineer to design and modernize our data platform and analytics ecosystem. You will architect data pipelines, models, and repositories, enabling BI, analytics, and AI initiatives across the organization.

The role requires hands-on expertise in data architecture, ETL/ELT, and cloud services, with leadership responsibilities for standards, governance, and best practices. Join a dynamic team and help shape our data future.

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 (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 (e.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.

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.

Skills

SQL

Data modeling

Cloud data warehouses

ETL/ELT

GitHub Actions

Python

BI tools

Education

Bachelor's degree in Computer Science or related

7+ years data engineering experience

Tools

CI/CD pipelines

dbt

Azure/Fabric Data Factory

Job description

Foundation Software seeks a Senior Data Engineer to design and modernize our data platform and analytics ecosystem. You will architect data pipelines, models, and repositories, enabling BI, analytics, and AI initiatives across the organization.

The role requires hands-on expertise in data architecture, ETL/ELT, and cloud services, with leadership responsibilities for standards, governance, and best practices. Join a dynamic team and help shape our data future.