Data Platform & Integration Engineer

Joining McNees Wallace & Nurick LLC means becoming part of a team that values your voice, your growth, and your impact on clients, colleagues, and the communities we serve. Since 1935, McNees has been a trusted, client-focused law firm delivering practical, results-driven legal solutions with integrity and a client-first philosophy. We are a full-service firm with more than 170 attorneys and 350 professionals, committed to excellence across a wide range of practice areas and industries.

At McNees, we are guided by our core values of authentic relationships, excellence, growth, and balance to foster collaboration and innovation. We support your success through mentorship, leadership development, and continuous learning opportunities. Our commitment to community runs deep, with a strong tradition of stewardship through pro bono work, charitable initiatives, and civic engagement. We also prioritize flexibility and well-being with a family-focused culture, reasonable revenue hour expectations, and technology that drives efficiency.

If you’re looking for an opportunity to do meaningful work with people who value integrity and collaboration, you’ll feel at home at McNees.

McNees, Wallace & Nurick is actively seeking a Data Platform & Integration Engineer to join our Information Technology department. At McNees, we believe our people are our greatest asset. We foster a culture of integrity, innovation, and collaboration where your ideas matter, and your contributions make a real impact.

The Data Platform & Integration Engineer is responsible for building the firm's modern data warehouse and integration platform from the ground up. Reporting to the Manager, Enterprise Applications, this individual will own the design, implementation, and ongoing management of Snowflake as the enterprise data warehouse and MuleSoft as the enterprise integration platform while establishing the firm's overall data platform, governance, and lineage strategy.

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.