Mid-Level Data Engineer

At Henderson, we're about more than just buildings
We're about the people, experiences, and potential found inside. We’re a company of problem-solvers and innovators known for our technical excellence and ability to come up with out-of-the-box solutions. We love the process of bringing buildings to life. And we're changing the industry by integrating the building design and construction process.


As an ESOP, each of our employee-owners are an essential part of our mission to lead the industry in innovation, sustainability, and client experience. With a vision to build a better world, Team Henderson has a people-first culture and diverse portfolio of world-class facilities.


It's What We Do

We provide total building system design services across multiple high-growth markets for industry leaders. You'll get to use your talent to work on projects for some of the biggest names in mission-critical, higher education, sports, healthcare, grocery, restaurant, and retail within the sectors we serve in business, community, grocery, health, retail, & venue.


It's How We're Different

We're about more than just buildings. We're about you. You, and the hundreds of passionate employee-owners who make us who we are. We’ve always been committed to providing an inclusive workplace where people can bring their full self to work and helps people reach their full potential – both as professionals and individuals. Together, we dream up innovative solutions for industry-wide problems, design spaces that become landmarks, and toast the good life at our happy hours. Take a peek into what makes us different here: https://youtu.be/AIt17t_uJ-A?si=oSMy5zQeUcb_faE3


Henderson Engineers is looking to hire a Data Engineer to join their team in Kansas City. The Data Engineer II is responsible for ensuring that large volumes of data from various databases and systems are ingested, transformed, and made analytics ready. This position involves designing, implementing, and maintaining scalable data pipelines and analytics systems using modern programming tools. The Data Engineer II will model raw data into clean, tested, and reusable datasets that adhere to best practices, enabling business stakeholders to easily access and derive insights from data stored in cloud-based data warehouses or on-premises databases. They will work closely with data analysts, data scientists, and business teams to understand data requirements and ensure that solutions meet the organizations analytics and reporting needs. They will ensure the seamless integration of data sources, high data quality, and optimal performance across the analytics stack.

Required Qualifications:
• Bachelor’s degree in computer science, data science, software engineering, or a related field required. 4 years of related experience may be considered in lieu of degree.
• Minimum 4 years of experience in data analytics, data engineering, or software engineering required.
• Additional experience in data science or data analytics is highly preferred.
• In-depth knowledge of relational databases required.
• Expertise in data modeling, ETL development, and data analysis.
• Strong ability in SQL for data extraction and manipulation, and proficiency in data warehousing concepts/tools such as Redshift and Snowflake.
• Proficiency with DBT (data build tool) required with hands-on experience transforming data, managing models, and maintaining high-quality data pipelines.
• Experience with data vault 2.0 methodology and experience implementing data vault 2.0 for scalable and adaptable data warehousing solutions is strongly preferred.
• Familiarity with cloud-based architecture such as Azure, AWS or (GCP) Google Cloud Platform for data storage and processing is strongly preferred.
• Substantial programming ability using languages/tools such as R, Python, Java Script, Scala and C++ for data manipulation and scripting.
• Solid understanding of relevant data governance, data quality, and data security best practices.
• Strong critical thinking skills, and the ability to think analytically.
• Knowledge of ETL processes, data integration, and data warehousing concepts.
• Familiarity with data visualization tools such as Tableau, Power BI, and Looker.
• Knowledge of big data technologies and distributed computing frameworks such as Hadoop and Spark.
• Excellent communication skills to effectively collaborate with cross-functional teams and present insights to business stakeholders.

Essential Job Functions & Responsibilities:
• Design, develop, and maintain efficient data pipelines to support extract, transform, load (ETL) processes.
• Implement and manage analytics systems, data warehouses, or data lakes for structured and unstructured data.
• Ensure data is well defined, transfor