- We are looking for an experienced Senior Data Engineer contractor to support the onboarding and integration of datasets used by Middle Office functions.
- The successful candidate will be responsible for designing, developing, and operationalizing reliable data pipelines that ingest data from multiple sources, transform and model it for downstream consumption, and make it available through scalable data platforms.
- This is a hands‑on engineering role requiring strong experience with AWS, Apache Spark/PySpark, modern data lake technologies, workflow orchestration, data modeling, and infrastructure‑as‑code/CI/CD practices.
- The ideal candidate should be comfortable taking a dataset from initial requirements and source analysis through to a production‑ready, supportable data product or pipeline.
Duration: 12 Months Contract to hire
Position Overview
- We are looking for an experienced Senior Data Engineer contractor to support the onboarding and integration of datasets used by Middle Office functions.
- The successful candidate will be responsible for designing, developing, and operationalizing reliable data pipelines that ingest data from multiple sources, transform and model it for downstream consumption, and make it available through scalable data platforms.
- This is a hands‑on engineering role requiring strong experience with AWS, Apache Spark/PySpark, modern data lake technologies, workflow orchestration, data modeling, and infrastructure‑as‑code/CI/CD practices.
- The ideal candidate should be comfortable taking a dataset from initial requirements and source analysis through to a production‑ready, supportable data product or pipeline.
Required Technical Skills
- AWS & Cloud Data Engineering: Strong hands‑on experience with AWS data and analytics services, particularly:
- AWS EMR
- AWS Glue and Glue Data Catalog
- Amazon Athena
- Amazon S3
- AWS IAM and general AWS security concepts
The candidate should understand how these services work together when designing and operating enterprise‑scale data pipelines.
Spark & Big Data:
- Expert‑level or strong hands‑on experience with:
- Apache Spark
- PySpark
- Distributed data processing
- Large‑scale dataset transformation and optimization
- Spark performance tuning and troubleshooting
- Partitioning and efficient data processing strategies
Strong experience working with modern data lake/table formats, particularly:
- Apache Hudi
- Apache Iceberg
The candidate should understand concepts such as schema evolution, partitioning, incremental processing, upserts, snapshots, and management of large analytical tables.
Python & Software Engineering: Strong programming skills in:
Candidate should consistently produce clean, modular, maintainable, and production‑quality code, with experience in:
- Object‑oriented and modular design where appropriate
- Unit and integration testing
- Error and exception handling
- Logging
- Code reviews
- Git‑based development workflows
Workflow Orchestration
Strong hands‑on experience with Apache Airflow or a comparable enterprise orchestration platform.
Candidate should be comfortable designing:
- DAGs and workflow dependencies
- Scheduling
- Retry and failure‑handling strategies
- Backfill and rerun processes
- Monitoring and alerting
- Parameterized and reusable workflows
Experience with Amazon MWAA is an asset.
Data Architecture & Modeling
Strong understanding of:
- Data modeling
- Data pipeline architecture
- Data lake architecture
- Schema design
- Data partitioning
- Incremental data processing
- Historical data management
- Data quality and reconciliation
- Data lineage
Candidate should be capable of translating business requirements into a scalable technical data model and an operationally supportable data pipeline.
Infrastructure & CI/CD
Working knowledge of modern DevOps and infrastructure‑as‑code practices, including:
- Terraform
- GitHub Actions
- Git
- CI/CD pipelines
- Automated testing and deployment
- Environment configuration and promotion
The candidate does not need to be a dedicated DevOps engineer but should be comfortable working with infrastructure definitions and deployment pipelines as part of normal data engineering development.
Preferred Qualifications
- Previous experience building data platforms or data products within financial services, asset management, capital markets, or investment management.
- Experience supporting Middle Office, investment operations, risk, portfolio management, or trading‑related datasets.
- Experience onboarding datasets from external vendors, APIs, files, databases, or enterprise data platforms.
- Understanding of data governance, lineage, entitlement, security, and audit requirements in an enterprise environment.
- Experience designing pipelines that process both historical and incremental/daily datasets.
- Experience troubleshooting and optimizing large‑scale Spark workloads.
- Experience operating production data pipelines with defined SLAs and operational support requirements.
Core Technology Stack
- Cloud: AWS
- Processing: Apache Spark, PySpark
- Data Lake / Table Formats: Apache Hudi, Apache Iceberg
- AWS Data Services: EMR, Glue, Athena, S3
- Orchestration: Apache Airflow / MWAA
- Programming: Python, PySpark
- Infrastructure as Code: Terraform
- CI/CD: GitHub Actions
- Version Control: Git
Shift:(Hybrid, 4 days onsite)
About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
AI Statement:
By applying, you acknowledge that AI‑assisted tools may be used during hiring.
IND01