Position: Data Engineer & Architect

Company: Rupp Pfalzgraf LLC

Location: Buffalo, NY

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 and automation capabilities—including building custom SQL reports within Aderant, refining KPI dashboards, modernizing web-based solutions, and supporting AI model development.

Key Responsibilities

Data Engineering & Architecture:

• Design, implement, and optimize SQL-based reports and dashboards within Aderant and other law firm applications.
• Build scalable data pipelines, implement ETL/ELT processes, and develop secure, cloud-based data lake solutions.
• Engineer and maintain high-quality datasets to support AI models and analytics initiatives.

Web Development & Automation

• Utilize modern WebDev tools and frameworks to build internal web applications and data interfaces.
• Implement automation tools and workflows to streamline reporting, data synchronization, and business processes.
• Collaborate with IT and practice groups to integrate APIs across platforms for centralized data solutions.

Analytics & Visualization

• Enhance and maintain the Firm’s annual attorney/staff dashboards, ensuring accuracy, scalability, and actionable insights.
• Use Power BI and Python to create interactive visualizations that support strategic decision-making.
• Apply data visualization best practices to communicate insights effectively to both technical and non-technical stakeholders.

Collaboration & Problem Solving

• Partner with internal stakeholders to identify key metrics, optimize data flows, and improve data integrity.
• Troubleshoot and resolve issues related to data pipelines, system compatibility, and integration challenges.
• Work closely with external vendors to manage API integrations and ensure robust data exchange.

Required Skills and Qualifications

Education:

• Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field. Master’s degree preferred.

Experience:

• 3–7 years of professional experience in data engineering, analytics, software development, or related fields.

Technical Skills:

• Strong proficiency in SQL and Python and/or Java.
• Experience with AI tools (e.g., ML frameworks, AI model integration), WebDev tools (e.g., React, Angular, or similar), and web development best practices.
• Familiarity with data lake architectures, automation platforms, and RESTful APIs.
• Experience building ETL pipelines and optimizing database performance.
• Proficiency with Power BI or similar BI/visualization platforms.

Other Skills

• 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, attention to detail, and communication abilities.

Salary Information:

• $70,000 – $90,000 per year depending on experience and skillset.