Senior Analytics Engineer II

Compass; Dallas (TX); On-site; USD 80,000 - 115,000; Full time

Job summary

Join a forward-thinking company as an Analytics Engineer, where you will help transform raw data into meaningful insights. This role involves architecting scalable analytical solutions and collaborating with cross-functional teams to enhance the data-driven culture. You'll work with advanced tools and technologies to develop impactful dashboards and reports, guiding stakeholders in making informed decisions. If you are passionate about solving complex problems and thrive in a collaborative environment, this opportunity is perfect for you. Enjoy a vibrant work culture that values diversity and professional growth, along with a comprehensive benefits package.

Benefits

Paid vacation

Medical benefits

401(k) plan

Flexible spending accounts

Life and disability insurance

Pet insurance

Parental leave

Employee Assistance Program

Commuter program

Fertility benefits

Qualifications

• 6+ years of experience in technical engineering or analytics roles.
• Advanced skills in SQL, DAX, and data modeling.
• Experience with cloud-based data lakehouses.

Responsibilities

• Architect and optimize analytical solutions for data assets.
• Collaborate with business users to gather and translate requirements.
• Develop dashboards and reports that provide actionable insights.

Skills

SQL

Data Modeling

Python

Data Transformation

Data Wrangling

Business Intelligence

Collaboration

Problem Solving

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.

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.