Data Engineer

Data Engineer
IL, Buffalo Grove

Job Description

Position: Data Engineer

Location: Buffalo Grove, IL

The Data Engineer develops and maintains data architecture for the company to enable knowledge worker productivity, improve customer experience and business decision making.  The role works with solution and cloud architects, business partners, and external service providers to ensure that new capabilities comply with the data architecture and meet the data needs of the company.   

What You'll Be Doing:

  • Create the data architecture and data management strategy for the organization
  • Collaborate with the business and technical teams to maximize the value of data across the organization
  • Responsible for the development of logical data models and physical database designs applied across multiple computing environments
  • Provide oversight and direction for the design and development of the data warehouses’
  • Lead the design and implementation of new business intelligence solutions. 
  • Design and implement ETL processes
  • Ensure optimal end user performance by establishing and executing overall system performance assessment processes and associated action plans
  • Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise.
  • Define governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common reference data.

What You Need:

  • Bachelor’s degree in computer science, management information systems, or a related discipline
  • More than five years of experience in data architecture or minimum five to seven years of experience as data analyst, business intelligence analyst, or equivalent roles
  • Proven experience with ETL tools
  • Good understanding of data modeling concepts and data relationships
  • Solid experience in architecture, advanced reporting and dashboards
  • Experience working with data warehouses is required
  • Strong SQL skills and experience with performance tuning are required
  • Good understanding of data modeling concepts and data relationships
  • Excellent knowledge of SQL, R, and Python for performing data transformation and analysis
  • Understanding of cloud data warehouse technologies such as AWS RedShift or Google BigQuery

Desired Skills:

  • Expert in data architecture development, data policy formation, data asset management, data modeling, and data taxonomy creation
  • Experience with MySQL and PostgreSQL databases
  • Good knowledge of data warehouse querying tools, such as SQL, AWS QuickSight and Google Data Studio
  • Good knowledge of business intelligence tools, such as Jaspersoft and/or Tableau
  • Ability to solve any ongoing data issues that arise throughout the data processing lifecycle
  • Knowledge of various ETL techniques and frameworks, such as Matillion and/or Talend
  • Ability to perform business domain analysis and business process modeling
  • Proficient understanding of distributed computing principles
  • Experience with integration of data from multiple data sources
  • Experience with integrating machine learning toolkits into data infrastructure
  • Experience with Big Data technologies to support future growth

Apply Now