Senior Analytics Engineer II

Compass; New York (NY); On-site; USD 102,600 - 153,900; Full time

Benefits offered by this job

Paid vacation

Medical benefits

401(k) plan

Flexible spending accounts

Life and disability insurance

Pet insurance

Parental leave

Employee Assistance Program

Commuter program

Incentive programs

Job summary

Join a forward-thinking company as an Analytics Engineer, where you will help build and enhance a scalable analytical platform. This role is pivotal in transforming raw data into actionable insights that drive operational excellence. Collaborate with cross-functional teams, mentor fellow engineers, and utilize advanced SQL and Python skills to architect data models and pipelines. Enjoy a vibrant work culture that values diversity, equity, and inclusion while providing competitive compensation and comprehensive benefits. If you're passionate about solving complex problems and making a real impact, this opportunity is for you.

Qualifications

• 6+ years of experience in analytics or technical engineering roles.
• Proven ability to translate requirements into scalable data assets.

Responsibilities

• Architect and optimize analytical solutions for data transformation.
• Collaborate with business users to gather and translate requirements.

Skills

SQL

DAX

Python

Data Modeling

Data Wrangling

Collaboration

Problem Solving

Education

Bachelor's Degree in a related field

Tools

Tableau

Power BI

Looker

Databricks

Redshift

Job description

At Compass, our mission is to help everyone find their place in the world. Founded in 2012, we’re revolutionizing the real estate industry with our end-to-end platform that empowers residential real estate agents to deliver exceptional service to seller and buyer clients.

The Data & Analytics team at Compass is responsible for enabling a data-driven culture at Compass by building a unified and scalable analytical platform that drives operational excellence, business intelligence, and data science use cases. As an Analytics Engineer on the Data & Analytics team, you will play a critical role in building and improving our analytical infrastructure. You will be at the forefront of helping turn raw data into meaningful insights for business stakeholders across the company.

We #obsess about the opportunity in front of our organization to continue building a transformative asset that unlocks insights for the company. We are looking for someone to join our team that shares in this enthusiasm and passion for solving complex problems through building scalable analytics infrastructure. To thrive in this role, you must demonstrate a strong sense of ownership and accountability for the product you deliver while operating both individually and within a team.

At Compass You Will:

• Architect and optimize analytical solutions that transform raw data into scalable data assets that enable robust self-serve reporting and business intelligence.
• Collaborate with cross-functional business users to gather functional requirements that capture the voice of the customer and translate these requirements into scalable solutions.
• Partner with data engineering teams to architect data models and pipelines that support business intelligence and data science use cases.
• Help scale and improve our existing analytics infrastructure.
• Define, design, and implement business metrics that automate operational reporting and self-serve analysis use cases.
• Develop and design artifacts (e.g., dashboards, reports) that story-tell and offer actionable insights to both technical and non-technical audiences.
• Provide technical guidance and mentorship to other Analytics Engineers on the team.

What We Are Looking For:

• 6+ years of relevant industry experience in a technical engineering and/or analytics capacity.
• Proven experience working with business users to translate requirements into scalable assets that deliver actionable insights and enable self-service analysis.
• Advanced SQL, DAX, and data modeling skills.
• Advanced programming skills in data transformation and preparation using SQL and/or Python.
• Proven experience in data wrangling and developing visualizations with tools such as Tableau, Power BI, Looker, etc.
• Experience working with cloud-based data lakehouses (e.g., Databricks, Redshift).
• Strong understanding of data modeling and software engineering best practices.
• Preferred experience with a programming language (Python, PySpark, R, Scala, etc.).
• Growth mindset, self-starter with a desire to continually learn and improve.
• Team player, willingness to work within a collaborative team environment.
• Passion for solving challenging, complex problems in a fast-paced & sometimes ambiguous environment.

Compensation:

The base pay range for this position is $102,600 - $153,900 annually; however, base pay offered may vary depending on job-related knowledge, skills, and experience. Bonuses and restricted stock units may be provided as part of the compensation package, in addition to a full range of benefits. Base pay is based on market location. Minimum wage for the position will always be met.

Perks that You Need to Know About:

Participation in our incentive programs (which may include where eligible cash, equity, or commissions). Plus paid vacation, holidays, sick time, parental leave, marriage leave, and recharge leave; medical, tele-health, dental and vision benefits; 401(k) plan; flexible spending accounts (FSAs); commuter program; life and disability insurance; Maven (a support system for new parents); Carrot (fertility benefits); UrbanSitter (caregiver referral network); Employee Assistance Program; and pet insurance.

Do your best work, be your authentic self.

At Compass, we believe that everyone deserves to find their place in the world — a place where they feel like they belong, where they can be their authentic selves, where they can thrive. Our collaborative, energetic culture is grounded in our Compass Entrepreneurship Principles and our commitment to diversity, equity, inclusion, growth, and mobility. As an equal opportunity employer, we offer competitive compensation packages, robust benefits, and professional growth opportunities aimed at helping to improve our employees' lives and careers.