Paycor empowers leaders to develop winning teams. Our Human Capital Management (HCM) software modernizes every aspect of People Management from the way you recruit, onboard, develop, pay, and retain employees. Best of all? Our team is growing, and there’s never been a better time to join! If you love to Think Big, - Dream Big, Compete to Win, and thrive in a fast-paced environment, we want to hear from you!

Job Summary

As a Principal Data Engineer at Paycor, you will have a key role in Paycor’s success - responsible for building, managing, and monitoring the analytical data foundation for our leaders and our customers. You will ensure timely, complete, and accurate data in the Paycor Enterprise Data Warehouse with speedy and efficient data pipelines, optimized data models, and best practice approaches for logging, monitoring, and error-handling. The successful candidate will provide leadership, proactive expertise, mentoring and insight in all tasks and projects and help drive organizational improvement within a lean, fast paced and growing team. They will build and maintain database objects and procedures with cloud database tools, create and manage ELT/ETL and reverse ETL data pipelines with modern database integration tools and drive internal innovation for our cloud SAAS platform. We are looking for data engineering professionals that have successfully delivered scalable solutions in a modern DevOps managed agile software environment and been recognized as a go-to resource or industry expert. Are you ready to make a difference at Paycor?

Essential Duties and Responsibilities

- Drive design and architecture discussions

- Be a recognized expert in one or more topics - internally and externally

- Be able to contribute insightful papers/how to's, mini-trainings for our Data Community

- Represent Paycor as a featured speaker at Informatica World or Snowflake Summit

- Mentor junior team members to enable their growth

- Builds and maintains database tables, views, and procedures*

- Builds data ingestion objects and routines from multiple source systems to populate the Paycor data lake*

- Ensures accuracy of data landing at source*

- Monitors and logs the daily extraction, load, and transformation of data into the Paycor Data Warehouse*

- Identifies errors and facilitates error correction while loading data in the data warehouse*

- Collects requirements for new data sources, database fields, database views for the Paycor Data Warehouse

- Adheres to standards, naming conventions, and templates for extracting, loading, and transforming data into the Paycor Data Warehouse

- Ensures consistent alignment of data attributes and KPIs across all data sets in the Paycor Enterprise Data Marts

- Works with DevOps team to document and migrate objects to production environments

- Evaluates use of new technologies, such as integration tools, cloud database, and DevOps tools

- Ensures proper migration of work items through the task backlog

- Considers use of new connectors, APIS, or other data sharing/integration methods in ELT/ETL designs

- Independently fills gaps, learn new technology and features and mentors other team personnel

- Contributes knowledge to a center of expertise or leads internal support calls or develops process, procedure or implementation documentation and standards

- Takes initiative to drive corporate direction and proactively support and re-engineer reporting structures, needs and upcoming business requirements

- Other duties as assigned

Principal Data Engineer

Remote

Paycor empowers leaders to develop winning teams. Our Human Capital Management (HCM) software modernizes every aspect of People Management from the way you recruit, onboard, develop, pay, and retain employees. Best of all? Our team is growing, and there’s never been a better time to join! If you love to Think Big, - Dream Big, Compete to Win, and thrive in a fast-paced environment, we want to hear from you!

Job Summary

As a Principal Data Engineer at Paycor, you will have a key role in Paycor’s success - responsible for building, managing, and monitoring the analytical data foundation for our leaders and our customers. You will ensure timely, complete, and accurate data in the Paycor Enterprise Data Warehouse with speedy and efficient data pipelines, optimized data models, and best practice approaches for logging, monitoring, and error-handling. The successful candidate will provide leadership, proactive expertise, mentoring and insight in all tasks and projects and help drive organizational improvement within a lean, fast paced and growing team. They will build and maintain database objects and procedures with cloud database tools, create and manage ELT/ETL and reverse ETL data pipelines with modern database integration tools and drive internal innovation for our cloud SAAS platform. We are looking for data engineering professionals that have successfully delivered scalable solutions in a modern DevOps managed agile software environment and been recognized as a go-to resource or industry expert. Are you ready to make a difference at Paycor?

