Job Title: Data Engineer
System One is looking for an experienced Data Engineer our client. This role is to support financial reporting system in support of Oracle cloud migration initiative. The ideal candidate may work remotely, but will be required to travel to our home office in Topeka, Kansas or our New York office periodically.
The Data Engineer will design, develop, and maintain robust data systems built around Microsoft SQL Server and SSIS packages. This role focuses on optimizing database performance, building reliable ETL processes, and ensuring data quality and availability for analytics, reporting, and enterprise applications. Responsibilities include:
- Develop and fully test application enhancements from business requirements
- Perform data requirements analysis and develop mapping requirements for data sourcing, transformation and complex logic
- Defines and develops configurations, and operational/administration guidelines for data integration layer to provide it as a service to internal teams.
- Develops ETL, ELT and other service-based integration jobs as part of overall Data application delivery
- Create documentation as required by SDLC
- Communicate, escalate, and/or resolve risks and issues related to assigned projects/initiatives
- Provide operational support of data solutions, including resolution of incidents, service requests, planned support activities, and problem management
- Create and maintain change management requests and follow the change management process
- Contribute to the identification and/or delivery of related technical process improvements
- Effectively communicate with colleagues
- Design, implement, and maintain scalable data pipelines using MS SQL Server, SQL Server Integration Services (SSIS), and related tools.
- Monitor database performance, perform tuning, indexing, and query optimization to ensure system efficiency and scalability.
Who Are You? - Bachelor’s degree in computer science, Business Information Systems, or equivalent experience
- Minimum of 4-5 years of experience in software analysis, development, engineering, and support
- 4-5 years’ experience with SQL in a Relational Database Environment (Microsoft SQL preferred) with ability to code medium complexity SQL.
- 4+ years’ experience in object-oriented programming, JavaScript, or ELT/ETL tools such as SSIS
- Experience with AWS or other cloud services a plus.
- Experience working cross-functionally or across organizations.
- Experience in database design, coding standards, and DevOps for data pipelines.
- Ability to communicate openly and honestly with colleagues. Takes personal responsibility for the quality and content of the work and complies with information confidentiality requirements where applicable.
System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M-
#LI-
#DI-
Ref: #431-IT Tampa
#LI-BS1#M1