About the role
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.
What you will do:
1. 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
2.
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
3. 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
4. Special projects and assignment as business dictates
5. 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 re