Product Analytics Data Analyst — Databricks & Power BI

Cloud Analytics Technologies, LLC; Alexandria (VA); In loco; USD 85.000 - 125.000; Tempo pieno

Descrizione del lavoro

Cloud Analytics Technologies, LLC is seeking an experienced Data Analyst with strong SQL, Databricks, Spark SQL, Power BI and Python skills to drive analytics and KPI reporting. You will work on loyalty and rewards programs, customer and transaction analytics, and dashboard development.

Ideal candidates have hands-on experience with product analytics, A/B testing, and data validation, and can communicate insights to both technical and non-technical stakeholders across product, engineering, and

Competenze

• 3-5+ years in data analytics, product analytics, or BI, including 3+ years SQL on large datasets.
• 3+ years advanced SQL (joins, window functions, CTEs) on cloud platforms such as Databricks/Spark SQL.
• Experience building dashboards and reporting in Power BI (or Tableau) for business stakeholders.
• Hands-on analysis of customer, transaction, or digital product data to measure KPIs and business impact.
• Working proficiency in Python (pandas or similar) for data analysis.
• Strong attention to data quality; validate data, reconcile sources, and explain discrepancies.
• Strong written and verbal communication to present findings to non-technical audiences.]

Mansioni

• Serve as 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.

Conoscenze

SQL

Databricks

Spark SQL

Power BI

Python

Data validation

Communication

Formazione

Bachelor's degree in a quantitative field or equivalent experience

Master's degree in Analytics/Data Science or related field (desired)

Strumenti

Databricks notebooks

Git

Mixpanel

Amplitude

Descrizione del lavoro

Cloud Analytics Technologies, LLC is seeking an experienced Data Analyst with strong SQL, Databricks, Spark SQL, Power BI and Python skills to drive analytics and KPI reporting. You will work on loyalty and rewards programs, customer and transaction analytics, and dashboard development.

Ideal candidates have hands-on experience with product analytics, A/B testing, and data validation, and can communicate insights to both technical and non-technical stakeholders across product, engineering, and