Analytics Engineer

Who We Are

Arcadia is a technology company empowering energy innovators and consumers to fight the climate crisis. Our software and APIs are revolutionizing an industry held back by outdated systems and institutions by creating unprecedented access to the data and clean energy needed to make a decarbonized energy grid possible.

In 2014, Arcadia set out on its mission to break the fossil fuel monopoly and since then we have been knocking down the institutional barriers to unlock decarbonization. To date, we have connected hundreds of thousands of consumers and small businesses with high-quality clean energy options. Fast forward to today, and now, we’re thinking even bigger. We have launched Arc, an industry-defining SaaS platform that empowers developers and energy innovators to deliver their own custom, personalized energy experiences, accelerating the transformation of the industry from an analog energy system into a digitized information network.

Tackling one of the world’s biggest challenges requires out-of-the-box thinking & diverse perspectives. We’re building a team of individuals from different backgrounds, industries, & educational experiences. If you share our passion for ushering in the era of the clean electron, we look forward to learning what you would uniquely bring to Arcadia!

What we’re looking for

We are seeking an Analytics Engineer to create clean, curated, organized data sets used by our Data Analysts, Data Scientists and beyond. The role will be hands-on and collaborative, building data assets that enable analysis and drive daily business decisions. Responsibilities include data modeling, transformation and documentation. You will develop a deep understanding of the business, and software engineering best practices are in your blood. We have a Lakehouse under development but are still early in the game, so there’s plenty of room to set the direction of our data ecosystem. You’ll know you have won when business partners probe on analytic methodology rather than assumptions about underlying data.

This is an exceptional opportunity for someone who relishes the chance to engage with pioneering technology, influence the development of an elite data ecosystem and work in a fast-paced environment on a high-morale, tightly-knit team.

Our core data stack makes heavy use of Snowflake and dbt, orchestrated in Prefect. Most of our wide range of data sources are loaded with Fivetran, but we use custom python when it’s the right tool for the job.

Arcadia is headquartered in Washington, DC, and open to fully remote candidates.

What you’ll do:

• Transform, test, deploy and document data to deliver clean and trustworthy data for analysis to end-users
• Collaborate with data engineers on infrastructure and data warehouse projects
• Collaborate with data scientists, data analysts, and business analysts to identify the most elegant and effective data structures to understand our constantly growing and evolving business.
• On a daily basis you would do the following:
• Data modeling: model raw data into clean, tested and reusable datasets to represent our key business data concepts. Define the rules and requirements for the formats and attributes of data.
• Data transformation: build our data lakehouse by transforming raw data into meaningful, useful data elements though joining, filtering and aggregating source data.
• Data documentation: build and maintain data documentation including data definitions and understandable data descriptions to enable broad-scale understanding of use of data.
• Apply software engineering standard methodologies to write code and coach analysts and data scientists to do the same

What will help you succeed:

Must-haves:

• 3+ years as a Data Engineer, Analytics Engineer, or a did-everything small data team member.
• An understanding of data structures and/or database design plus deep experience with SQL and Python
• Experience building data pipelines and database management including Snowflake or similar
• Ability to bring a customer focused and empathetic approach to understanding how data is used to drive the business
• Strong communication skills

Nice-to-haves:

• Undergraduate and/or graduate degree in math, statistics, engineering, computer science, or related technical field
• DBT experience
• Experience in predictive modeling and statistical analysis
• Experience with BI platforms
• Experience in the energy sector

Benefits:

• Market-based compensation (salary + equity + annual bonus)
• Healthcare, dental, vision, 401(k), and commuter benefits
• Flexible Paid Time Off (holidays, vacation, professional development, volunteer, parental leave)
• Professional development opportunities
• All-company lunches
• Free clean energy
• A chance to decarbonize and disrupt the energy sector

Eliminating carbon footprints, eliminating carbon copies.

Here at Arcadia, we cultivate diversity, celebrate individuality, and believe unique perspectives are key to our collective success in creating a clean energy future. Arcadia is committed to equal employment opportunity regardless of race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, protected veteran status, or any status protected by applicable federal, state, or local law. While we are currently unable to consider candidates who will require visa sponsorship, we welcome applications from all qualified candidates eligible to work in the United States.