Data Engineer: Data Warehouse Job in International Business Machines Corporation

Job Title: Application Developer - ETL and Data Management

Introduction:

In this role, you ll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we provide deep technical and industry expertise to a wide range of public and private sector clients globally. Our delivery centers leverage locally-based skills to help clients drive innovation and the adoption of new technologies.

A career in IBM Consulting is built on long-term relationships and close collaboration with clients across the world. You will work with leaders across industries to improve the hybrid cloud and AI journeys for some of the most innovative and valuable companies worldwide. Your ability to make a meaningful impact for clients is enabled by our strategic partner ecosystem and robust technology platforms, including Software and Red Hat.

Curiosity and a constant quest for knowledge are key to success in IBM Consulting. In your role, you ll be encouraged to challenge the norm, explore new ideas, and come up with creative solutions that result in groundbreaking impact for a wide network of clients. Our culture is built on evolution and empathy, focusing on long-term career growth and development in an environment that values your unique skills and experience.

Your Role and Responsibilities:

• ETL Workflow Development: Develop and implement ETL workflows by creating ETL jobs, and data models in datamarts using technologies such as Snowflake, DBT, Unix, and SQL.
• Batch Processing Redesign: Redesign Control M Batch processing for ETL job builds to run efficiently in a production environment.
• System Evaluation and Improvement: Study the existing system to evaluate its effectiveness and design new systems to improve workflow efficiency.
• Business Program Analysis & Support: Perform requirements identification, business program analysis, testing, and system enhancements while providing production support.
• Agile Environment: Work effectively in an Agile environment and gain familiarity with tools such as JIRA and SharePoint.
• Client Interaction: Good written and verbal communication skills are essential as you will interact directly with client counterparts to understand requirements and provide solutions.

Required Technical and Professional Expertise:

• Experience: A minimum of 3 years of experience in developing ETL applications, implementing workflows, and creating data models using Snowflake, DBT, Unix, and SQL technologies.
• Agile Environment: Strong understanding of working in an Agile environment and proficiency in tools like JIRA and SharePoint.
• Problem-Solving Skills: Ability to manage change and proven time management skills. Strong interpersonal skills to contribute effectively to team efforts.
• Continuous Learning: Stay up-to-date with technical knowledge by attending educational workshops and reviewing relevant publications.

Preferred Technical and Professional Expertise:

• ETL Development: Experience in developing triggers, functions, and stored procedures to support ETL workflows.
• Impact Analysis: Assist with impact analysis of changing upstream processes on the Data Warehouse and reporting systems.
• ETL & Reporting Support: Participate in the design, testing, support, and debugging of new and existing ETL and reporting processes.
• Data Profiling & Troubleshooting: Perform data profiling and analysis using a variety of tools, troubleshoot and support production processes, and maintain documentation.

Why IBM?

• Innovation: Be part of a team that drives global change and leverages cutting-edge technologies to solve complex problems.
• Growth: Gain access to continuous learning and career development opportunities to further your expertise in data management and cloud technologies.
• Collaboration: Work with a diverse team in a collaborative environment that values new ideas and creative solutions.
• Global Impact: Your work will contribute to improving business operations and technological advancements for clients around the world.

If you're passionate about driving innovative solutions, working with a variety of clients, and continuously evolving your skills, IBM Consulting is the perfect place for you to advance your career.