Data Engineer

almost 3 years ago
Full time role
San Francisco, CA, US... more
San Francisco, CA, US... more

Company

Founded in 2014, Generate builds, owns, and operates sustainable infrastructure to deliver affordable and reliable resource solutions for companies, governments, ...

View Company Profile

Job Description

Data Engineer

Reporting to: Head of Data Engineering

Location:  San Francisco Bay Area, with remote arrangements considered

Position Mission:  Generate Capital is hiring a Data Engineer to support the Data & Technology team. We are looking for someone who is passionate about data who can help accelerate our initiatives for data-driven business insights and decision making for our clean energy portfolio. 

 

 

 

ABOUT GENERATE CAPITAL

Generate Capital has emerged as a leader in the high-growth sustainable infrastructure market, having built a highly differentiated investment and operating platform with a track record of strong risk-adjusted returns and significant, long-term institutional investor support.  Our investment platform represents the only one-stop shop for pioneers of the Resource Revolution.  Our infrastructure business wins by delivering the most affordable, reliable and sustainable resources to customers.

The last several decades have ushered in a dramatic rise in demand for natural resources like energy, water, food, and materials. The “Resource Revolution” is about doing more with less of our natural resources, a fundamentally economic proposition proving that sustainability pays.  We believe that we can solve the world’s most pressing resource issues, not by reinventing the world, but by rebuilding it.  While some focus on finding new and revolutionary tools, we rebuild resource systems with the high-impact, economic, and proven solutions we have today.  As a result, customers, communities, innovators, developers, capital partners and the planet all win.

Up until now, new energy asset finance (a $300B annual market) has been dominated by larger-scale projects that tend to attract traditional capital sources. Generate Capital, on the other hand, is focused on being a capital partner to pioneering project developers and solution providers that are typically overlooked by traditional financiers for a variety of reasons: asset size, underwriting complexity, project duration and perceived risk. As a long-term investor with truly permanent capital, Generate Capital is the only credible long-term partner for these pioneers, and the best infrastructure provider for these resource customers.

With a $10B pipeline of projects, completed transactions totaling over $2.5B and a utility-like, pay as you go model (which we call Infrastructure-as-a-ServiceTM), Generate Capital has quickly established itself as a leader in the enormous markets of distributed energy, mobility, water and waste management.

 

What you can expect from us:

  • The ability to truly “do well by doing good”; indeed, we really are changing the world
  • An opportunity to help build a cutting edge, values-driven organization that is leading the Resource Revolution and redefining the economics of distributed, sustainable infrastructure
  • The integration of our values – integrity, collaboration, excellence, intellectual honesty, and accountability – at all levels and with our many stakeholders
  • An opportunity for entrepreneurship and leadership in building out and managing the company’s operational infrastructure and the teams to support it
  • A commitment to your professional development, ongoing learning opportunities, and overall growth as a person
  • The ability to work with a team with decades of collective experience financing and managing billions of dollars of sustainable infrastructure, leading successful startups, and growing great people
  • Competitive pay and benefits

 

 

ABOUT THE POSITION

We are looking for someone who is passionate about data, organized and detail-oriented, who loves to make chaotic situations run smoothly, and understands the value of strong processes. Data is at the center of our users as they leverage business intelligence reports to make data driven decisions.  This person will continually work to enhance, enrich, and monitor our data pipelines with strong attention to detail as we acquire data for new assets, customers, vendors. This person is passionate about the type of work Generate is doing, looking to apply their experience to help scale a growing business and drive critical internal process efficiencies and initiatives.

 

What you will be doing at Generate Capital as the Data Engineer

  • Build out and own a range of data pipelines to Extract, Transform and Load data into a central data lake.
  • Load data onto other API-driven systems
  • Ability to craft monitoring and automated auditing of data flows to ensure quality and reliability of the data acquisition process and the quality of the data itself
  • Builds data loading services for the purpose of importing data from numerous disparate data sources, inclusive of APIs, logs, relational, and non-relational database, structured and unstructured
  • Develop table structures to load data from sources ranging from REST APIs, relational databases to excel files
  • Maintain code repository and auto deployment to ETL servers via GitHub and server scripting (Bash, Ansible)
  • Oversee, design, and develop implementation patterns for both time series and batch-oriented data processing
  • Ensure data quality, data integrity, data reliability, and timeliness of all processing jobs
  • Implement and maintain ETL/Reporting standards measuring data quality, data integrity, data reliability, and timeliness and alerting whenever there is an issue
  • Develop table structures to load data from sources ranging from REST APIs, traditional databases to excel files

 

Candidate qualifications & core characteristics:

  • A demonstrated passion for, or commitment to, our mission
  • Bachelor's degree in computer science or related field preferred; or the equivalent years of relevant work experience and/or education required.
  • Strong analytics background with proven work in financial forecast analysis.   
  • Solid understanding of relational, non-relational, dimensional modeling and performance impacts
  • Minimum 3 years of hands-on experience with both SQL & scripting languages
  • Large scale data, high efficiency data extraction and transformation into a data warehouse (Snowflake, Redshift, Teradata, Netezza, Hadoop) preferred but not required
  • Experience with solar data, energy storage, HVAC systems and/or controls software/hardware preferred but not required
  • Financial forecasting techniques including automated baseline/ongoing testing forecasting preferred but not required
  • Strong analytical and organizational skills with strong attention to detail
  • Strategic thinker with the ability to interpret opportunities for improvement from data/reports to team actions
  • Coachable, dedicated to improvement and willing to be a team mentor
  • Hands on and effective in a fast moving, creative environment
  • Ability to process questions, problems, comments, objections and apply appropriate feedback, professionally and quickly
  • Possesses strong leadership and relationship building skills combined with a collaborative personal style with desire and drive for results.
  • Excellent interpersonal communication and collaboration skills, both written and verbal
  • Team-oriented, self-motivated, success-driven, roll-up-your-sleeves attitude
  • Strong intellectual curiosity and demonstrated ability to understand and question the data
  • Healthy skepticism to challenge the status quo so we can improve
  • Unimpeachable integrity and glowing references
  • High level of self-awareness and humility, with excitement about confronting uncomfortable situations or new challenges
  • Entrepreneurial spirit: flexibility, comfort with risk, recognition that “perfect can be the enemy of the good”

 

Generate Capital is an equal opportunity employer and does not discriminate against otherwise qualified applicants on the basis of actual or perceived race, color, creed, religion, ancestry, citizenship status, age, sex, marital status, sexual orientation, national origin, disability or handicap, veteran status, or any other characteristic protected by applicable federal, state, or local laws.

Similar jobs





Founded in 2014, Generate builds, owns, and operates sustainable infrastructure to deliver affordable and reliable resource solutions for companies, governments, ...

View Company Profile

Similar jobs