Data Platform & Integration Engineer

McNees Wallace & Nurick
  • Pennsylvania
  • Remote
    9 days ago

    Job Description

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

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

    #LI-REMOTE

    #LI-DNP

    About McNees

    Headquartered in Harrisburg, Pa., McNees operates offices across Pennsylvania, Maryland, Ohio, and Washington, D.C., giving our team a broad regional footprint and diverse opportunities for collaboration. We are ranked among the NLJ 500, Best Law Firms, and Best Lawyers, and nationally recognized for excellence in areas such as construction litigation and energy law.

    Our attorneys deliver tailored strategies to businesses, individuals, and organizations across industries, including real estate, energy, healthcare, banking and finance, insurance, construction, and technology. We also have a strong presence in public sector law, advocating for clients in regulatory and legislative matters at all levels of government.

    Our services span corporate law, real estate and construction, labor and employment, litigation, tax, intellectual property, energy and environmental, estate planning, and public sector law, complemented by affiliated businesses like Apollo Communications (strategic marketing and PR), Keystone Municipal Solutions (municipal consulting), and Pine Street Land Company (title and settlement services).

    McNees offers an engaging work environment, robust opportunities for professional development, challenging and rewarding career paths, and competitive compensation. McNees is an Equal Opportunity Employer. Employment decisions are made without regard to any trait protected by law.

     

    Numbers & Facts

    LocationPennsylvania (
    Remote
    )

    Skills

    • Access Controlunmatched
    • Analysis Skillsunmatched
    • Apache Kafkaunmatched
    • Application Programming Interface (API)unmatched
    • Banking Servicesunmatched
    • Business Solutionsunmatched
    • Cataloguingunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Constructionunmatched
    • Consultingunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Corporate Lawunmatched
    • Cost Controlunmatched
    • Customer Relationsunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Documentationunmatched
    • Emerging Technologyunmatched
    • Enterprise Applicationsunmatched
    • Enterprise Architectureunmatched
    • Enterprise Data Integrationunmatched
    • Establish Prioritiesunmatched
    • Estate Planningunmatched
    • Financeunmatched
    • Governmentunmatched
    • Healthcareunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Information/Data Security (InfoSec)unmatched
    • Insuranceunmatched
    • Intellectual Property (IP)unmatched
    • Javaunmatched
    • Leadershipunmatched
    • Legalunmatched
    • Litigationunmatched
    • Marketing Strategyunmatched
    • Mentoringunmatched
    • Messaging Technologyunmatched
    • Metadataunmatched
    • Microsoft Windows Azureunmatched
    • Multitaskingunmatched
    • Operational Auditunmatched
    • Operational Supportunmatched
    • Organizational Skillsunmatched
    • Performance Tuning/Optimizationunmatched
    • Philosophyunmatched
    • Pro Bonounmatched
    • Problem Solving Skillsunmatched
    • Professional Servicesunmatched
    • Property Taxunmatched
    • Public/Media/Press/Analyst Relationsunmatched
    • Python Programming/Scripting Languageunmatched
    • Quality Monitoringunmatched
    • REST (Representational State Transfer)unmatched
    • Real Estateunmatched
    • Regulationsunmatched
    • Reporting Dashboardsunmatched
    • Requirements Managementunmatched
    • SOAP (Simple Object Access Protocol)unmatched
    • SQL (Structured Query Language)unmatched
    • Scalable System Developmentunmatched
    • Scripting (Scripting Languages)unmatched
    • Snowflake Schemaunmatched
    • Software Administrationunmatched
    • Stewardshipunmatched
    • System Integration (SI)unmatched
    • Technical Leadershipunmatched
    • Technical Supportunmatched
    • User Interface Designunmatched
    • Warehousingunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder