Data Analytics Engineer

Henderson Engineers - Lenexa, KS

Full-time - Mid Level

Lenexa, KS

Professional, Scientific, and Technical Services

About the position

As a Data Analytics Engineer at Henderson, you will play a crucial role in 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, enabling business stakeholders to easily access and derive insights from data stored in cloud-based data warehouses or on-premises databases.

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.
• Pursue challenging assignments and new knowledge.
• Encourage experimentation when faced with new challenges.
• Examine mistakes, clarify lessons learned, and apply to future work.

Requirements

• 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 Google Cloud Platform for data storage and processing is strongly preferred.

Nice-to-haves

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

Benefits

• Flexible Work Hours
• Casual Dress Code
• Paid Volunteer Time
• Paid Parental Leave
• Health and Wellness Initiatives
• Receptive and Forward-Thinking Leadership
• Clear Career Path Options
• Industry-leading 401K match and profit sharing
• Employee Stock Ownership Plan
• Paid Training for Professional Development
• Performance Bonuses
• Comprehensive and Extensive Insurance
• Paid Term Life and Disability
• Health Savings Account & Flexible Spending Accounts
• Paid Time Off and Sick Time off
• Financial Wellness & Coaching Program