Data Analytics Engineer

Data Analytics Engineer

Kansas City, 1801 Main Street, Kansas City, Missouri, United States of America

Lenexa, 8345 Lenexa Drive, Lenexa, Kansas, United States of America Req #490 Monday, October 14, 2024 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 DoWe 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 DifferentWe'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

As a data analytics engineer, you will ensure 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.

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

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

Key Responsibilities :

• Design, develop, and maintain efficient data pipelines to support extract, transform, load (ETL) processes.
• Utilize SQL Server in an Azure environment.
• Build data aggregation pipelines using Python, Apache Airflow, Spark, SQL, or ClickHouse.
• Implement and manage analytics systems, data warehouses, or data lakes for structured and unstructured data.
• Ensure data is well defined, transformed, tested and documented for analytical purposes.
• Create and optimize data models and architectures to support analytics and reporting.
• Identify and implement optimization to enhance query performance, reduce processing time, and increase overall productivity.
• Work with data scientists, AI engineers, and business stakeholders to integrate predictive models, machine learning algorithms, and deliver comprehensive reports, dashboards, and visualizations.
• Use Power BI to create and maintain dashboards, visualizations and reports.
• Pursues challenging assignments and new knowledge.
• Encourages experimentation when faced with new challenges.
• Examines mistakes, clarifies lessons learned, and applies to future work.

Required Qualifications :

• Bachelor's degree in computer science, data science, software engineering, or a related field. 4 additional years of experience may be considered in lieu of degree.
• Minimum of 4 years of experience in data analytics, data engineering, or software engineering.
• 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.
• Familiarity with cloud-based architecture such as Azure, AWS or (GCP) Google Cloud Platform for data storage and processing is strongly preferred.

Preferred Qualifications :

• Data science or data analytics experience highly preferred.
• Experience with data vault 2.0 methodology and experience implementing data vault 2.0 for scalable and adaptable data warehousing solutions is strongly preferred.
• Substantial programming ability using languages / tools such as R, Python, Java Script, Scala and C++ for data manipulation and scripting.
• Previous experience in the AEC industry.

Let's Talk PerksWe take care of our people. As a Henderson employee, you'll enjoy some pretty awesome perks. Trust us, your friends will all have work envy.

CultureFlexible Work Hours (Because we all need to balance work and life.)Casual Dress Code (Be yourself, please.)Paid Volunteer Time (We literally pay you to volunteer.

Paid Parental Leave (Because we know both parents deserve to be there for a new child.)Health and Wellness Initiatives (Get Fit and Stay Fit.

Receptive and Forward-Thinking Leadership (Our doors are always open.)Clear Career Path Options (We want you to excel.) BenefitsIndustry-leading 401K match and profit sharing (When the company succeeds, we all share in that success.

Employee Stock Ownership Plan (Yes, our employees are the owners.)Paid Training for Professional Development (We'll pay for the time you take getting better at what you do.

Performance Bonuses (When you do well, we reward you for your work.)Comprehensive and Extensive Insurance (We've got you covered.

Paid Term Life and Disability (We've got your family covered, too.)Health Savings Account & Flexible Spending Accounts (We'll help you take advantage of tax savings.

Paid Time Off and Sick Time off (Take a break. You deserve it!)Financial Wellness & Coaching Program (Financial security makes you a happier team member.

More information can be found here - https : / / www.hendersonengineers.com / careers / . Henderson Engineers, Inc. and Henderson Building Solutions are EEO Employers / Vet / Disabled and participate in the E-Verify program.

Applicants for positions with Henderson Engineers / Henderson Building Solutions must be legally authorized to work in the United States, and verification of eligibility will be required at the time of commencement of employment.

All offers will be contingent upon completion of the hiring process including verifications and background checks as required for employment.

To all recruitment agencies : Henderson does not accept unsolicited resumes from search firms or agencies. Any resume submitted to any employee of Henderson without a prior written search agreement will be considered unsolicited and the property of Henderson.

Please, no phone calls or emails. NOTICE TO CANDIDATES : RECRUITMENT FRAUD ALERTHenderson representatives conduct all email communications exclusively through a company email address that ends with @hendersonengineers.

com, @hendersonbuilding.com. We extend offers of employment only after a comprehensive interview process and will never ask you for a payment of any sort nor offer one for any reason.

Henderson will not ask any applicant to purchase equipment, nor offer to reimburse any applicant for expenses incurred prior to employment.

We will not request personal information until a legitimate offer of employment has been extended. If you suspect a recruitment attempt is fraudulent, you should cease communications.

All legitimate job opportunities are posted on our company website's careers page.

Other details

• Job Family Engineering, Design & Tec
• Pay Type Salary

Apply Now

• Kansas City, 1801 Main Street, Kansas City, Missouri, United States of America
• Lenexa, 8345 Lenexa Drive, Lenexa, Kansas, United States of America

Share this job :