Analytics Engineer

Paylocity is an award-winning provider of cloud-based HR and payroll software solutions, offering the most complete platform for the modern workforce. The company has become one of the fastest-growing HCM software providers worldwide by offering an intuitive, easy-to-use product suite that helps businesses automate and streamline HR and payroll processes, attract and retain talent, and build a strong workplace culture.  

While traditional HR and payroll providers automate basic HR processes such as payroll and benefits administration, Paylocity goes further by developing tools that HR and businesses need to compete for talent and deliver against the expectations of the modern workforce.

We give our employees what they need to succeed, including great benefits and perks! We offer medical, dental, vision, life, disability, and a 401(k) match, as well as perks that support you, your family, and your finances. And if it’s career development you desire, we provide that, too! At Paylocity, people matter most and have always been at the heart of our business.

There are jobs and then there are careers. Since 1997, Paylocity has been hiring talented people, giving them big challenges, and providing the right resources to help them succeed. Our award-winning culture ensures all employees feel truly welcome, appreciated, and free to be themselves. While other companies talk about it, we make it happen. Join Paylocity and launch your career!

Fully Remote (U.S. Only): This is a fully remote position, allowing you to work from home or location of record within the U.S. with no in-office requirements. You must be available five days per week during designated work hours. The work arrangement for this role is subject to change based on business needs and individual performance. This may include adjustments to on-site requirements or schedule expectations, as necessary.

Position Overview:

The Analytics Engineer serves as a bridge between data engineering and analytics, responsible for transforming raw data into reliable datasets that empower business intelligence and data-driven decision making. This role combines software engineering best practices with deep analytical expertise to build scalable data transformation workflows, implement robust data governance, and enable self-service analytics across the organization.

Responsibilities:

The below represents the primary duties of the position, others may be assigned as needed. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.   

Execution and Quality 

• Own medium to large projects independently and ensure stakeholder and business needs are met.  
• Develop data transformation pipelines using dbt (data build tool) for modeling and transformation logic. 
• Build reusable data flows and semantic layer models that enable consistent metrics and KPIs across the organization including go-to-market, operations, and product & tech. 
• Identify and solve bugs, edge cases, and pain points via code reviews and ad-hoc troubleshooting. 
• Implement CI/CD, testing, and monitoring across the data stack (e.g. from source data to dashboards/reports). 
• Be a proactive problem solver – able develop solutions with minimal guidance.  

Technical Expertise and Design 

• Write readable and maintainable code that is optimized for performance and scalability.  
• Able communicate complex ideas clearly and concisely to technical and non-technical audiences. 
• Cut through ambiguity and distinguish true needs and priorities.   
• Architect data models based on best practices (fact/dim tables, normalized/denormalized tables, OBT, SCD, etc.).  
• Create and maintain documentation for data models, business logic, and data lineage to support self-service analytics. 
• Establish data governance practices including naming conventions, model organization, and version control for analytics code. 

Collaboration, Influence, and Scope 

• Build trust with end-users to encourage data-driven decision-making.  
• Collaborate with business stakeholders to understand requirements and translate them into scalable data solutions. 
• Partner with data engineers on pipeline architecture and with analysts/data scientists on data product requirements. 
• Use their influence to drive roadmap, tooling/resourcing decisions, and advocate for best practices.  
• Work outside of their immediate team to identify dependencies and remove blockers. 

Education and Experience:

• Bachelor's degree in Computer Science, Data Science, Business Analytics, Engineering, Economics, Finance, or related quantitative discipline.  
• 3+ years of experience in analytics engineering, data engineering, or business intelligence development. 
• 2+ years of hands-on experience with dbt (data build tool) for data modeling and transformation workflows. 
• Expert proficiency in SQL for complex data transformations and analytical queries.  
• Experience with Python for data processing, automation, and scripting. 
• Knowledge of dimensional modeling, data warehouse design principles, and analytics best practices.  
• Understanding of data governance, data quality frameworks, and metadata management. 
• Familiarity with version control systems (Git) and software engineering practices. 

Preferred 

• 2+ years of experience in a stakeholder facing analytics role (data analyst, financial analyst, reporting analyst, etc.) is preferred.  
• Working familiarity with Docker, Bash, and Command Line.   
• Experience with cloud data platforms (AWS Redshift, Snowflake, BigQuery, Databricks or similar).  
• Experience with BI tools (Tableau, Looker, Power BI, Sigma) and their integration with data models. 
• Knowledge of orchestration tools (Airflow, dbt Cloud). 
• Ability to intelligently use AI tools (ChatGPT, Claude, Cursor, etc.). 

Physical requirements 

• Ability to sit for extended periods: The role requires sitting at a desk or workstation for long periods, typically 7-8 hours a day. 
• Use of computer and phone systems: The employee must be able to operate a computer, use phone systems, and type. This includes using multiple software programs and inquiries simultaneously.

Paylocity is an equal-opportunity employer. Paylocity is committed to the full inclusion of all individuals. We recruit, train, compensate, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law. At Paylocity, we believe diversity makes us better.   

We embrace and encourage our employees’ differences in age, culture, ethnicity, family or marital status, gender identity or expression, language, national origin, physical and mental ability, political affiliation, race, religion or spiritual belief, sexual orientation, socio-economic status, veteran status, and other characteristics that make our employees unique. We actively cultivate these differences through our employee resource groups (ERGs), employee experiences, perspectives, talents, and approaches to drive innovation in the software and services we provide our customers.  

We comply with federal and state disability laws and make reasonable accommodations for applicants and employees with disabilities. To request reasonable accommodation in the job application or interview process, please contact accessibility@paylocity.com. This email address is exclusively designated for such requests, aligning with federal and state disability laws. Please do not send resumes to this email address, as they will be removed.

The pay range for this position is $100,000- $130,000/yr; however, base pay offered may vary depending on job-related knowledge, skills, and experience. This position is eligible for an annual restricted stock unit grant based on individual performance in addition to a full range of benefits outlined here.  This information is provided per the relevant state and local pay transparency laws for the location in which this position will be performed. Base pay information is based on market location. Applicants should apply via www.paylocity.com/careers.