Sr. Data Engineer

Job Description

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, house cleaning, 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. Senior Data Engineer

We are looking for a Senior Data Engineer who brings both hands-on expertise and thought leadership to our growing data team. This role is ideal for someone who thrives at the intersection of engineering and architecture - someone who not only builds robust pipelines and warehouse data models but understands the necessary design elements of building enterprise data architecture. Your leadership and expertise will contribute to uncovering impactful insights that inform business decisions and transform how we engage with our customers while ensuring high-quality, reliable data pipelines and data models that support analysis and AI. Your work and expert guidance will empower us to tackle complex business challenges with confidence and clarity. This is a hybrid role based in our Strongsville, Ohio location.

Essential Functions and Responsibilities

Data Design and Architecture

Develop and maintain a comprehensive data architecture strategy aligned with business objectives.

Assist in the evaluation and selection of appropriate technologies and tools that support the data architecture blueprint.

Design, maintain, and evolve logical and physical data models and schemas (star, snowflake, cube) to support both analytical warehouse and data mart designs, including other operational data use cases advanced analytics.

Assist in the configuration and management of data infrastructure components, including databases, data warehouses, data lakes, and distributed computing frameworks.

Monitor system performance, troubleshoot issues, and implement optimizations to enhance reliability and efficiency.

Ensure data governance policies, standards, and regulatory requirements are met within the architecture.

Data Integration and Modeling

Develop scalable and robust data pipelines for extracting, transforming, and loading data from various sources into data lakes or warehouses using no-code tools and custom code as needed.

Implement data ingestion strategies to manage real-time and batch-processing requirements while deploying automation for scheduled and monitoring workflows.

Analyze complex data elements, systems, data flows, dependencies, and relationships to create efficient, version-controlled data models for performance, scalability, and efficient data access across the organization.

Monitor and optimize data systems with robust data validation, quality checks, metadata tracking and lineage to ensure data accuracy, consistency, and reliability across the pipelines.

Collaboration and Documentation

Document technical designs, workflows, and best practices to facilitate knowledge sharing and support system documentation.

Collaborate with data consumers and other stakeholders to translate business requirements into data requirements to deliver tailored solutions which algin to the overall business strategy.

Provide technical guidance and support to team members and stakeholders as needed.

Support and recommend updates or inputs to data governance when necessary.

Ensure business needs are being met by evaluating the ongoing effectiveness of current plans while applying suggestions for improving efficiency and cost effectiveness.Required Skills and Experience

Bachelor's degree in Computer Science, Data Engineering, Mathematics, or a related field.

5+ years of hands-on experience in data engineering or a closely related discipline. Data architecture experience a strong plus.

Strong proficiency in SQL, with a deep understanding of database design, data modeling, indexing, query optimization, and performance tuning.

Experience architecting logical and physical data schemas (star, snowflake, cube).

Experience with programming skills in languages commonly used in data engineering (e.g. Python, Java, or Scala).

Experience with modern ETL/ELT orchestration tools (e.g. Fivetran, Azure Data Factory, and dbt or similar tools).

Strong experience and knowledge with cloud platforms and their data services (e.g. AWS, Azure, or Microsoft Fabric).

Proficient with version control systems like GitHub or Azure DevOps for managing models, transformations, and pull requests and reviews.

Experience with BI tools (e.g. Microsoft Power BI or Tableau).

Excellent analytical and critical thinking skills with keen attention to detail.

Strong communication and collaboration skills.

Ability to work closely with cross-functional teams and translate business needs into technical solutions.

Ability to gather requirements through interviewing skills.

Ability to document technical designs and workflows for both technical and non-technical audiences.

Comfortable working independently in a dynamic environment, managing multiple priorities-even in the face of ambiguity or evolving requirements.

Self-motivated to manage projects to completion with limited oversight.

Experience working in B2B software is a plus, but not required.

A continuous learning mindset and adaptability to new technologies and business challenges.

Ability to manage sensitive and private information with discretion.

Experience with Microsoft data tooling is a plus.

Microsoft Office/365 proficiency.

Fluency in the English language.

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 19-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.

Full-time

Hybrid remote