Payscale · 1 month ago
Analytics Engineer II
United States
Full-time
Remote
Mid Level
$99K/yr - $149K/yr
3+ years expPayscale is the original compensation innovator for organizations who want to scale their business with pay. They are seeking an Analytics Engineer to join their business intelligence team to build the data foundation that powers insights across the organization, bridging the gap between raw data and analytics-ready datasets while collaborating with various stakeholders.
Big DataEnterprise SoftwareHuman ResourcesSaaSSoftware
Responsibilities
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)
Qualification
Required
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
Preferred
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
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
Company
Payscale
Payscale provides compensation software, data and services to employers and free salary information and negotiation resources to individuals
501-1000 employees
Funding
Current Stage
Late StageTotal Funding
$33.39MKey Investors
Sapphire VenturesLeader VenturesTrinity Ventures
2019-04-25Acquired
2011-07-05Series Unknown· $7M
2010-10-25Series Unknown
Leadership Team
Ruth Thomas
Senior Vice President
Jeff Laliberte
Board Member
Recent News
Company data provided by crunchbase