Senior Data Engineer

Back to jobs Senior Data Engineer United States Apply Who we are:  Arcadia is the global utility data and energy solutions platform. With our leading data platform, AI-powered analytics, industry expertise, and expansive partner network, we deliver solutions for every stage of the enterprise energy management lifecycle across carbon, cost, and reliability.  Arcadia’s Enterprise Energy Management Solutions are built on a foundational data platform that has been developed for over a decade and scaled across millions of customer facilities.  We transform fragmented data and siloed processes into coordinated, enterprise-wide action with comprehensive solutions, including: Utility Bill Management:  Lower utility costs and streamline bill management with automated bill payment, proactive error identification, optimized tariff structures, and budgeting & forecasting. Energy Procurement Advisory: Source clean energy through a comprehensive evaluation of supply options - including traditional retail options and onsite and offsite resources — to effectively manage risks, reduce costs, and achieve corporate sustainability goals. Sustainability Reporting:  Achieve compliance goals and track carbon emissions with standardized energy data and seamless integration with leading sustainability platforms. Tackling an enterprise client’s most critical energy 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, cost-effective electrons, we look forward to learning what you would uniquely bring to Arcadia! What we’re looking for: We are seeking a Senior Data Engineer to create clean, curated, and organized data sets used across Arcadia. The role will be hands-on and collaborative, building data assets that enable analysis and drive daily business decisions. You’ll bring an engineer’s rigor and a seasoned data modeler’s expertise to our thorniest data modeling problems, helping to lead our efforts to organize, rationalize, and produce enriched data products on our data. Your expertise will also be essential in optimizing data workflows, ensuring data integrity, and scaling our data infrastructure to support our company's growth. Our core data stack makes heavy use of Snowflake, dbt, and Fivetran for ingestion, all orchestrated within our broader AWS-based ecosystem. You’ll work primarily with SQL in dbt to build our curated data layer–we call it the Unified Data Model–and produce analytics pipelines for our derived data products–our Solutions business. We use dbt Core, orchestrated in Argo or Prefect.   What you’ll do Design, build and maintain the tooling that the wider Data team (and Arcadia as a whole) uses to interact with our data platform, including CI/CD pipelines for our data lakehouse, and unit/integration/validation testing frameworks for our data pipelines. Optimize and tune data pipelines for improved performance, scalability, and reliability, and proactively monitor pipelines to address any issues or bottlenecks. Collaborate with subject matter experts, engineers, and product managers to identify the most elegant and effective data structures to understand our constantly growing and evolving business Transform, test, deploy, and document data to deliver clean and trustworthy data for analysis to end-users Help bring engineering best practices (reliability, modularity, test coverage, documentation) to our DAG and to our Data team generally Collaborate with data engineers to build robust, tested, scalable and observable ELT pipelines. Identify and implement best practices for data ingestion, transformation, and storage to ensure data integrity and accuracy. On a daily basis, this role will perform: 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 through joining, filtering, and aggregating source data Data documentation: create and maintain data documentation including data definitions and understandable data descriptions to enable broad-scale understanding of the use of data Employ software engineering best practices to write code and coach analysts and data scientists to do the same Must-haves 4+ years as a Senior Data Engineer or Software Engineer building production data infrastructure. dbt experience is highly desirable 6+ years, cumulatively, in the data space (data engineering, data science, analytics, or similar) Expert-level understanding of conceptual data modeling and data mart design Proficiency in SQL and strong Python skills, especially in the context of data orchestration. Deep experience building data pipelines and database management including Snowflake or similar, along with familiarity with data integration patterns and ELT/ETL processes. Experience with orchestration tools like Prefect, Airflow, or Argo. Proven ability to establish and enforce AI-related engineering best practices (e.g., security, responsible code review, and prompt discipline) within data pipelines and codebase contributions, ensuring data integrity, architectural stability, and the safe use of AI-assisted tools. Ability to bring a customer-oriented and empathetic approach to understanding how data is used to drive the business Experience in technical leadership or mentorship Strong communication and collaboration skills The ability to work East Coast business hours to maximize overlap with team members in India Proven ability to solve complex problems in a dynamic and evolving environment Nice-to-haves Graduate degree in math, statistics, engineering, computer science, or related technical field Experience in predictive modeling and statistical analysis Experience with BI platforms Experience working in global, distributed teams Experience in the energy sector Benefits: "Remote first" culture - work anywhere in the US as long as you have a reliable internet connection Flexible PTO - no accrued hours and no limit on the number of vacation days exempt employees can take each year 12 annual company-wide holidays 10 days sick leave Up to 4 weeks bereavement leave 2 volunteer days off 2 professional development days off 12 weeks paid parental leave for all parents 75-95% employer cost coverage for medical, dental, and vision benefits for employees and dependents     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 opportunities 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.    We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation by emailing careers@arcadia.com prior to completing your application.   Target Annual Compensation Range for this role will be $131,250 to $235,000. There will also be a competitive benefits and equity (bonus if applicable) component to the package. The exact compensation at which this job is filled will be determined by the skills, experience, and location of the qualified candidate. Please note that we are unable to offer visa sponsorship for this position at this time. Automated Screening Technology: To ensure a fair and timely review of the high volume of applications we receive, Arcadia may utilize AI-assisted technologies to help our team identify candidates who best meet the qualification criteria for this role (based on skills, experience, and education). Please Note: Automated tools provide recommendations based on your resume content and application questions. While we may use automated screening for basic eligibility (e.g., visa status, location), employment decisions regarding qualifications are not made solely by AI without human oversight. Data Privacy & California Residents: You voluntarily provide personal information (such as your resume, contact details, and assessment responses) when submitting an application. We may use this to evaluate your candidacy and derive inferences from this data to match your profile with open roles. For California Residents: This collection is consistent with the CCPA. You have the right to request access to or deletion of your data by contacting careers@arcadia.com Thank you Create a Job Alert Interested in building your career at Arcadia? Get future opportunities sent straight to your email. Create alert Apply for this job * indicates a required field Autofill with MyGreenhouse First Name* Last Name* Preferred First Name Email* Phone Country* Phone* Location (City)* Locate me Resume/CV* Attach Attach Dropbox Google Drive Enter manually Enter manually Accepted file types: pdf, doc, docx, txt, rtf Cover Letter Attach Attach Dropbox Google Drive Enter manually Enter manually Accepted file types: pdf, doc, docx, txt, rtf Education School* Select... Degree* Select... Discipline Select... End date month Select... End date year* Add another Are you legally eligible to work in the U.S.?* Select... Will you now or in the future require visa sponsorship for employment at Arcadia?* Select... 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. Do you currently live in the U.S.?* Select... If Yes, what state do you currently live in? Select... What are your pronouns? (optional) Are you able to start work each morning no later than 9 am EST?* Select... Do you have 5+ years of experience in data engineering?* Select... Analytics Engineering should not be included in tallying your data engineering years of experience.  Scalable Data Architecture — Please select the option that most similarly matches your experience with high-volume data systems* Select... Briefly describe a technical initiative you led that required buy-in from multiple teams. What was the outcome?* AI-Driven Development — Please select the option that most similarly matches your current workflow and approach to AI tooling.* Select... Which AI development tools (e.g., Cursor, Claude Code, GitHub Copilot) are currently integrated into your daily workflow, and what is one specific way they’ve changed how you build software?* Technical Leadership — Please select the option that most similarly matches your current level of organizational impact.* Select... Arcadia Self-Identification Questions For government reporting purposes, we ask candidates to respond to the below self-identification survey. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file. As set forth in Arcadia’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law. --- If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows: A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability. A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service. An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense. An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. --- Voluntary Self-Identification of Disability Why are you being asked to complete this form? We are required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years. Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp. How do you know if you have a disability? You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to: Autism Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS Blind or low vision Cancer Cardiovascular or heart disease Celiac disease Cerebral palsy Deaf or hard of hearing Depression or anxiety Diabetes Epilepsy Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome Intellectual disability Missing limbs or partially missing limbs Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS) Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression Gender or Gender Identity* Select... Please identify your race and/or ethnicity. Please check all that apply:* Select... Veteran Service Status: * Select... Disability Status* Select... Submit application