Data Investigation Engineer (DataStage / BI)

About the Position

We are looking for a Middle+/Senior Data Investigation Engineer to join a long-term enterprise BI and analytics program supporting a complex data ecosystem built on IBM DataStage, SQL Server, and multiple reporting platforms. This role is focused primarily on analysis, investigation, and optimization of existing data flows and is expected to evolve into new ETL development. The ideal candidate enjoys solving complex data problems, tracing data lineage across multiple systems, understanding business logic, and working closely with both technical and business stakeholders.

Responsibilities

• Analyze, maintain, enhance, and support existing ETL/ELT processes built with IBM DataStage
• Investigate data discrepancies and identify root causes across source systems, staging environments, and reporting platforms
• Trace data lineage and understand source-to-target mappings
• Analyze business logic used in enterprise reporting and analytics solutions
• Collaborate with business users and technical teams to gather requirements and clarify data-related questions
• Propose practical improvements to existing processes and data workflows
• Develop and maintain documentation for data flows, ETL processes, and system dependencies
• Implement targeted enhancements and optimizations when required
• Support operational continuity across enterprise BI environments

Requirements

• 3+ years of hands-on experience with IBM DataStage 11.x, including Parallel Jobs, Sequence Jobs, and Server Jobs
• Strong Microsoft SQL Server knowledge, including advanced Transact-SQL development and performance optimization
• Strong understanding of data warehousing concepts, ETL/ELT processes, data modeling, and reporting ecosystems
• Experience with cloud data platforms such as Azure or AWS
• Experience analyzing and troubleshooting complex data flows across multiple systems
• Experience with source-to-target mapping and data lineage analysis
• Strong analytical and problem-solving skills
• Ability to communicate effectively with both technical and business stakeholders
• Strong Linux/Unix skills
• Upper-Intermediate (B2) or higher English

Nice to Have

• Experience with enterprise reporting platforms such as Cognos, SSRS, Power BI, Tableau, or similar BI tools
• Experience with legacy data warehouse modernization or migration initiatives
• Experience with multiple source systems and heterogeneous data environments

What We Value

We value engineers who can quickly understand unfamiliar systems, work effectively across legacy and modern technologies, and translate complex technical concepts into practical solutions.

Deep expertise in every technology is not expected. Strong analytical capability, data investigation skills, and adaptability are considered more valuable than narrow specialization in a single platform.

Working Environment

• Long-term enterprise analytics engagement
• Distributed international team
• Direct collaboration with customer stakeholders
• Opportunity to contribute to modernization initiatives alongside operational activities
• Exposure to complex BI, data warehousing, and reporting ecosystems

About the Company

ABCloudz is a global full-service company operating at the cutting edge of the latest application development and data management technologies. At ABCloudz, we believe optimal data environments are the greatest competitive advantage, and our Solutions Architects have experience with building enterprise-grade systems.

It is why our team has dedicated ourselves to helping hundreds of organizations – from start-ups to Fortune 100 companies – with architecting cloud solutions, developing web and mobile applications, optimizing complex data workloads, and managing workloads on an ongoing basis - no matter where those datasets may reside.

Growth

Join an always-growing company to operate on the cutting-edge of information technologies, cloud services, application development, and digital infrastructure. At ABCloudz, we created a perfect environment to raise your professional skills, understand new technologies, and work with world-class companies.

Expertise

Our mission is to help businesses accurately, efficiently, and reliably build, move, and manage data workloads. The trusted ABCloudz team now has hundreds of employees in five countries, including our headquarters in Redmond, Washington, and offices in San Francisco, Israel, Poland, and Ukraine.

Mission

Our expertise covers all major cloud and on-premises and databases, including Oracle, SQL Server, Azure, AWS, and GCP solutions. Our prolific developers are focused on delivering the best possible digital solutions leveraging our expertise with BI, Advanced Analytics, AI, Big Data, IoT, DevOps, and Managed Services.

Your dream job not found?

We always keep the doors open for outstanding talents. Want to work with us, but couldn't find an appropriate opening? Let us know about your passion, tell us why you stand out from the crowd and how you can make the difference working at ABCloudz. Just hit the button below to send us your resume.

Send Resume