Lead new development requests, enhancements, and project initiatives aimed at providing data integration solutions per business requirements. Work closely with project teams to ensure that all Data Mart / Data Warehouse, Cloud-based Data warehouse analytics needs are met in accordance with the enterprise strategic direction. The Data Integration Lead is ultimately responsible for quality delivery of all new and modified components.
location: Chicago, Illinois
job type: Contract
salary: $70 - 75 per hour
work hours: 8am to 5pm
education: Bachelors
responsibilities:
- Play a lead role in all phases of the SDLC (software development life-cycle) in areas that relate to Data Integration, ETL, Data Warehouse systems and development of data pipelines in cloud-based analytics platform. This includes shepherding requests end-to-end through the SDLC (from inception through production deployment).
- Apply DevOps to ensure the principles of automation, continuous integration, and continuous testing are efficiently applied to the DARI SDLC.
- Analyze, design, maintain and support the interfaces that feed data warehouse systems. Provide ETL expertise and be the authority for the strategy, architecture, standards, dataflow processes, maintenance, support, and data quality procedures for the back-end components.
- Participate and lead small teams in the requirements analysis, definition, planning, development and implementation of ETL projects.
- Design, development, and implementation of services that support data warehouse and data archiving strategies, as well as systems/techniques that capture/distribute information based on best practices.
- Design, enhance and support the overall ETL / Data Staging processes and architecture.
- Develop and maintain testing standards and other data quality assurance procedures.
- Create, update and maintain data mart/warehouse documentation and standard procedures, including data flow diagrams that include source/target mappings and transformation.
- Definition and oversight of data mart/warehouse operational procedures.
- Identification and promotion of data mart/warehouse best practices and patterns for data modeling, and overseeing activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
- Assist and support activities related to data modeling and design.
- Learn the business processes for which application / data integration is needed/required.
- Understand the technical aspects of application touchpoints.
- Provide input, recommendations, and resolutions for broad technical issues related to data integration.
- Review technical work of other team members for quality assurance.
- Develop and implement technical and process improvements.
- Develop unit test cases and facilitate performance testing of the developed components.
- Collaborate across teams and with external partners and vendors to integrate various services.
- Lead the data integration application upgrade process when patches or major version upgrades are necessary including the actual application of the patch/upgrade, definition of the regression testing process, orchestration of this regression testing, and remediation of issues identified during this testing process.
- Lead SSIS Offshore Managed Service Team members
- Support existing data warehouse systems including performing maintenance and resolution of production problems.
- Maintain knowledge of established service level agreements and deliver support in a manner that meets expectations.
- Participate in the implementation of processes designed to reduce the number of production incidents and improve customer satisfaction.
- Handle technically complex problems and mentor support staff through problem resolution.
- Resolve all business impacting data integration issues / defects / failures in a timely manner in support of service level agreements.
qualifications:
Education and/or Technical Experience Required (including certifications):
- Bachelor's degree or equivalent work experience required; concentrations in Data Integration/ETL, Data Modeling and Data Warehousing. Master's degree a plus.
- 10+ years of overall IT development experience with a minimum of 7+ years direct experience in ETL design, development, testing, and application support in a multi-platform enterprise environment (Windows / Unix / Oracle.)
- Minimum 6+ years direct experience in Microsoft SSIS ETL development tools, including hands-on experience using the following version of SSIS and above: SQL Server 2022 Enterprise (16.0.x) / SQL Server Data Tools - Business Intelligence for Visual Studio 2013.
- BMC Control-M scheduling experience a plus.
- A working knowledge of cloud-based data platforms (Databricks, Snowflake) experience a plus.
- Solid working knowledge of relational databases, specifically Oracle 19c, 12c and 11g. Microsoft SQL Server experience a plus.
- Experience in development of data flows using Python or similar technologies a plus.
- Data Modeling experience is strongly desired, including demonstrated experience in designing and developing logical data models using CA ERwin.
- Demonstrated experience in using query tools like Oracle SQL Developer and Toad.
- Solid knowledge of SQL, Data Mapping, Database Structures, Processes and Scripts. Knowledge of Stored Procedures and Unix Shell Scripting a plus.
- Design and perform data integration work that is inherently complex and requires advanced technical skills and knowledge of multiple data systems.
- Strong working knowledge of transactional and data warehouse systems, associated interfaces and their impact on business.
- Demonstrated knowledge of development life cycle methodologies (especially Agile), project management frameworks and software delivery tools. Jira exposure a plus.
- Java, SAP, PeopleSoft and Mainframe exposure a plus.
- Oracle PL/SQL experience.
- Asset leasing industry experience a plus, especially in the Rail sector.
skills: Minimum 6+ years direct experience in Microsoft SSIS ETL development tools, including hands-on experience using the following version of SSIS and above: SQL Server 2022 Enterprise (16.0.x) / SQL Server Data Tools - Business Intelligence for Visual Studio 2013.
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.