Associate Data 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.

Help Paylocity enhance communication and enable employees to connect, collaborate, and create from anywhere with a position in Product & Technology!

Want to develop the strategies and principles needed to deliver compelling software? Join our team and help us enhance our all-in-one software platform, elevate our one-of-a-kind technology, and improve the employee experience.

Take your career to the next level at one of G2's Top 100 Software Companies. Explore our Product & Technology positions to see where you fit!

We are committed to building a world-class team by hiring top talent globally. To ensure compliance, we use an Employer of Record model. Our ideal candidates would be based in Guadalajara, Mexico, or the surrounding areas, with the right to work there, and be able to work within four hours of Eastern Standard Time.

As an Associate Data Engineer, you will help design, create, deploy and maintain Paylocity’s data architecture. This role will influence how the data will be stored, consumed, integrated and managed by different systems. The role will be pivotal and enabling insights, analytics and reporting across the entire Paylocity data space.

Are you the teammate we are looking for?

Who you are:

• A Data Engineer within Paylocity works closely with multiple Data Engineering teams across the globe. You’ll work closely with consuming Reporting, Analytics and Data Science teams to deliver positive customer impacts through various data pipelines.
• Focused on data-driven solutions to improve customer success through reports and analytics
• Invested in staying current in data engineering by applying new technologies and practices
• Able to work in a collaborative environment with a desire to share your ideas
• Able to work independently on modules and complete tasks with high quality, but unafraid to seek out suggestions from other team members
• Excited to work on cutting-edge technology

During the first six months, you will:

• Work on clearly defined individual tasks within a project and receive active guidance.
• Regularly write SQL Statements for selecting, filtering and joining different entities
• Create accurate and performant Tables and Views given a data model
• Create data pipelines utilizing internal data platform tooling based on SQL, DBT and Snowflake
• Demonstrate basic understanding of one or more RDBMS systems
• Regularly connect and query from one or more RDBMS system
• Demonstrate basic understanding of Object Stores (partitions, how to access, how to monitor)
• Demonstrate understanding of Organizational-wide Data Standards (including Data Modeling, Documentation, Governance and Security)
• Demonstrate understanding of team-wide Support model including monitoring dashboards
• Regularly model a given business domain utilizing Kimball methodologies
• Review PRs and ask questions or suggest changes
• Document logic and pipelines in a concise and accurate way
• Regularly participate in story planning and refinement with story definition, AC and story points
• Occasionally review design documents, provide feedback and ask clarifying questions
• Update and curate tests when introducing new functionality
• Effectively deliver well-specced individual tasks.

Required Experience:

• Bachelor's degree in a computer science, engineering, technology-related field or equivalent experience
• Organizational experience writing and refactoring performant SQL queries
• Experience with data modeling tools and standards, ETL tools, and big data technologies (e.g., Hadoop, Spark, DBT, Pig, NoSQL).
• Working experience with data lakes and data warehouses
• Should be familiar with Systems Architecture and developer tools
• Data-driven personality
• Must be able to work and communicate effectively in an agile environment
• Must be effective and creative in problem solving
• Must have experience working within a team

Paylocity is an equal-opportunity employer.