Senior Analytics Engineer

Justworks•New York, NY

15d•$147,000 - $190,000•Hybrid

About The Position

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. You'll find a highly collaborative & diverse group motivated by craft, shared learning, and a genuine commitment to growing our impact for customers while evolving how we work together for our people. Come build with us! 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 you 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. As a Senior Analytics Engineer, you will be a key contributor in helping the organization derive more value from its datasets through scalable, modular design of our enterprise data models and semantic layer. You will work closely with data engineers, analysts, and business stakeholders to develop & iterate on data requirements, put data models into production, and surface them through governed BI. Your work will directly support enhanced operations and decision-making as we improve the quality of our data assets and scale of our data practice.

Requirements

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 Haves

Experience w/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

Responsibilities

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