Cohesion is a leading Intelligent Buildings software solution that is disrupting how buildings operate and how people engage with buildings – from real estate owners/investors, operators, building engineers, to tenants and visitors. Our cutting-edge converged IoT-enabled platform brings together building systems, building software, and business applications into a single portal for web and mobile platforms to forge the path to autonomous buildings. 

We are searching for a Data Engineer to join our rapidly growing team in our Chicago office. This role will report to our Program Director. The Data Engineer is responsible for implementing a scalable, cloud-based data architecture for a data company, leading data quality initiatives, and ensuring the performance of data processes. The right candidate will enjoy solving difficult and novel problems with leadership to work with several development teams in a fast-paced environment. 

What You’ll Do 

• Build and manage data collection and ETL pipelines 

• Build and manage cloud databases 

• Drive efficiencies in data collection and transformation through automation 

• Cleanse and transform data and provide access through business-facing views 

• Ensure data quality throughout the ETL process 

• Tune data queries to optimize performance 

• Ensure the security of data in transit 

• Participate in data governance implementation and strategy 

• Support multiple teams’ data strategies and needs, coordinating with each team to ensure needs are met 

• Represent data best practices in departmental and architecture discussions 

• Write high quality, well tested code to meet the needs of the team’s customers. 

• Provide ongoing, transparent communication with a focus on expectations fostering trust with internal stakeholders and external partners. 

Required Qualifications 

• Minimum of 5 years of overall related experience. 

• Bachelor’s level education or higher in computer science, information technology, or related field. 

• Experience working in a global team. 

• Position requires flexibility to work outside of non-traditional business hours as required to perform job duties 

• Production experience running data pipelines and warehouses at scale on a cloud platform. 

• Proficiency with data analytics, visualization tools, and collaboration tools. 

• Knowledge of and experience with the software development life cycle 

• Experience securing data 

• Strong conceptual, strategic thinking, problem solving, technical, and analytical skills. 

• Experience with the following technology concepts: 

• Data warehousing and data engineering 

• Database design (e. g. Azure hosted SQL server, CosmosDB, Postgres) 

• Data modeling and stored procedures 

• Experience with structured, unstructured, relational, and transactional data (e. g. Blob storage) 

• Scalable data architectures 

• Graph databases and models (e. g. Neo4J) 

• Big Data tools and concepts in the cloud 

• Experience with time series data and streaming data (e. g. Timescale) 

• Query tuning and optimization 

• Data visualization tools (e. g. Power BI, Tableau) 

Desired Qualifications 

• Relevant industry experience. 

• Graduate level education in computer science, information technology, or related field. 

• Understanding of the IoT domain. 

• Experience with BAS and BMS systems. 

• Experience in the Real Estate industry. 

• Strong understanding of Agile development processes. 

• Early-stage startup experience. 

What you can expect from Cohesion 

Cohesion is proud to offer a comprehensive benefits package to eligible, full-time employees in the United States. Our benefits are designed to invest in our employees— and their family’s —well-being, including investments in their health, happiness, and well-being.  

• Receiving a competitive compensation package including an annual performance bonus  

• Eligible for generous benefits such as health/dental/vision insurance, short- and long-term disability, and an employer sponsored 401k match program 

• Eligibility to participate in our Transit Benefits Program to receive tax-free benefits to assist with commuting costs 

• Receiving a monthly cell phone reimbursement 

• Eligibility to participate in the Wellness Reimbursement Program after 6 months of employment 

• Enjoying a responsible unlimited PTO program to help employees manage work life harmony 

• Enjoying a Week of Catch-Up during the last week of the calendar year to catch up on work or personal things so you can start the new year with a clean slate 

• 2-way flexibility of work schedules 

• Dressing for your day   

• Working in an open environment with creative optional brainstorming sessions for all employees   

• Participating in an Annual All Staff Meetings that is a two-day mix of professional development and fun 

• Participating in an all-employee lunch per month, an all-employee breakfast per month, and monthly social event 

• Enjoying a hybrid work environment, including access to a great 6,000 square foot office space in Chicago with office snacks and drinks and breakout rooms 

• Enjoying family leave benefits   

At Cohesion, we see diversity and inclusion as a source of strength. We believe building trust and innovation are best achieved through diverse thought and practice. Individuals seeking employment at Cohesion are considered without regard to race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.