SUMMARY: The Data Engineer 2 position will be part of a fun, dynamic team that helps solve integration and data problems relating to the business of sports and entertainment. You will be a good fit for this role if you have a strong experience in data engineering practices like ETL/ELT and are interested in learning about how data plays a pivotal role in the future growth of the sports and entertainment industry. In this position, you will primarily be responsible for understanding and integrating a variety of data sources into our data warehouse using a modern data and technology stack. You will also contribute to, and possibly lead, the design of new data integration processes. As an experienced member of the team, you are expected to assist analysts and BI teams in extracting valuable business insights for our customers and to help steer the continuous improvement and expansion of existing data processes. If the intersection of sports and entertainment, business and data excite you and you are motivated to learn new skills, contribute to the building of a team and grow your career in this fun and fast paced industry, we would love to talk to you!
DUTIES AND RESPONSIBILITIES
Data Integration
Integrate data from various sources using a modern data stack
Perform data cleansing and standardization
Collaborate with client management to design new data integration pipelines
Author and improve data integration pipelines using an enterprise ETL tool
Deploy data integration pipelines using an enterprise ETL tool
Load data into a cloud data warehouse by running and maintaining data integration pipelines
Business Intelligence & Data Analysis
Assist with preparing and loading data for Analysis, BI reports and dashboards
Identify opportunities for new data sources
Identify opportunities for data process improvements
Collaborate with analysts to design creative solutions to data challenges
Ongoing Responsibilities
Import and integrate new data sources based on business need
Troubleshoot and resolve data integration issues
Proactively identify potential data problems
Identify improvements to existing processes to streamline efforts
Handle multiple projects and meet deadlines
Monitor, schedule and maintain existing integrations
Mentor junior data engineers as needed
Special projects and assignments 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
SKILLS AND QUALIFICATIONS
Bachelors degree in Information Systems, Computer Science, or related field
2-3 years of experience in using SQL for data queries and manipulation
2-3 years of experience building and maintaining ETL/ELT data pipelines
2-3 years of experience working with an Agile methodology
Very high attention to detail
Comfortable working on multiple projects in a fast-paced environment
Comfortable working in a team environment
Strong communication skills to all levels of technical expertise
Experience with a data integration platform a plus, such as Snaplogic, Airflow, SSIS, Informatica, etc.
Experience with cloud technologies a plus, such as AWS, Azure, Snowflake, etc.
Experience with BI Visualization tools a plus, such as Tableau, PowerBI, QlikView etc.
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 and dynamic work culture
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
