Position: Data Engineer & Architect

Firm: Rupp Pfalzgraf LLC

Location: Buffalo, NY

Position Type: Full-time, On-site

Overview: Rupp Pfalzgraf LLC is a full-service law firm seeking a highly skilled Data Engineer & Architect to join our team. This role is pivotal as we expand our data capabilities, including building custom SQL reports within Aderant, refining KPI dashboards, and supporting Firm AI model development. The ideal candidate will leverage expertise in SQL, Python, Java, Power BI, and data engineering principles to drive data-driven decision-making and enhance operational efficiencies across the firm.

Key Responsibilities:

• Design, implement, and optimize SQL-based reports and dashboards within Aderant and other law firm applications.
• Collaborate with IT and practice groups to build scalable data pipelines and secure cloud-based solutions.
• Engineer high-quality datasets and optimize ETL processes to support AI model development.
• Enhance and maintain the firm’s annual attorney/staff dashboards, ensuring accuracy, scalability, and actionable insights.
• Utilize Power BI and Python to create interactive visualizations that support strategic decision-making.
• Work with internal stakeholders to identify key metrics, streamline data reporting, and improve data accuracy.
• Troubleshoot and resolve issues related to data integrity, pipeline failures, and system compatibility.
• Work with Firm vendors to facilitate API syncs amongst platforms to create centralized solutions.
• Leverage data visualization best practices to effectively communicate analytical insights to technical and non-technical stakeholders.

Required Skills and Qualifications:

• Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field. Master’s degree preferred.
• Minimum of 3 years of experience in data analysis, engineering, programming, and science or a related field.
• Proficiency in SQL, Python, Java, and Power BI.
• Experience with data engineering concepts, ETL pipelines, and database optimization.
• Familiarity with legal industry software like Aderant, NetDocuments, and SharePoint is a plus, but not required.
• Strong analytical mindset with the ability to translate business requirements into technical solutions.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills for effective collaboration with legal and administrative teams.

Preferred Qualifications:

• Experience with cloud platforms such as AWS and Azure.
• Knowledge of machine learning concepts and AI model development.
• Experience with large-scale data migration and integration projects.

Salary Range: $55,000 – $75,000

To apply, please submit your resume to careers@rupppfalzgraf.com. We look forward to reviewing your application and exploring the possibility of having you join our team at Rupp Pfalzgraf.

All qualified applicants will be afforded equal employment opportunities without discrimination because of age, race, creed, color, national origin, sexual orientation, gender identity or expression, military status, sex, disability, predisposing genetic characteristics, familial status, marital status, or domestic violence victim status.