Senior Analyst Analytics Engineering (Clean Energy)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Location: Scottsdale, Arizona, United States; hybrid role requiring work in the Scottsdale office three days per week, typically Tuesday through Thursday. No visa or employment authorization sponsorship is available.
Salary: $90,000–$120,000 USD annual base range across U.S. locations, plus eligibility for an annual cash bonus.
Company
develops and operates clean-energy assets, including wind, solar, battery storage, and conventional power-generation facilities across the United States.
What you will do
- Partner with asset managers and Commercial Analytics, Market Optimization and Trading, commercial, finance, accounting, procurement, and operations stakeholders to define requirements, metrics, priorities, and deliverables.
- Develop revenue analytics, variance and trend analyses, recurring and ad hoc reports, dashboards, and self-service data applications using tools such as Hex and Streamlit.
- Build and maintain dbt staging, intermediate, and mart models in Snowflake for SAP accounting, procurement, and operations and maintenance data.
- Produce monthly curtailment reports for wind, solar, and solar-plus-storage assets; validate inputs and outputs, troubleshoot failed runs, and improve automation and documentation.
- Use Python for data preparation, analysis, automation, and lightweight forecasting, regression, time-series, trend, and anomaly-detection prototypes.
- Create documentation, metric definitions, data dictionaries, onboarding materials, data-quality checks, and access-controlled workflows for sensitive commercial and financial data.
Requirements
- Bachelor’s degree in Engineering, Computer Science, Data Science, Finance, Accounting, Economics, Business, or a related quantitative field, plus 3+ years of relevant experience in data analysis, business intelligence, or analytics engineering.
- Strong SQL skills, including joins, window functions, CTEs, and query optimization, with experience using a cloud data warehouse; Snowflake is preferred.
- Hands-on experience building and maintaining dbt models, including dbt data tests and documentation.
- Working knowledge of dimensional modeling and analytics-ready data structures.
- Proficiency in Python for data analysis and scripting, including tools such as pandas, NumPy, Matplotlib, and Plotly.
- Hands-on Git experience with branching, pull or merge requests, and code review.
- Ability to use approved AI coding tools responsibly, including reviewing, testing, validating generated code and results, and protecting sensitive data.
- Strong Excel skills; experience building dashboards and reports in a modern BI or visualization tool such as Hex, Power BI, Tableau, Spotfire, or Streamlit.
- Ability to gather requirements, clarify ambiguous requests, explain technical concepts to non-technical audiences, document data models and analyses, and manage multiple priorities independently and accurately.
- Ability to work in the Scottsdale office three days per week.
Nice to have
- Experience modeling SAP or comparable ERP data for accounting, procurement, or maintenance reporting.
- Experience with high-frequency time-series or renewable operational data, including SCADA, historian data, power curves, or availability calculations.
- Familiarity with curtailment, PPA terms, ISO/RTO markets such as CAISO or ERCOT, or LMP data.
- Experience in energy, utilities, or financial services, including energy markets, trading, asset performance, O&M, revenue, financial, or commercial analytics.
- dbt Analytics Engineering Certification.
- Exposure to Dagster, Airflow, or other workflow orchestration tools.
- Experience with forecasting or predictive modeling using tools such as scikit-learn or statsmodels.
- Experience building data applications with Streamlit.
Culture & Benefits
- Office-based collaboration, learning, community-building, company-provided meals, and events on Tuesday, Wednesday, and Thursday.
- Benefits for eligible employees working 20 or more hours per week include PTO, medical, dental and vision care, HSA and FSA options, commuter benefits, and a 401(k) with employer match.
- Additional benefits include life and accident insurance, fertility and adoption assistance, parental leave, tuition reimbursement, and benefits for domestic partnerships and same-sex marriages.
- Relocation benefits are offered.
- Clearway promotes inclusion, equal opportunity, and employment opportunities for minorities, women, individuals with disabilities, protected veterans, and military veterans.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →