Contractor Senior Software Engineer (ETL Platform Modernization)

Blue Mountain Quality Resources

Job Location:

State College, PA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Were 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 Youll Build

Youll 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# 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

Required Experience:

Senior IC