23 days old

Data Engineer - Data Integration & Analytics

Addison, IL 60101
Apply Now
Apply on the Company Site
  • Job Code


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.

Essential Functions:

  1. Solution Delivery
    • Perform BI solution development activities including requirements gathering, technical specifications, ETL design & development, unit & integration testing
    • Develop & support backend data model, SSIS ETL, Application Data integration & EDI
    • Support data integration between supplier partners to provide accurate and up to date information to our internal and external customers
    • Develop and support EDI with our Customer and Suppliers on modern Jitterbit platform
    • 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

Key Competencies

Attention to Detail: Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently

Communication: Creates an atmosphere in which timely and high quality information flows smoothly both up and down the organization, inside the organization; encourages open expression of ideas and opinions. Excellent communication, presentation and relationship skills, especially the ability to articulate advanced technical topics and build consensus among business and technical constituents

Planning and Organizing: Establishes a systematic course of action for self or others to ensure accomplishment of a specific objective. Sets priorities, goals and timetables to achieve maximum productivity. Self-starter with excellent organization, administrative, interpersonal skills and project management

Problem Solving/Analytical Thinking: Builds a logical approach to address problems or opportunities or manage the situation at hand by drawing on own knowledge and experience base and calling on other references and resources as necessary.

Organizational Understanding: Understands the agendas and perspectives of others, recognizing and effectively balancing the interests and needs of one's own group with those of the broader organization. Ability to interact cross-functionally with a wide variety of IT and business stakeholders
Technical Expertise: Applies and improves extensive or in-depth specialized knowledge, skills and judgment to accomplish a result or to serve one's customers effectively. (Customers can be co-workers, peers or management as well as external consumers of a service.)

Required 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
  • Experience with ETL techniques and concepts (e.g. change data capture, slowly changing dimensions, managing exceptions, set based / bulk processing)
  • Experience in data modeling and entity relationship diagram conventions and various data modeling patterns (e.g. dimensional model, 3rd normal form)
  • Minimum of 3 years of experience with Microsoft application development with: SQL Server, SSIS, .NET, Data Modeling & Reporting & Dashboards
  • 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
  • EAI Platform Experience Jitterbit, Dell Boomi, Informatica, Mule Soft
  • Experience with Advanced Analytics Optimization, Machine Learning and/or Predictive Analytics
  • Experience with implementations of the latest technology trends

Note: This position is on-site and does not offer remote work arrangements; H1-B sponsorship or transfer is not available for this position.

To learn more about SunSource, visit our web site at 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.



Posted: 2021-07-01 Expires: 2021-08-02

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Engineer - Data Integration & Analytics

Addison, IL 60101

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast