Software Engineer I/II - Data Team

Software Engineer I/II - Data Team
Location: Boston, MA (Hybrid)
Reports to: Lead Data Analyst
Employment Type: Full-time
About Ekotrope
Ekotrope provides software solutions for energy-efficient building design and verification. We develop innovative tools that empower construction professionals to create sustainable and cost-effective buildings. Our mission is to empower people with technology and insights to drive informed decisions that move our built environment towards sustainability. Our company values are very important to us, and we are striving to foster a diverse, equitable, and inclusive work environment.
Position Overview
We're looking for a Software Engineer to join our Data Team, which is responsible for providing the infrastructure and tools to deliver valuable data and insights to our customers. Our team works on improving data quality, collection, and intake from our software applications, internal systems, and other external sources. We also build the tools that deliver insights and value to customers directly, whether that be dashboards, APIs, or something else.
You'll be working closely with our cross-functional team of folks with software & data engineering, data analyst, and account and product management expertise. You will be contributing to our growing data business and helping solve challenging problems at the intersection of sustainability, data engineering, and data mining.
Our team works in a hybrid format. We are based in the greater Boston area, and we have a strong preference for those located in the area that can come into our downtown office regularly. Team members typically come into the office at least one day per week, but this can vary.
Responsibilities
Your day-to-day work could include a variety of impactful projects. We've listed a sample below. Given the growing nature of our company, however, it's likely that specifics will change over time as we develop new products in our growing market segment.

• Make architectural improvements to our data APIs
• Add new data collection capabilities or refactor existing data objects in our Saas applications to support our data business
• Build and maintain photo data processing pipelines using LLMs and other AI tools for data extraction
• Set up automated data quality monitoring systems
• Build API pollers to ingest external data into our models
• Work with Apache Spark (Scala) on AWS Glue for data processing
• Implement solutions to fortify our data and engineering security
• Assist with data-related customer support requests on an ad-hoc basis
• Collaborate across teams to contribute to engineering initiatives beyond the data team

Requirements
Required Experience and Attributes

• 1-4+ years of experience as a software engineer
• Strong Java programming skills
• SQL experience, ideally with PostgreSQL knowledge
• High capacity to learn new information quickly
• Strong sense of curiosity and problem-solving ability
• Demonstrated accountability and humility - comfortable asking for help, asking deeper questions, and collaborating with teammates
• Commitment to our mission of empowering people with environmental data to drive sustainability

Desired Skills (We Don't Expect You to Have All of These)
We think that an ideal candidate would have a majority of these skills. We believe the right candidate will be able to pick up any missing skills as they begin this role.

• Experience working with Apache Spark (we use Spark Scala on AWS Glue)
• Familiarity with AWS cloud resources (Lambda, RDS, EC2, Glue)
• Experience working with photo data pipelines, especially with computer vision/LLM data mining from photos or AI tools for data mining
• Experience with API design and maintenance
• Experience setting up automated data quality monitoring systems
• Scala and Python programming experience
• Experience with Object-Relational Mapping (ORM) and Domain Mapping

Nice to Haves

• Familiarity with front-end design principles
• Experience with Docker
• Experience with threat modeling or other security practices
• Familiarity with any of the following industries:
  
  • The HERS Rating industry
  • ICC Codes / Residential Building and Energy Codes
  • ESG Reporting
  • Product manufacturers in the built environment space (HVAC, Windows, Insulation, etc.)
• Located in the Boston area, able to come to the office and to company retreats

Why Join Ekotrope?

• Impact: Be part of a mission-driven company that is making a big impact on the environmental sustainability of homes throughout the USA. Ekotrope software is used to model more than 400,000 homes each year. That's 1 in 4 of all new homes in the US.
• Culture: Work with a diverse, inclusive, talented and collaborative team that values creativity and ownership.
• Flexibility: Hybrid Boston HQ with remote options across several U.S. states.
• Compensation: we provide a combination of base salary, contingent bonus and stock options. Our strategy is to provide approximately median compensation for a given role and to try to attract and retain great people who value our impact and mission.
• Benefits:

• PTO package - vacation, floating holidays, company holidays and sick days
• Medical, dental, disability & life insurance
• Health Savings Account (HSA)
• 401K with matching program
• Subsidized Blue Bikes Membership and pre-tax MBTA passes
• Home office set up stipend

Ekotrope is an equal opportunity employer, and selects individuals best matched for the job based upon job-related qualifications regardless of race, religion, color, creed, sex, sexual orientation, age, ancestry, national origin, gender identity, genetic information, disability, pregnancy, veteran or military status or any other status or characteristic protected by law.