Data Analyst

Ethereum Technologies; Alexandria (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

Ethereum Technologies seeks an experienced Data Analyst with strong SQL, Databricks, Spark SQL, Power BI and Python skills. The role focuses on analytics, dashboard development, KPI reporting, and data validation across loyalty and rewards programs.

You will partner with product and data teams to define KPIs, build analytics tables, and deliver dashboards and ad hoc insights to drive business impact.

Qualifications

• 3-5+ years of data analytics or BI experience, including 3+ years SQL on large datasets.
• 3+ years advanced SQL (joins, window functions) on cloud platforms (Databricks, Spark SQL).
• Experience building dashboards in Power BI (or Tableau) for stakeholders.
• Hands-on analysis of customer, transaction, or digital product data to measure KPIs.
• Proficient Python (pandas) for data analysis.
• Strong data quality, data reconciliation, and discrepancy explanation.
• Excellent written and verbal communication across product, engineering, and data teams.

Responsibilities

• Serve as the embedded analyst for the Rewards and Fuel Loyalty product teams; define KPIs and launch measurement.
• Build and maintain master analysis tables in Databricks tracking loyalty, deals, rewards, and fuel program performance.
• Create and maintain Power BI dashboards and recurring reports for member activity and promotions.
• Measure the performance and incrementality of offers using test vs. control methods.
• Analyze app engagement data (Mixpanel) alongside transaction data and identify data gaps.
• Deliver ad hoc deep dives and present concise findings to product and leadership.

Skills

SQL

Databricks

Spark SQL

Power BI

Python

Data analytics

KPI reporting

Data validation

Cross-team communication

Education

Bachelor's degree

Master's degree (desired)

Tools

Databricks notebooks

Git

Mixpanel

Amplitude

Power BI

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary

Our client is Seeking an experienced Data Analyst with strong expertise in SQL, Databricks, Spark SQL, Power BI, and Python. The ideal candidate should have hands‑on experience in data analytics, dashboard development, customer and transaction analytics, KPI reporting, and data validation. Experience with product analytics, A/B testing, loyalty and rewards programs, and tools such as Mixpanel or Amplitude is preferred. Strong analytical, problem‑solving, and communication skills are required.

Required Skills & Experience

• 3-5+ years of experience in data analytics, product analytics, or business intelligence, including 3+ years writing SQL against large datasets.
• 3+ years of advanced SQL experience (joins, window functions, CTEs) on large-scale cloud data platforms such as Databricks/Spark SQL.
• Experience building and maintaining dashboards and reporting in Power BI (or Tableau) for business stakeholders.
• Hands‑on experience analyzing customer, transaction, or digital product data (e.g., loyalty programs, promotions, app engagement) to measure KPIs and business impact.
• Working proficiency in Python (pandas or similar) for data analysis.
• Strong attention to data quality, with the ability to validate data, reconcile sources, and explain discrepancies.
• Strong written and verbal communication skills, with the ability to coordinate across product, engineering, and data teams and to present findings to non‑technical audiences.

Desired Skills & Experience

• Experience with product analytics tools such as Mixpanel, Amplitude, or Google Analytics.
• Experience with experimentation and incrementality measurement (A/B testing, test vs. control matching).
• Experience with loyalty, rewards, subscription, or fuel program analytics.
• Experience with Databricks notebooks/jobs and version control (Git).
• Familiarity with AI‑assisted coding tools and Jira/Agile ways of working.
• Bachelor's degree in a quantitative field (e.g., Statistics, Mathematics, Economics, Computer Science, Analytics) or equivalent experience.
• Master's degree in Analytics, Data Science, or a related field is desired, not a must have.
• Databricks or Power BI (PL-300) certification is desired, not a must have.

Preferred Industry Experience

• Convenience Retail, Grocery/QSR, Digital & Mobile Apps, Loyalty & Rewards Programs, Fuel

What You Will Be Doing

• Serve as the embedded analyst for the Rewards and Fuel Loyalty product teams: partner with product managers to define KPIs, set up launch measurement, and report on results.
• Build and maintain master analysis tables in Databricks (SQL/Python) that track loyalty, deals and rewards, and fuel program performance.
• Build and maintain Power BI dashboards and recurring reports (e.g., member activity, promotion performance) and keep metric definitions consistent.
• Measure the performance and incrementality of offers, promotions, and partner programs using test vs. control and cohort methods.
• Analyze app engagement event data (Mixpanel) alongside transaction data in the data lake; identify and elevate data gaps and quality issues before they affect reporting.
• Deliver ad hoc deep dives (e.g., customer segmentation, member activity, offer redemption) and present clear, concise findings to product and leadership stakeholders.
• Maintain the team's analytics initiatives and backlog tracker, and document tables, methodologies, and metric definitions so work is reusable.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.