Associate Engineer Data - Remote, Mexico

Paylocity; Snowflake (AZ); Remote; USD 70,000 - 90,000; Full time

Job summary

Join a leading company as an Associate Data Engineer, where you will design and maintain data architecture, work with SQL and various data technologies, and contribute to enhancing the employee experience through data-driven solutions. Collaborate with global teams to deliver impactful analytics and reporting while utilizing cutting-edge technology. This role offers a chance to grow in a dynamic environment focused on innovation and diversity.

Qualifications

• Experience writing and refactoring performant SQL queries.
• Familiarity with data lakes and data warehouses.
• Ability to work in an agile environment.

Responsibilities

• Design, create, deploy and maintain data architecture.
• Write SQL statements for data selection and filtering.
• Create data pipelines utilizing internal data platform tooling.

Skills

SQL

Data Modeling

Problem Solving

Education

Bachelor's degree in computer science

Tools

Hadoop

Spark

DBT

Job description

Paylocity is an equal opportunity employer.

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 City, Monterrey , 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 Associate 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 customers 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 asks questions or suggests 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 preferred 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.

At Paylocity, “We” is what makes us different. We are committed to fostering aculture that honors diverse opinions, perspectives, and backgrounds, knowing that each makes us stronger andcollectively unbeatable together. We actively cultivate these differences as we engage each other in drivinginnovation in the software and services we provide our customers. Paylocity is an equal opportunityemployer.If you are an individual with a disability and you need assistance or a reasonable accommodation during theapplication process, please contact our services team at [phone].