Senior Analytics Engineer

Department Technology, Data & Analytics About The Team The Data & Analytics team is Justworks' data and AI center of excellence — a connected set of functions spanning business intelligence, data science, analytics engineering, platform data/ML engineering and AI builders. We've grown significantly over the last several years and continue to build momentum across the business, leveling up maturity in how we deliver insights, govern data, and enable the company to make better decisions. Who You Are You're a data practitioner with a strong track record for designing, building, and deploying models within a medallion architecture to accelerate reporting, insights, and self‑service capabilities. You have a strong understanding of how to use data to answer business questions, and are passionate about unlocking that capability for data teams and business stakeholders across the organization. You enjoy partnering closely with stakeholders, translating their questions into trustworthy data products, and display an enthusiasm for working through complex problems together. You have a keen sense of the big picture and can effectively drive projects toward realistic, yet rewarding business outcomes. What You Will Work On Transform raw data into high‑quality data models that are easily queried and understood by various business units (e.g., Sales, Marketing, Product, Engineering, Operations) Design, build, and maintain our semantic layer using Snowflake semantic views — defining metrics, entities, and business logic so stakeholders can self‑serve trustworthy, consistently‑defined data without re‑deriving logic Partner with analysts and business teams to build and govern BI content in Tableau and Redash — curated data sources, certified dashboards, and reusable metrics — and reduce dashboard sprawl through consolidation and clear standards Partner directly with stakeholders to translate business questions into data requirements, co‑develop metric definitions, and drive adoption of governed models and dashboards Proactively identify opportunities to close gaps in reporting and insights generation by architecting new business facts and dimensions Apply effective data testing and sensitive data management strategies to ensure the quality and security of information provided to the business Level up our information design, data governance, and analytics engineering practices by defining our internal standards for lineage, maintainability, performance, and cost management Provide technical leadership and mentorship to junior and mid‑level team members, fostering best practices in data modeling, orchestration, data warehouse architecture, data privacy, and analytics enablement Perform other related duties as assigned How You Will Do Your Work In the Senior Analytics Engineer, how results are achieved is paramount for your success and ultimately result in our success as an organization. In this role, your foundational knowledge, skills, abilities and personal attributes are anchored in the following competencies: Good judgment – the exercise of critical thinking, analyzing and assessing problems and implications, identifying patterns, making connections of underlying issues, understanding risks and developing mitigation strategies, and taking ownership of the outcome. Resourcefulness – taking a can‑do approach, even in the face of obstacles and constraints by assessing what's in front of you and effectively and efficiently optimizing what you have, whether it's working on something new or thinking about how to do something better. Teamwork and communication – putting our collective best together through documentation, collaboration, relationship‑building, listening, empathy, recruiting, and evangelism. Influence and leadership – fostering a community of knowledge‑sharing, collaboration, mentorship, and forward‑thinking. Skills and knowledge – the capacity to actively learn and apply specific domain knowledge, know‑how, and best practices to continually enhance and improve. Qualifications A minimum of 5 years of professional hands‑on experience in analytics engineering, data analytics, data engineering, or a similar role Extensive experience transforming raw data into consistent, trustworthy data models for use by analytics and business stakeholders Hands‑on experience building and maintaining a semantic/metrics layer (Snowflake semantic views or equivalent) that powers self‑service analytics Demonstrated experience building and governing assets that power BI— certified data sources, dashboard design, and self‑service enablement Proven track record partnering directly with non‑technical stakeholders to define metrics, gather requirements, and drive adoption of data products Proficient in writing performant SQL and leveraging dbt for data transformation and model management Expert understanding of data warehousing concepts for analytics, including dimensional modeling, star schemas, and representation of complex business facts Experience with Python or other programming languages commonly used in data engineering Strong ability to troubleshoot, optimize, and scale data models for performance and usability Comfortable translating complex technical topics for business stakeholders Comfortable with Git, command line, and CI/CD best practices Comfortable managing workflows using Agile practices Ability to solve ambiguous problems independently Nice to Have Experience with modern data stack tools (e.g., Fivetran, dbt, Snowflake) Experience working in complex, highly dimensional data ecosystems Experience implementing sensitive data management solutions and privacy‑by‑design principles strongly preferred Technologies Used Languages : SQL, Python, Terraform Stack : Snowflake (incl. semantic views), Airflow, Fivetran, dbt, GitHub, CircleCI, Tableau, Redash, Jira The base wage range for this position based in our New York City Office is targeted at $147,000.00 - $190,000.00 per year. Diversity At Justworks Justworks is committed to maintaining a workplace where diversity of identity, culture, and life experience is the norm and is celebrated authentically and respected consistently. We are a fully inclusive employer open to all qualified applicants and provide reasonable accommodations to employees and candidates with disabilities, religious beliefs, or other covered reasons consistent with applicable laws. Equal Employment Opportunity Justworks is an equal opportunity employer open to all qualified applicants regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital or familial status, disability, pregnancy, gender identity or expression, veteran status, genetic information, or any other legally protected status. If you need a reasonable accommodation, please contact View email address on click.appcast.io. #J-18808-Ljbffr Justworks