Data Engineer

Data Engineer - Modeling and Warehouse

The Data Engineer is the subject matter expert on dimensional modeling techniques and data integration from external partners into transactional systems and through to the data warehousing and analytical platforms. The individual must be able to communicate in written form and manage workload dependencies. Strong analytical and problem-solving skills are required.

We have an exciting opportunity to hire a Data Engineer to join our already skilled data engineering team. This individual will be a part of a global team that manages Data for Koch Industries. Working closely with global colleagues, as well as customers, will provide significant global exposure.

What You Will Do

• Participate in analysis sessions to understand functional and non-functional requirements.
• Design DW tables based on dimensional modeling techniques (Kimball)
• Create/develop code and jobs in Talend while following enterprise best practices.
• Provide technical insight and develop work estimates to project planners
• Should be responsible for building extraction and mapping rules for loading data from multiple sources for data warehouse implementation based on AWS Snowflake.
• Must have strong knowledge on Data Warehousing (DWH) concepts, ETL concepts, data analysis capabilities and experience in the Talend Big-Data Real Time ETL tool.
• Work with business users to translate requirements into system flows, data flows, data mappings etc., and develop solutions to complex business problems.
• Maintain workload and time tracking within Azure DevOps.
• Development experience working in Agile Scrum environment.

Minimum Qualifications & Competencies:

• Experience as a Data engineer and ETL processes.
• Must have experience with Talend Big-Data Real Time Studio or Similar tools (InfoSphere, Informatica PowerCenter, Etc).
• Experience with Data Modeling and Data Warehouse.
• Good Knowledge of SQL.
• Well understanding of Data Analysis.
• Demonstrated ability to work in a team environment that requires quick turnaround and quality output.
• Ability to work on multiple projects simultaneously with minimal supervision.

What will put you ahead:

• Experience with Azure DevOps.
• Experience with Python (Pandas, DataFrame, Pipelines).
• Experience with a streaming Platform (Kafka, Snowflake, Kinesis).
• Knowledge of Kimball Methodology.

At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value, and get rewarded for our individual contributions. Any compensation range provided for a role is an estimated determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate's knowledge, skills, abilities, and geographic location. If you have questions, please speak to your recruiter about the flexibility and detail of our compensation philosophy.

As a Koch company, Koch Global Services (KGS) creates solutions spanning technology, human resources, finance, project management, and anything else our businesses need. With locations in India, Mexico, Poland, and the United States, our employees have the opportunity to make a global impact.

At Koch, employees are empowered to do what they do best to make life better. Learn how our business philosophy helps employees unleash their potential while creating value for themselves and the company.