Analytics Engineer III at Arcadia

Short Description:

Arcadia, a technology company focused on combating the climate crisis, seeks an Analytics Engineer III for its team in Chennai, India. The role involves crafting clean, organized data sets using SQL and dbt Core, hosted on Snowflake, to drive daily business decisions. The Analytics Engineer will collaborate with a globally distributed team, contributing to the transformation of the energy industry through cutting-edge technology. The ideal candidate brings 2+ years of analytics engineering experience, proficiency in SQL and Python, and a customer-oriented approach. Arcadia emphasizes diversity and equal employment opportunities, offering competitive compensation, a hybrid work model, and comprehensive benefits.

---

 

Company: Arcadia

Position: Analytics Engineer III 

Location: Chennai, Tamil Nadu, India

About Us: Arcadia is a technology company dedicated to empowering energy innovators and consumers in the fight against the climate crisis. Our cutting-edge software and APIs are transforming an industry hindered by outdated systems, providing unprecedented access to data and clean energy necessary for a decarbonized energy grid.

Since our inception in 2014, Arcadia has been committed to breaking the fossil fuel monopoly and dismantling institutional barriers to decarbonization. We've successfully connected hundreds of thousands of consumers and small businesses with premium clean energy options. Today, we're reaching new heights with the launch of Arc, a groundbreaking SaaS platform that enables developers and energy innovators to create personalized energy experiences, propelling the industry into a digitized information network.

To address one of the world's most significant challenges, we value diverse perspectives and out-of-the-box thinking. We are building a team that comprises individuals from various backgrounds, industries, and educational experiences. If you share our enthusiasm for ushering in the era of clean energy, we invite you to explore how you can uniquely contribute to Arcadia at www.arcadia.com.

HQ: Washington, DC

$1.5B valuation; $380M funding to date

Position Overview: We are in search of an Analytics Engineer III responsible for crafting clean, organized data sets utilized by our Data Analysts, Operations teams, and fellow Arcadians. In this hands-on and collaborative role, you will play a key part in constructing data assets that facilitate analysis and inform daily business decisions. Your contribution will involve applying engineering rigor and seasoned data modeling expertise to address complex data modeling challenges alongside our Analytics Engineering team.

Our data lake resides on Snowflake, where we construct our curated data layer, referred to as the Lakehouse. SQL in dbt, specifically dbt Core orchestrated in Prefect, forms the primary toolkit for your work.

This presents a remarkable opportunity for someone who thrives on engaging with cutting-edge technology, influencing the development of a world-class data ecosystem, and contributing to a high-morale, tightly knit team within a fast-paced environment. You will collaborate with a globally distributed team, with a central hub in Chennai, India, and key collaborators across the United States.

Responsibilities:

• Transform, test, deploy, and document data to deliver clean and reliable data for analysis to end-users.
• Collaborate with data scientists, data analysts, and business analysts to identify optimal data structures for understanding our evolving business.
• Introduce engineering best practices to our DAG and Data team, emphasizing reliability, modularity, test coverage, and documentation.
• Collaborate with data engineers to construct robust, tested, and scalable ELT pipelines.

Daily Tasks:

• Data modeling: Convert raw data into clean, tested, and reusable datasets representing key business data concepts, defining rules and requirements for data formats and attributes.
• Data transformation: Construct the data lakehouse by transforming raw data into meaningful elements through joining, filtering, and aggregating source data.
• Data documentation: Maintain comprehensive data documentation, including data definitions and descriptions, to enable widespread understanding of data usage.
• Employ engineering best practices to enhance our code base.

Qualifications: Must-Haves:

• 2+ years of experience as an Analytics Engineer or equivalent role, with a preference for dbt experience.
• 4+ years in the data space (data engineering, data science, analytics, or similar).
• Strong understanding of conceptual data modeling and data mart design.
• Proficiency in SQL and Python, coupled with experience in data structures, database design, and platforms like Snowflake.
• Customer-oriented and empathetic approach to understanding data's business impact.
• Strong communication skills.

Nice-to-Haves:

• Degree in math, statistics, engineering, computer science, or a related technical field.
• Experience in predictive modeling and statistical analysis.
• BI platform experience.
• Global, distributed team experience.
• Energy sector experience.

Benefits:

• Competitive compensation based on market standards.
• Hybrid work model with a remote-first policy.
• Flexible Leave Policy.
• Central office location in the heart of the city (if on-site presence is needed).
• Medical Insurance (1+5 Family Members).
• Annual performance cycle.
• Quarterly team engagement activities and rewards & recognitions.
• Professional growth opportunities through L&D programs.

At Arcadia, we celebrate diversity, individuality, and believe that unique perspectives are vital to our collective success in creating a clean energy future. We are committed to providing equal employment opportunities irrespective 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 requiring visa sponsorship, we welcome applications from all qualified candidates eligible to work in India. Reasonable accommodations will be provided for individuals with disabilities during the application process and employment. Please contact us to request accommodation.

Please click here to apply.