Analytics Engineer II

Payscale is the original compensation innovator for organizations who want to scale their business with pay and transform their largest investment into their greatest advantage. With decades of innovation in sourcing reputable data and developing AI-powered tools, Payscale delivers actionable insights that turn pay from a cost to a catalyst. Its suite of solutions — Payfactors, Marketpay, and Paycycle — empower 65% of the top companies in the U.S. and businesses like Panasonic, ZoomInfo, Chipotle, Quest Diagnostics, University of Washington, American Airlines, and TJX Companies.

Create confidence in your compensation. Payscale.

To learn more, visit www.payscale.com.

Job Summary

Payscale is seeking an Analytics Engineer to join our business intelligence team and help build the data foundation that powers insights across our organization. In this role, you'll bridge the gap between raw data and analytics-ready datasets, working closely with both technical and business stakeholders to ensure our team has reliable, well-modeled data. The ideal candidate excels at combining their technical architecting skills with an ability to use data to answer business questions. An ability to effectively support cross-functional stakeholders is critical.

As an Analytics Engineer, you'll partner with our Senior Analytics Engineer to design and build scalable data models, collaborate with our Data Engineering team to bring new data sources into our warehouse, and work alongside BI Analysts to understand and meet their analytical needs. While primarily focused on data infrastructure, this individual may also be asked to build Tableau dashboards and conduct other ad hoc analytical work.

What You'll Do

• Design and build dimensional data models in Snowflake that serve as the foundation for analytics and reporting

• Write clean, efficient, well-documented SQL to transform raw data into analytics-ready datasets

• Create reusable data models that can be leveraged across multiple use cases and business domains

• Optimize query performance and data pipeline efficiency

• Establish and maintain data modeling standards and best practices

• Advance automation efforts that help the team spend less time manipulating & validating data and more time analyzing and story telling

• Partner with business stakeholders (Sales, Customer Success, Finance, Product) to understand data needs and business logic

• Work with Data Engineering team to scope, prioritize, and integrate new data sources into the warehouse

• Collaborate with BI Analysts to understand their analytical requirements and build datasets that enable self-service analytics

• Translate business requirements into technical data specifications

• Participate in requirements gathering and solution design discussions

• Develop monitoring and alerting mechanisms to maintain integrity and reliability of the data warehouse

• Investigate and resolve data issues or errors in the data warehouse and work to solve the root cause

• Create and maintain documentation detailing data models, data dictionaries, and business logic

• Build reports and dashboards to surface key metrics to the business (e.g., Tableau)

What We're Looking For

• 3-5 years of professional experience in analytics, data engineering, or related technical role

• 1-2 years of experience in an analytics engineer, data engineer, or similar data modeling role

• Expert-level SQL skills including complex joins, CTEs, window functions, and query optimization

• Strong data modeling experience with demonstrated ability to design dimensional models

• Experience working with cloud data warehouses (Snowflake, BigQuery, Redshift, or similar)

• Proven ability to translate business requirements into technical data solutions

• Strong communication skills with ability to work effectively with both technical and non-technical stakeholders

• Analytical mindset with attention to detail and commitment to data quality

• Experience with data visualization tools and knowledge of best practices (Tableau preferred)

• Experience with Salesforce (or other CRM) and manipulating the corresponding data in a data warehouse

• Proficiency with Git (or similar version control) and CI/CD best practices

Location

Payscale has an employee centric remote-first model that provides you the flexibility to do your best work in a space that supports you, while also finding time to collaborate in person for the moments that matter.

In our remote-first model, employees can work from the location that works best for them. We do not have centralized corporate offices. Employees can choose to work from home, in company-paid co-working spaces, or any combination of the two that best suits their unique needs.

If you work from home, we recommend ensuring that you can meet the following technology, equipment and workspace requirements:

• High-Speed Internet - A stable broadband or fiber connection (satellite is highly discouraged) with a minimum speed of 100 Mbps in a dedicated workspace that has a reliable Wi-Fi signal.

• Device for Multifactor Authentication (MFA/2FA) - smartphone, tablet, etc.

When it matters (usually no more than a few times a year) we take the time to gather for in-person events.

Payscale has employees across the US, Canada, UK, The Philippines and Romania however we are currently unable to hire in the Quebec Province, Northern Ireland, and Hawaii.

Benefits and Perks

All around awesome culture where together we strive to live our 5 values:

• Data informed decision making.

• Customer first. Always.

• Succeed together.

• Relentless about results. Obsessed with excellence.

• Lead the change. Shape the standard.

An open and inclusive environment where you’ll learn and grow through programs and resources like:

• Monthly company All Hands meetings

• Regular opportunities for executive leadership exposure through things like AMAs

• Access to continued learning & development opportunities

• Our commitment to a continuous feedback culture which allows us to drive performance and career growth

• A growing network of Employee Resource Groups

• Company sponsored volunteer hours

• And more!

Our more standard benefits

• Flexible paid time off, giving you the opportunity to rest, relax and recharge away from work

• 14 Paid Company Holidays, includes 2 floating holidays (you choose!)

• A comprehensive benefits plan including medical, dental, life, vision, disability, and life insurance covered up to 100% by Payscale

• Unlimited infertility coverage benefits through our medical plans

• Additional supplemental health benefits offered to you and your family

• 401(k) retirement program with a fully vested immediate company match

• 16 weeks of paid parental leave for birthing and non-birthing parents

• Health Savings Account (HSA) options and company contributions each pay period

• Flexible Spending Account (FSA) options for pre-tax employee allocations

• Annual remote work stipend to be used on wellness or home office equipment

Equal Opportunity Employer:

We embrace equal employment opportunity. Payscale is committed to a policy of equal employment opportunity for all applicants and employees. It is our policy that employees will not be subjected to unlawful discrimination on the basis of race, color, religion, sex, age, national origin, or ancestry, physical or mental disability, veteran or military status, marital status, sexual orientation, political ideology, and any other basis protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including but not limited to: recruitment, hiring, transfers, promotions, training, discipline, termination, compensation and benefits, performance appraisals, education, and social and recreational programs.

We know the confidence gap and imposter syndrome can get in the way of meeting spectacular candidates, so please don’t hesitate to apply — we’d love to hear from you.

If you have a disability or impairment and need assistance with the application process, please email [email protected] for support.

Fraud Alert:

Payscale values security and privacy. During your job application and interview process, we will never ask for your personal banking or financial information, social security number, or other sensitive information, if you are unsure if a message is from Payscale, please email [email protected]