Essential Duties and Responsibilities

- Drive design and architecture discussions

- Be a recognized expert in one or more topics - internally and externally

- Be able to contribute insightful papers/how to's, mini-trainings for our Data Community

- Represent Paycor as a featured speaker at Informatica World or Snowflake Summit

- Mentor junior team members to enable their growth

- Builds and maintains database tables, views, and procedures*

- Builds data ingestion objects and routines from multiple source systems to populate the Paycor data lake*

- Ensures accuracy of data landing at source*

- Monitors and logs the daily extraction, load, and transformation of data into the Paycor Data Warehouse*

- Identifies errors and facilitates error correction while loading data in the data warehouse*

- Collects requirements for new data sources, database fields, database views for the Paycor Data Warehouse

- Adheres to standards, naming conventions, and templates for extracting, loading, and transforming data into the Paycor Data Warehouse

- Ensures consistent alignment of data attributes and KPIs across all data sets in the Paycor Enterprise Data Marts

- Works with DevOps team to document and migrate objects to production environments

- Evaluates use of new technologies, such as integration tools, cloud database, and DevOps tools

- Ensures proper migration of work items through the task backlog

- Considers use of new connectors, APIS, or other data sharing/integration methods in ELT/ETL designs

- Independently fills gaps, learn new technology and features and mentors other team personnel

- Contributes knowledge to a center of expertise or leads internal support calls or develops process, procedure or implementation documentation and standards

- Takes initiative to drive corporate direction and proactively support and re-engineer reporting structures, needs and upcoming business requirements

- Other duties as assigned

Requirements

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements are representative of the knowledge, skill, and/or ability required.

- Bachelor’s degree or higher in computer science, computer engineering or related field and 7+ years of experience. Master’s Degree in business, analytics, or computer science preferred

- At least 5-8 years of experience in SQL database development (SNOWFLAKE, MS SQL) or demonstrated breadth and depth of technical knowledge and

- Solid command of SQL programming skills

- Experience working in an agile development team

- Experience with additional programming languages (python, java)

- Experience with APIs and data formats such as JSON / AVRO

- Experience with data integration technologies (Informatica, Talend, IBM Datastage, etc.)

- Experience in Object Oriented Programming (Java, Scala, Python)

- Applied understanding of data quality, integrity and heritage, governance and security

- Demonstrated track record in delivering complex data marts and solutions

- Superior organizational skills, with a disciplined approach to implementation, support, and documentation

- Strong analytical, troubleshooting, and problem-solving skills

Join our team to make a difference in people’s lives, every day.

Paycor Total Rewards

We are proud to provide best-in-class benefits delivering a personal and professional experience that meets you where it matters most - the well-being of you and your loved ones.

Highlights include:

- A flexible virtual-first work philosophy

- An initial equity award in Restricted Stock Units (RSUs) for all new Associates and on-going award opportunities to participate in the value created through Paycor's growth

- 401(k) with $.65 match for every dollar contributed up to 6% of eligible pay

- Generous paid time off in addition to 10 paid holidays (including YOUR Holiday to celebrate a day or holiday you hold special)

- Three medical plan options – including a $0 cost option and travel & lodging support to ensure access to medical care

- Paid leave for birth parents, non-birth parents, elder caregivers, and military support

- Sabbatical opportunities for tenured Associates

- Employee Stock Purchase Plan, which enables you to buy PYCR stock at a 15% discount

- Inclusive and accessible Employee Assistance Program (EAP) to help with everyday challenges

We also offer competitive compensation determined by each individual's relevant experience, skills, and education. We anticipate the base pay for this position to be between $98,370-167,946. In addition to base pay, Paycor Associates are eligible for either a performance-based annual bonus or commission, depending on their position. If your desired salary falls outside of these rates, we hope you'll still apply as there may be other positions that better align.

For more information about our total rewards, please visit www.mypaycorbenefits.com.