Data Platform & Integration Engineer
New
M
McNees Wallace & Nurick LLCLegal Services
Remote - PAFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 8+ years
- Required Skills
- PythonSQLJavaSnowflakedbt
Requirements
- Bachelor's degree in Information Technology, Information Systems, Computer Science, or equivalent practical experience.
- 8+ years of experience in data engineering, systems integration, or platform development, including building enterprise 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 (e.g., Databricks, Redshift, BigQuery), including administration and security.
- Experience with enterprise integration or iPaaS platforms, ideally MuleSoft, including API design using REST, SOAP, and RAML/OAS.
- Strong understanding of API-led connectivity, reusable API design, integration architecture patterns, and application networks.
- Experience with data governance, metadata management, 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 like Apache Kafka.
- Proven ability to independently lead technology initiatives from requirements gathering through architecture and deployment.
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.
- Own the technology roadmap for continued platform maturity and evaluate emerging technologies.
View Full Description & ApplyYou'll be redirected to the employer's site
