Data Engineer

Smith Arnold Partners; Buffalo (NY); On-site; USD 90,000 - 125,000; Full time

Benefits offered by this job

Meaningful impact

Career growth

Modern technology

Job summary

Smith Arnold Partners in Buffalo, NY seeks a senior data engineer to design, model, and implement scalable data storage and platform components across structured and unstructured data, supporting analytics and enterprise reporting.

You will develop pipelines, collaborate with stakeholders across domains, ensure data quality and compliance, and document data flows while partnering with teams and vendors to align with enterprise standards.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 10+ years of experience in data engineering, integration, or analytics roles.
• Strong experience in data modeling and architecture across relational and NoSQL databases.
• Advanced SQL skills and experience working with large-scale data environments.
• Experience supporting enterprise systems (ERP, CRM, billing, or asset management platforms).
• Experience working with cloud-based systems and hybrid architectures.

Responsibilities

• Design, model, and implement scalable data storage structures and data platform components for structured, semi-structured, and unstructured data, supporting transactional workloads, enterprise reporting, analytics, and hybrid cloud data solutions
• Design, develop, and maintain scalable data pipelines supporting integrations, migrations, and reporting
• Collaborate with stakeholders to define data requirements across operational, financial, and customer domains
• Develop and optimize ETL/ELT processes to ensure data reliability, accuracy, and timeliness
• Implement data quality checks, monitoring, and reconciliation processes to support compliance and audit readiness
• Support reporting and analytics initiatives by creating trusted and consumable datasets
• Document data flows, mappings, and technical designs for maintainability and transparency
• Partner with internal teams and external vendors to align solutions with enterprise standards and best practices

Skills

Data modeling

Data architecture

SQL

Cloud data platforms

ETL/ELT design

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Job description

What Employees Are Saying

• "The work you do here directly impacts business decisions-your contributions matter."
• "There's a strong culture of collaboration and continuous improvement."
• "You're given the autonomy to build solutions while being supported by a talented team."

Salary: $90,000 - $125,000 +Bonus

Why Work Here

• Meaningful Impact: Build data solutions that support enterprise-wide operations and strategy
• Career Growth: Strong focus on internal advancement and long-term development
• Modern Technology: Work with evolving data platforms, integration tools, and cloud-based architectures

Responsibilities

• Design, model, and implement scalable data storage structures and data platform components for structured, semi-structured, and unstructured data, supporting transactional workloads, enterprise reporting, analytics, and hybrid cloud data solutions
• Design, develop, and maintain scalable data pipelines supporting integrations, migrations, and reporting
• Collaborate with stakeholders to define data requirements across operational, financial, and customer domains
• Develop and optimize ETL/ELT processes to ensure data reliability, accuracy, and timeliness
• Implement data quality checks, monitoring, and reconciliation processes to support compliance and audit readiness
• Support reporting and analytics initiatives by creating trusted and consumable datasets
• Document data flows, mappings, and technical designs for maintainability and transparency
• Partner with internal teams and external vendors to align solutions with enterprise standards and best practices

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
• 10+ years of experience in data engineering, integration, or analytics roles
• Strong experience in data modeling and architecture across relational and NoSQL databases
• Advanced SQL skills and experience working with large-scale data environments
• Experience supporting enterprise systems (ERP, CRM, billing, or asset management platforms)
• Experience working with cloud-based systems and hybrid architectures

Preferred Experience/Learning Opportunities

• Experience supporting large-scale system implementations or data platform transitions
• Familiarity with modern cloud data and integration platforms
• Background in regulated industries (e.g., energy, utilities, financial services)
• Strong communication, documentation, and cross-functional collaboration skills