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. 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!

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 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.

Your Success Profile

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.

In addition, all Justworkers focus on aligning their behaviors to our core values known as COGIS. It stands for:

• Camaraderie - Day to day you can be seen working together toward a higher purpose. You like to have fun. You're an active listener, treat people respectfully, and have a strong desire to know and help others.
• Openness - Your default is to be open. You're willing to share information, understand other perspectives, and consider new possibilities. You're curious, ask open questions, and are receptive to thoughts and feedback from others.
• Grit - You demonstrate grit by having the courage to commit and persevere. You're committed, earnest, and dive in to get the job done well with a positive attitude.
• Integrity - Simply put, do what you say and say what you'll do. You're honest and forthright, have a strong moral compass, and strive to match your words with your actions while leading by example.
• Simplicity - Be like Einstein: "Everything should be made as simple as possible, but no simpler."

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 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

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.

#LI-DG2 #LI-Hybrid