Analytics Developer
A data engineer is needed to build data pipelines to process, transform, and analyze timekeeping and payroll data, then surface insights to non-technical users via data visualization platforms and web technologies.
Minimum qualifications:
Bachelor’s degree in Computer Science, or equivalent practical experience.
2 years of experience in Business Intelligence or Data Analytics.
2 years of experience in SQL and Data Visualization (e.g., Looker, Tableau, Power BI, Qlik, or similar technologies).
Excellent written and verbal communication skills.
Excellent time and project management skills.
Basic knowledge of Excel functions, pivot tables, and tools.
Preferred qualifications:
Experience with data warehousing or data modelling concepts.
Experience with big data technologies (e.g., Hadoop, Spark, Python, or R).
Experience with translating business requirements into business intelligence solutions.
Experience with ETL tools (e.g., Apache NiFi, Delta Live Tables, or Python).
Experience with web development frameworks (e.g., Angular, React, or Svelte).
Experience working with payroll systems (e.g., ADP, Paycom, or similar) and time-tracking platforms.
Knowledge of labor laws and payroll compliance, particularly in a legal or government-focused environment.
About the job
Medina McKelvey is a full-service employment law firm serving California employers. This position will serve its wage and hour practice group (“WHPG”), which defends California employers in wage and hour class and PAGA actions. These are the biggest risk to California employers because they often subject them to seven- to -eight figure exposure for technical violations of the California Labor Code like lunch breaks that are one minute late, rest breaks that are one minute short, or overtime rates that are $.02 low. Wage and hour cases require sophisticated data analysis of complex timekeeping, payroll, and employee census information to help our clients evaluate risk and potential exposure so they can explore all their options. Our firm is perhaps the most innovative wage and hour defense firm in the state, and we are looking to level up our data team with fellow innovators.
Responsibilities
Design, build, and maintain robust and fault-tolerant data pipelines to automate processing of payroll, timekeeping, and personnel data from varied data sources.
Standardize and enrich incoming raw data to ensure it is clean, structured, and ready for use in analysis or reporting.
Develop automated reports derived from payroll and timekeeping data, ensuring compliance with legal standards, tax law, and firm-specific policies.
Document clearly and thoroughly when developing software.
Ensure report accuracy with thorough test-driven development and continuous integration practices.
Work closely with internal litigation teams to gather requirements, identify needs, and refine data solutions.
Collaborate with data engineering team members to deliver seamless data flow across systems.
Monitor and optimize data processes to improve efficiency and scalability.
