Data Engineer – Data Integration & Analytics

SunSource
Addison IL
8 days ago
SunSource
SunSource
sun-source.com

Job Description

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 databases, including an understanding of SQL Server Database Management Systems (RDBMS) concepts
    • Minimum of 2 years of experience working in a large organization
    • Able to work flexible hours as required by business priorities
    • Limited travel may be required

Preferred Qualifications

  • Relevant certifications preferred
    • Power BI Experience
    • Experience with Advanced Analytics – Optimization, Machine Learning and/or Predictive Analytics
    • Experience with the latest technology trends in cloud data platforms.
    • Experience with SSIS based ETL
Would you rather see what we have to offer? Check out SunSource Core Competency video www.sun-source.com
We are an Equal Employment Opportunity Employer M/F/V/D. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status. eeopost.pdf (dol.gov). WE PARTICIPATE IN E-E-Verify Participation Poster English and Spanish . If you are an individual with a disability and require an accommodation to complete the application process, please contact recruiting@sunsrce.com to request reasonable accommodation. Only requests for accommodations in the application process will be returned. Sun-Source \u007C Privacy Policy

Visit Original Source:

http://www.indeed.com/viewjob
why ?Jumpstart your career with our tech sales bootcamp!
Free Guides, Videos and Podcasts
  • The Biggest Red Flags in Sales Interviews: A Complete Guide
    The Biggest Red Flags in Sales Interviews: A Complete Guide
  • Career Change Guide: Breaking Into a Career in Tech Sales
    Career Change Guide: Breaking Into a Career in Tech Sales
  • How to Find a Second Career in Tech Sales
    How to Find a Second Career in Tech Sales
  • SDR Interviews | How to Land the Interview and Stand Out in the Process
    SDR Interviews | How to Land the Interview and Stand Out in the Process
  • See More…

Other Jobs

Vidyard

Senior Data Developer, Data Platform

Vidyard

Vidyard is the video platform that's built for business. Sales reps, marketers, and corporate communicators use Vidyard to record and share videos that grab attention and deliver their message

 
Remote / Remote
StackAdapt

We have an exciting opportunity in the newly formed Enterprise Data Office (EDO) with its mandate to serve the business leaders and stakeholders at StackAdapt with trusted data, standard reporting fra

 
CA
Trusscore

Who we are Trusscore is a material science company focused on developing sustainable building materials. We're starting a journey to change the way people build buildings and the environmental foo

 
Calgary AB