What are the responsibilities and job description for the Analytics Developer position at Medina McKelvey LLP?
At Medina McKelvey, we equip employers to transform legal uncertainty into stability. As a rapidly growing, full-service firm with multiple practice groups built by former Big Law attorneys with an entrepreneurial spirit, we represent clients across California and the country. But we're more than just legal professionals; we are peacemakers, providing the guidance needed to navigate the complexities of employment law with clarity and peace of mind.
We're building a team of talented individuals, from legal professionals to business service experts, who thrive on integrity, are driven to create proactive solutions, and are dedicated to genuine partnerships. Here, your contributions are valued, your growth is prioritized, and your passion for exceptional service is ignited. You'll be challenged and supported while having the opportunity to make a real impact. If you're a driven, focused professional ready to be an anchor for our clients and a vital part of our team, we invite you to explore this opportunity.
An analytics developer investigates raw case data for insights, transforms and reports on data programmatically, helps write and maintain the reporting software, and enables users with helpful, intuitive UX.
A TYPICAL DAY AS AN ANALYTICS DEVELOPER MIGHT INCLUDE
Manual explorations of raw data
- There’s no telling what you’ll find when you open raw case data—diagnose the health and completeness of incoming data and determine the feasibility of novel investigations.
Transforming and reporting on data programmatically
- Extract, clean, and standardize tabular data in SQL and Pandas and output reports using Python Jupyter notebooks.
Writing and maintaining data pipelines in Python
- Collaborate with the data team, write and maintain Python modules for data models and reports, including flexible libraries, robust testing, and detailed documentation.
Developing dashboards and web frontends
- Empower attorneys and paralegals with intuitive and flexible UI, implement feature requests, and prioritize improvements based on user feedback and testing.
WHAT WE LOOK FOR
Join our mission-driven team as an Analytics Developer, where you will deploy your analytical eye and programming skills to support our clients and help bring clarity, peace, and confidence to their most complex employment law challenges.
In this dynamic role, you will contribute to our commitment to proactive legal solutions and our culture rooted in peace, purpose, and people-first service. You’ll collaborate with a team of excellence-driven professionals who champion generosity, resilience, and high engagement in everything they do.
We are seeking a detail-oriented, highly responsive individual who thrives in a fast-paced environment and can balance multiple priorities with confidence. No two days will look the same—there is always something new to learn, explore, and solve.
As a key member of M Data, you will play a vital role in data analytics and reporting, ensuring seamless communication, preparing high-quality work product, and helping keep matters and projects moving forward with momentum.
If you enjoy meaningful work, collaborative teamwork, and being part of a people-first, excellence-focused environment, we would love to hear from you.
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.
JOB TYPE
Full-time
GROUP / DEPARTMENT
M Data
PAY RANGE
We reasonably anticipate that the starting compensation range for this position will be $80,000 to $110,000, based on factors such as qualifications, experience, and internal equity.
BENEFITS
- Comprehensive benefits program including medical, dental, vision, and more
- 401(k) retirement plan with employer contribution
- Vacation, holidays, and sick leave
- Opportunities for growth and continuing education
- Collaborative and supportive work environment
SCHEDULE
Monday to Friday
ABILITY TO COMMUTE / RELOCATE
925 Highland Pointe Dr, Roseville, CA 95768
Opportunity for hybrid work
KEYWORDS
Data Engineer, Data Analyst, Data Pipeline, Business Insights
Salary : $80,000 - $110,000