Associate Data Engineer

Paylocity; United States; Remote; USD 60,000 - 100,000; Full time

Job summary

Join a forward-thinking company as an Associate Data Engineer, where you will play a crucial role in designing and maintaining data architecture. This position offers the opportunity to work with cutting-edge technology, enhancing communication and collaboration within a dynamic team. You will be responsible for creating data pipelines and ensuring effective data management across various systems. If you are passionate about data-driven solutions and eager to contribute to a modern workforce, this is the perfect opportunity for you to grow and make an impact.

Qualifications

• Experience writing and refactoring performant SQL queries.
• Familiarity with data modeling tools and standards.

Responsibilities

• Design, create, deploy, and maintain data architecture.
• Create data pipelines utilizing SQL, DBT, and Snowflake.

Skills

SQL

Data Modeling

Problem Solving

Agile Methodologies

Education

Bachelor's degree in Computer Science or related field

Tools

DBT

Snowflake

Hadoop

Spark

Job description

Job Type

Full-time

Description

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.

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.

Who you are:

• 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 of 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
• 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.

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 [e-mail]. 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.