Mid-Level Data Engineer

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 regulations including HIPAA

What you bring:

• 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

Equal Opportunity Employer:

AspenView is proud to be an equal opportunity employer. We believe in creating an environment where all employees feel welcome, valued, and empowered to succeed. We celebrate diversity and strive to build a culture of inclusion where all individuals, regardless of their race, color, gender, gender identity or expression, sexual orientation, disability, age, or any other characteristic, can thrive. We encourage applicants from all walks of life to join our team and make a lasting impact.