Data Engineer, Kraft Analytics Group, Foxboro, MA

Posted February 20, 2020

Summary

This individual will join a fun, dynamic team to help solve integration and data problems relating to sports and entertainment. This role will integrate data from various systems and also improve and expand the existing data processes as needed. This position will be responsible for performing ETL and ELT from many disparate systems into the data warehouse and will have the opportunity to complete projects from beginning to end. The right candidate will be motivated to learn, contribute to the team and organization, and grow along with the business.

Duties and Responsibilities

• Data integration
  • Using cloud technology, combine data from various sources, cloud and on-premise, based on requirements
  • Perform data cleansing and standardization
  • Load data into a cloud data warehouse as projects dictate
  • Using the enterprise ETL tool, create, modify, and improve integration pipelines
  • Translate business requirements into data warehouse pipelines using ETL/ELT methodologies
  • Extract and load many disparate systems into a centralized data warehouse

• Business Intelligence & Data Analysis
  • Assist with preparing and loading data for Analysis and BI reports and dashboards
  • Identify Opportunities for new data sources
  • Collaborate with analysts to come up with creative solutions to data challenges

• Ongoing Responsibilities
  • Import and integrate new data sources based on business need
  • Proactively identify potential data problems, but react as needed to unexpected issues
  • Improve existing processes to streamline efforts
  • Handle multiple projects and meet deadlines
  • Monitor, schedule, and maintain existing integrations

Skills and Qualifications

• Bachelor’s degree in Information Systems, Computer Science, or related field

• 2-3 years of experience working with data using SQL or similar technology

• Very high attention to detail

• Familiarity with a data integration platform, such as Snaplogic, SSIS, or Informatica

• Familiarity with BI Visualization tools, such as Tableau

• Ability to work on multiple projects in a fast-paced environment

• Strong communication skills to all levels of technical expertise

Physical Demands

• Sitting for extended periods of time

• Dexterity of hands and fingers to operate a computer keyboard, mouse, and other computing equipment

• The employee frequently is required to talk or hear

• The employee is occasionally required to reach with hands or arms

• Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus

• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

Please reach out to Stephanie Mudgett at [email protected] if interested, or with any further questions.