MUST:
- 5+ years in a data analyst role
- Very strong with SQL- must understand CTEs and what those are, recursive query patterns, understanding performance is paramount, knowing sql well enough to tune equerries to optimize perofmranc eand make quqeries easy to read, just because claude spat something out, double check
- Strong experience taking business requirements and then trsnalting to actionable steps for analytics engineers/data engineers
- Ability to build structured business requirements based off of the data from exploratory work they’re doing, get requirements from business (i.e. tracking usage and determining if we are charging correct amount, where are we tracking usage, how can we pass the requirements of this is where the usage is, then give to data engineers so they can go get it) point to data fields and sources and be clear about what neds to happen to mov data from an area into production and own that , figure out if we already provide that data, or need to source the data
- Experience with documentation- especially with documenting assumptions and their process
- Experience working within data bricks to then send to analytics engineers for visualization layer
- Understands high level business objectives + experienced in working with very vague business requirements
- Experience working with a back log
- Experience working with data engineers and analytics engineers and giving/asking for updates from them
- Not afraid to jump in, make messy data clean + Experience being curious and proactive about the data
PLUS:
- Powerbi visualization experience or visualization experience in general
- Data modeling- great not fully required
Day to day:
The Data Analyst partners with business stakeholders to understand system processes, business objectives, and the data available across various systems. They conduct data discovery and exploratory analysis to identify, validate, and clean data, determine where usage and other business-critical information is stored, and assess whether existing data meets business needs or requires additional sourcing. They translate business requirements into clear, actionable requirements for analytics and data engineering teams, identifying specific data fields, sources, transformations, and processes needed to move data into production. They use advanced SQL, including CTEs and recursive query patterns, to extract, analyze, and optimize data while ensuring queries are accurate, efficient, and maintainable. They serve as a data expert within Databricks, bringing data together for analytics and visualization while proactively investigating data quality issues and making complex or messy data usable. They manage and communicate progress against a project backlog, follow up with engineering teams on project updates, and work independently when requirements are vague or evolving. They document assumptions, processes, findings, and requirements to ensure clarity and consistency across teams. They support usage-based analytics and collaborate with Power BI and analytics teams to deliver reporting and visualizations, with hands-on Power BI experience serving as a strong plus.
Start: 1 week
Contract
Interview: 2 virtual then offer