Synthesize complex data from the Silver and Gold layers of the Medallion structure to create high-impact reports and dashboards.
Perform deep-dive analysis on specific metrics to identify trends, anomalies, and opportunities for operational improvement.
Validate data integrity across the Lakehouse, ensuring that the transition from raw data to analytical outputs is seamless and accurate.
Partner with business leaders to define Key Performance Indicators (KPIs) and build the underlying logic to track them.
Translate business requirements into technical specifications for the engineering team to ensure the data warehouse evolves with user needs.
Optimize SQL queries within Databricks to ensure dashboards and reports remain performant as data volume scales.

Requirements

5+ years of experience in Data Analytics, Business Intelligence, or Insights Engineering.
Expert-level SQL skills, specifically for data transformation, window functions, and complex joins within a data warehouse environment.
Strong proficiency with Databricks, including experience navigating notebooks and querying Delta Tables.
Experience working within a Medallion Architecture, specifically focusing on the consumption of Silver and Gold layers.
Advanced Data Visualization experience (e.g., Power BI, Tableau, or Databricks SQL Dashboards).
Proven track record of delivering insights in a fast-paced, contract-based environment.

Benefits

100% of health insurance monthly premiums for employees, and 50% for dependents.
Performance Bonus: Because exceptional work deserves exceptional rewards. Eligibility begins after 90 days.
Equity Stake: Join us in shaping the future and be rewarded for your dedication with stock options.
Continuous Growth: Up to $500 annual learning reimbursement because investing in your development is investing in our success.
Committed to Parity: We place candidates within the band based on professional experience, not negotiating skills, as part of our overall effort to avoid gender pay discrepancy.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata transformationwindow functionscomplex joinsdata visualizationPower BITableauDatabricksDelta Tablesdata analysis

Soft Skills

analytical skillscommunicationcollaborationproblem-solvingattention to detail