SUMMARY: The Data Engineer 2 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 improve and expand the existing data processes as needed. The 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-premises, 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
- Special projects and assignment as business dictates
- Responsible for the maintenance, creation and control of all personally identifiable information or any other information protected by any Confidentiality or Privacy Standards or Company policies that you have access or knowledge of, including but not limited to any state or federal regulations including HIPAA
SUPERVISORY RESPONSIBILITIES
- This position has no supervisory responsibilities.
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
- Must have attention to detail and focused concentration
- Must be able to learn new tasks and complete tasks independently
- Must be able to make timely decisions in the context of the workflow
- Must possess strong organizational skills, ability to multi-task and responsiveness
- Must be able to complete tasks that require a particular speed or productivity quota
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 and 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
WORK ENVIRONMENT
- The noise level in the work environment is usually moderate
- Fast paced office environment
- Ability to work nights and weekends as business dictates
CERTIFICATES, LICENSES, REGISTRATIONS
OTHER DUTIES
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
This company is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.
#LI_KG
