Talent.com
Contractor: Senior Software Engineer (ETL Platform Modernization)
Contractor: Senior Software Engineer (ETL Platform Modernization)Blue Mountain Quality Resources, LLC • State College, PA, US
Contractor : Senior Software Engineer (ETL Platform Modernization)

Contractor : Senior Software Engineer (ETL Platform Modernization)

Blue Mountain Quality Resources, LLC • State College, PA, US
5 days ago
Job type
  • Full-time
Job description

Job Description

Job Description

We're seeking a Senior Software Engineer Contractor to architect and deliver a unified ETL (Extract, Transform, Load) platform that will consolidate our existing data import tools into a single, compliant, and scalable service. This initiative is core to our mission of improving data integrity, auditability, and customer experience across our SaaS ecosystem.

What You'll Build

You'll lead the design and implementation of a next-generation unified ETL platform that includes :

  • RESTful API endpoints for data validation, transformation, and ingestion.
  • Pluggable adapter framework supporting diverse sources : IBM Maximo, SAP, Oracle, Excel, CSV, XML, JSON, and others.
  • Dynamic schema mapping engine to translate and align source data structures with our SQL Server schema.
  • Robust validation layer enforcing consistent business and data integrity rules.
  • Comprehensive audit logging to meet FDA / GxP compliance standards.
  • Resilient error handling with recovery mechanisms for partial failures and data quality issues.

Key Responsibilities

Platform Architecture & Development

  • Architect and develop a unified ETL platform replacing legacy import and migration tools.
  • Build and maintain RESTful APIs providing data validation, transformation, and ingestion capabilities.
  • Design modular, pluggable adapters for multiple data sources, including :

    • File-based : Excel, CSV, XML, JSON

  • Enterprise systems : IBM Maximo, SAP ERP / S4HANA, Oracle
  • Databases : SQL Server, Oracle, PostgreSQL, MySQL
  • APIs : GraphQL, REST, SOAP, OData
  • Implement a dynamic schema mapping and transformation engine.
  • Ensure high observability through structured logging and metrics.
  • Build intelligent error-handling patterns for diverse data source behaviors.
  • Collaborate closely with DevOps, QA, and Product teams to deliver scalable, secure, and performant solutions.

    • Required Qualifications

    Technical Expertise

  • 8+ years of professional experience in C# and .NET Core development.
  • Strong background in Azure Cloud Services (App Services, Service Bus, API Management, Key Vault).
  • Proven experience in ETL / data pipeline architecture and implementation.
  • Strong command of SQL Server and complex data transformation logic.
  • Experience with GraphQL, API design, and microservices architectures.
  • Proficiency with Docker, Redis, SonarCloud, and New Relic for monitoring and quality assurance.
  • Experience with automated testing (e.g., Playwright) and CI / CD pipelines.

    • Preferred Qualifications

  • Experience integrating SAP (BAPIs, IDocs, OData services).
  • Familiarity with IBM Maximo or other EAM / CMMS systems.
  • Understanding of message queuing and event-driven architecture patterns.
  • Knowledge of performance optimization for large-scale data ingestion.
  • Experience with enterprise ETL / mapping tools (SSIS, Talend, Informatica).
  • Background in pharmaceutical manufacturing or clinical data management.
  • Azure certification (Developer Associate or Solutions Architect).
  • Knowledge of data governance, master data management, and GxP compliance principles
    • Create a job alert for this search

    Senior Software Engineer Platform • State College, PA, US