Now Hiring: Data Engineer & Architect – Buffalo

Rupp Pfalzgraf LLC


Date: 16 hours ago
City: Buffalo, NY
Salary: $70,000 - $90,000 per year
Contract type: Full time
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.

Education

Required Skills and Qualifications

  • 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.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume