RIT Solutions, Inc. · 12 hours ago
Data Engineer/Python
MALVERN, PA
Full-time
Hybrid
Senior Level, Lead/Staff
8+ years expRIT Solutions, Inc. is seeking a highly motivated Senior Data Engineer to join the Cost Basis Accounting and Method team. This role focuses on modernizing legacy mainframe batch processes to a cloud-based architecture using AWS, and involves building scalable data pipelines primarily in Python.
Staffing & Recruiting
Responsibilities
Design, develop, and maintain high-volume data transformation logic primarily using AWS Glue jobs written in Python
Develop custom code and potentially AWS Lambda functions for handling complex logic within the batch processes
Utilize PySpark and SQL for data querying, filtering, and manipulation against various data stores, including modernized data sources and initial DB2 tables
Collaborate with internal mainframe experts to understand legacy system logic and implement requirements for the modernized batch processes
Engage with the build and deployment pipeline, demonstrating a strong understanding of DevOps concepts and proficiency with Git/GitHub
Handle data ingestion from multiple sources, including various vendors, flat files, CSVs, and APIs
Work closely with a dedicated Tech Lead, but be prepared to operate with a high degree of independence
Qualification
Required
AWS database experience, e.g. Aurora, Redshift
Proven experience as a Data Engineer with a strong focus on data pipelines and ETL/ELT processes
Expertise in Python (estimated 80–90% of development work)
Experience with AWS services, particularly Glue and Lambda
Proficiency in PySpark and SQL for data handling and querying
Familiarity with DevOps practices and the Git/GitHub development workflow
Experience in dealing with varied data formats and sources (vendors, files, APIs)
Preferred
Some experience with Java batch processes (estimated 10–20% of development work) is a plus
Prior experience with or understanding of mainframe concepts is a good-to-have but not a requirement
Company
RIT Solutions, Inc.
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection).
201-500 employees
H1B Sponsorship
RIT Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase