Data Engineer III

Data Engineer III

Vacancy expired!

STAND 8 is a global leader providing end-to-end IT Solutions. We solve business problems through PEOPLE, PROCESS, and TECHNOLOGY and are looking for individuals to help us scale software projects designed to change the world!

Data Engineering and operations team is looking for a expert

Data Lineage Engineer. The Data Engineer Senior works with department and lines of business subject matter expert (SMEs) across the enterprise to meet departmental and organizational objectives. The engineer will follow end-to-end process standards and guidelines to ensure accurate and efficient build out of data pipeline architecture within project timeframes.

General job duties

• Create end to end lineage for various data pipelines and application ecosystem using EDC, custom lineage solutions.
• Assist in creating standards, templates and procedures for data lineage process.
• Do ETL development using Informatica IICS as required.
• Function in accordance with the Software Development Life Cycle (SDLC) framework and governance processes
• Participate in development of test plans and perform quality assurance and testing of own work and that of peers
• Function in accordance with the Software Development Life Cycle (SDLC) framework and governance processes
• Ensure work includes necessary audit controls such as Audit, Balance and Control (ABC) Framework and security controls within all design and deliverables
• Document data workflows including but not limited to: functional specs, technical specs, mapping / workflow diagram, testing plans, production "run books", training materials, etc.
• Accurately define and execute transformations, aggregations and other data manipulations to meet requirements
• Participate in development of test plans and perform quality assurance testing of own work and that of peers
• Identify development and data quality issues and work with senior team members and management to mitigate
• Conduct peer and team review sessions
• Assist in the creation of standards, templates and procedures for the department
• Contribute to the design of the data structure/data model and data flow
• Design and develop data workflows and mappings to extract, transform, and load data for purposes of analytics , reporting and integration

Experience
B.S. in Computer Science, MIS or related degree

Must Have

• Expert level EDC engineer with experience creating end to end data lineage using Informatica EDC in PROD environment.
• Solid experience in building custom lineage using various technologies such as Python, scripting languages, other programming languages.
• Hands-on development experience with ETL tools such as Informatica IICS/Powercenter and database development.
• Experience working with business stakeholders and data governance teams to integrate data lineage and business metadata.
• Experience creating standards, templates and procedures for data lineage process.
• Tools/technology used with EDC: Informatica IICS, Oracle, Snowflake, Salesforce, SAP BODS, Vendor Apps such AFS, FIS etc.

Nice to have

• Experience in building lineage using Collibra.
• Experience in building API solutions.
• Experience with other ETL tools such as SAP BODS
• Experience with Oracle, Snowflake

The US base range for this contract position is $66-$76/hour. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.