This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/12341814

SunSource and its family of companies represent 200+ locations and 3,000+ employees making up one of North America\'s leading value-add industrial distribution companies. We provide customers with products and solutions within Fluid Power, Fluid Process, Fluid Conveyance, General Industrial Components, and Industrial Service & Repair. www.sun-source.com

\

Position Summary

SunSource is a growing company looking for a highly talented and passionate Application Developer to lead in the development and delivery of our enterprise applications to support our business strategy and growth. This position will work closely with business and technology leaders to understand the enterprise objectives and build our capabilities in Integration and Analytical applications to support Sales, Operations and Shared Services. This role will also be instrumental in advancing our Customer & Supplier Integration and Advanced Analytics capabilities to lead the industry in the utilization of data to capture market share.

\

Responsibilities & Qualifications

1. Solution Delivery

Perform BI solution development activities including requirements gathering, technical specifications, ETL design & development, unit & integration testing.

Develop and support backend data models and ETL workflows on Databricks, with a focus on building scalable data processing pipelines using Python and Spark.

Support data integration between supplier partners to provide accurate and up to date information to our internal and external customers

Review, interpret, and debug complex code. Develop maintainable code via proper structures, comments, and design

Generate automated, repeatable and stable processes to support data transformation, data load, data movement, and data synchronizations

Contribute toward the continuous improvement of our internal data capabilities

\

2. Solution Definition, Data Architecture & Strategy

Perform source data analysis data profiling, validation, conceptual and logical data modeling, etc. to determine the suitability of the source data for meeting the reporting requirements

Facilitate and lead senior IT and business teams through challenging data issues

Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business, and develop an understanding of how their data supports their business processes

Assist in developing the roadmap for Analytics and Advanced Analytics across the company to enable the business strategy

Participate in information architecture strategies such as data management, data governance, master data management and metadata management

General Education and Experience

Bachelor\'s degree in computer science, Engineering or Information Systems

5+ years of relevant experience with at least 2 years of Integration / ETL experience

Strong experience with ETL techniques, data processing concepts, and programming in Python (e.g., change data capture, slowly changing dimensions, data partitioning in Spark).

Experience in data modeling and entity relationship diagram conventions and various data modeling patterns (e.g. dimensional model, 3rd normal form)

Experience with relational databa\ \

PI254948418

\ \ SunSource is an Equal Opportunity Employer and does not discriminate against any a pplicants for employment based on their race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, physical or mental disability, genetic information, veteran status, uniformed service member status, or any other status protected by law.