Data Platform & Integration Engineer

McNees Wallace & Nurick LLC•Remote - PA, PA

7d•Remote

About The Position

McNees Wallace & Nurick LLC is seeking a Data Platform & Integration Engineer to join their Information Technology department. This role is responsible for building the firm's modern data warehouse and integration platform from the ground up. The engineer will report to the Manager, Enterprise Applications and will own the design, implementation, and ongoing management of Snowflake as the enterprise data warehouse and MuleSoft as the enterprise integration platform. This position will also establish the firm's overall data platform, governance, and lineage strategy.

Requirements

Bachelor's degree in Information Technology, Information Systems, Computer Science, or a related field, or equivalent practical experience.
8+ years of experience in data engineering, systems integration, platform development, or related disciplines, including experience building enterprise data and integration environments from the ground up.
Strong proficiency in SQL and at least one programming or scripting language such as Python, Java, or DataWeave.
Demonstrated experience designing and implementing ETL/ELT pipelines, enterprise data models, and cloud-based data warehouse solutions.
Hands-on experience with Snowflake or comparable cloud data warehouse platforms such as Databricks, Redshift, or BigQuery, including administration, performance tuning, and role-based security.
Experience with enterprise integration or iPaaS platforms, ideally MuleSoft, including API design and development using REST, SOAP, and RAML/OAS specifications.
Strong understanding of API-led connectivity, reusable API design, integration architecture patterns, and application networks.
Experience with data governance, metadata management, data quality, data cataloging, and data lineage tools such as Snowflake Horizon Catalog, Atlan, Collibra, or Alation.
Familiarity with CI/CD pipelines, Infrastructure as Code, event-driven architecture, and messaging technologies such as Apache Kafka.
Proven ability to independently lead technology initiatives from requirements gathering through architecture, implementation, deployment, and ongoing operational support.
Exceptional analytical, troubleshooting, problem-solving, communication, and organizational skills, with the ability to effectively communicate complex technical concepts to both technical and non-technical audiences.
Demonstrated ability to manage multiple priorities, maintain detailed documentation, and handle sensitive and confidential information with discretion.

Nice To Haves

Experience with legal technology platforms such as Fulcrum, Intapp, NetDocuments, Aderant, or Elite, or experience within a professional services or legal environment, is preferred.
Relevant technical certifications, such as Microsoft Certified: Azure Data Engineer Associate, are a plus.

Responsibilities

Own the firm's enterprise data platform and data lineage strategy, including cataloging and lineage tracking across Snowflake and MuleSoft-connected systems.
Design, build, and manage the Snowflake data warehouse, including account structure, warehouse architecture, and role-based access controls.
Develop scalable ELT/ETL pipelines and data models using Snowpipe, Streams and Tasks, dbt, and related technologies to support reporting and analytics needs.
Establish Snowflake security, governance, data masking, performance tuning, and cost optimization practices.
Lead the adoption and implementation of MuleSoft, designing APIs and integration flows that connect the firm's critical business applications.
Define enterprise integration architecture standards and manage the full lifecycle of integrations, from design and development through deployment, monitoring, and support.
Develop and enforce data governance policies while monitoring data quality, security, and reliability across the organization.
Maintain documentation for data architecture, integrations, mappings, and lineage to support operational and audit requirements.
Serve as the firm's subject matter expert for data platform and integration architecture, partnering with stakeholders and leadership to translate business requirements into scalable technical solutions.
Own the technology roadmap for continued platform maturity and evaluate emerging technologies to support future growth.
Support enterprise applications, reporting, dashboards, analytics initiatives, and firmwide technology projects.
Troubleshoot and resolve platform and integration issues while serving as the primary escalation point for related technologies.