Data Engineer

KODE Labs; Detroit (MI); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Competitive salary

Discretionary bonus

Flexible PTO

Friendly environment

Social events

Job summary

KODE Labs in Detroit, Michigan, is seeking a Data Engineer to join the EnerG team and build scalable data infrastructure for our cloud-based Building Management System SaaS platform.

You will design pipelines processing billions of data points monthly, implement data quality checks, model energy data, and empower dashboards and ESG metrics.

Qualifications

• Proven experience designing and building end-to-end data pipelines.
• Hands-on experience with BigQuery, Apache Kafka, and Clickhouse.
• Proficiency in Python or Java for data processing.
• Strong data modeling and pipeline configurability.
• Excellent analytical and problem-solving skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines for energy data.
• Implement data quality checks and monitor pipelines for issues.
• Execute data cleaning to handle missing values, outliers, and inconsistencies.
• Aggregate data at 15-min, hourly, and daily intervals to produce energy metrics.
• Develop virtual meters by combining data sources and applying business rules.
• Enrich data with contextual information like weather and occupancy.
• Prepare data for dashboards and ad-hoc analysis; develop KPIs for ESG and energy metrics.
• Ensure compliance with standards like NABERS, LEED, and Energy Star.
• Normalize energy data with weather for comparisons.
• Develop predictive models to forecast energy consumption.

Skills

BigQuery

Apache Kafka

Clickhouse

Python

Java

Data modeling

End-to-end data pipelines

Data quality checks

Collaboration

Job description

Our team is hiring a Data Engineer to join our EnerG team . Be a driving force behind our innovative cloud-based Building Management System (BMS) SaaS platform. You will play a pivotal role in shaping the future of energy management by architecting and developing the core data infrastructure.

You will be at the forefront of processing and managing a high volume of data, handling billions of data points monthly to deliver insightful metrics and Key Performance Indicators (KPIs). Your contributions will directly empower our platform's ability to provide actionable energy insights.

If you are a motivated Data Engineer with a strong passion for building and maintaining robust data infrastructure that facilitates seamless data processing, in-depth analysis, and impactful visualizations, we encourage you to explore this opportunity.

WHAT YOU WILL DO

Design, develop, and maintain scalable data pipelines for efficient processing and storage of energy data.

Implement data quality checks, monitor pipelines for issues, and ensure accuracy and completeness.

Execute data cleaning processes to handle missing values, outliers, and inconsistencies, and standardize formats for consistency.

Aggregate data at various intervals (e.g., 15-min, hourly, daily) and transform it into key metrics like energy consumption and cost analysis.

Implement algorithms to detect and remove anomalies, ensuring the integrity of data-driven insights.

Develop algorithms to create virtual meters by combining data from multiple sources or applying business rules.

Enrich data with contextual information (e.g., weather, occupancy, utility rates) for deeper analysis.

Identify and address data gaps to ensure comprehensive reporting and analysis.

Analyze relationships between data sources to uncover correlations and insights for informed decision-making.

Prepare data for dashboards, custom reports, and ad-hoc analysis; develop KPIs for ESG and energy metrics.

Ensure compliance with industry standards like NABERS, LEED, and Energy Star for data collection and reporting.

Normalize energy data based on external factors like weather to enable accurate comparisons.

Develop predictive models to forecast energy consumption and support resource management planning.

WHAT YOU NEED TO SUCCEED

Proven experience in designing and building end-to-end data pipelines.

Hands-on experience with big data technologies, including but not limited to BigQuery, Apache Kafka, and Clickhouse.

Proficiency in programming languages such as Python or Java, with a strong emphasis on data manipulation and processing.

Demonstrated experience in building configurable and adaptable data pipelines to meet evolving business needs.

A strong understanding of data modeling principles and best practices.

Excellent analytical and problem-solving skills with a keen attention to detail.

Ability to collaborate effectively within a team environment and communicate technical concepts clearly.

A proactive approach to learning and adapting to new technologies and challenges in the data engineering landscape.

WHAT WE OFFER:

• Competitive salary based on experience
• Discretionary Bonus Program
• Dynamic team and challenging projects
• Flexible Paid Time Off
• Welcoming and friendly work environment
• Regular social events and activities

JOIN THE TEAM

KODE Labs is a real estate technology company founded in 2017 with a mission to change the way people, buildings and systems operate. Headquartered in Detroit, Michigan, we are a driving force behind the adoption of smart building technology. To scale our presence in Detroit and across the Nation, we depend on our team of talented, ambitious people who go above and beyond to create value for our clients.

When you join the KODE Labs team you can create your own career. Whether you have years of experience or are just starting, we help you realize your full potential and achieve your goals.