Job Description
It's fun to work in a company where people truly BELIEVE in what they're doing!
We're committed to bringing passion and customer focus to the business.
ABOUT AVID
Avid makes technology and collaborative tools so creators can entertain, inform, educate and enlighten the world. Our customers are the visionaries behind the most inspiring feature films, television programs, news broadcasts, televised sporting events, music recording and live concerts. To learn how Avid powers greater creators or for more information, visit www.avid.com.
JOB SUMMARY
The Data Engineer role will focus primarily on designing and implementing the data pipeline and common data models that will create the new data foundation for our enterprise analytics function. This will include building the ETL/ELT processes and orchestration layer that will drive the development of our Enterprise Data Warehouse and deliver data for analytics and systems integrations.
RESPONSIBILITIES AND DUTIES
Design, develop, implement, and support overall data eco-system which consolidates into an Enterprise Data Warehouse (EDW)
Maintain constantly evolving Data Vault data model which will serve the business data needs
Build and support ETL/ELT and data architectures within the data eco-system
Contribute to the constantly evolving Data Vault data model which will serve the business data needs
Execute and maintain standards and practices for adding new data sources into ecosystem, development, data quality, and support within the EDW
Ensure proper documentation, versioning, and data cataloging is performed for all data consumed & modelled within the EDW
Implementing comprehensive testing and monitoring processes to ensure data quality and timely error detection
QUALIFICATIONS & SKILLS
Bachelor’s degree in computer science or related field
A minimum of 3-5 years EDW design/development experience or similar type role
Extensive experience with data related programming languages (SQL, python, redshift, etc) a MUST.
Experience developing and maintaining a data warehouse environment within Snowflake.
Understanding of data warehouse architecture techniques (Data Vault 2.0 preferred)
Strong experience with ELT/ETL development and tools (DBT experience preferred)
Familiarity with Bulk Data Integrations (FiveTran experience a plus)
Understanding of data modeling practices and methodologies to deliver data for business use.
Strong analytical, troubleshooting, problem-solving and follow-through abilities, ability to navigate through ambiguous requirements
Have demonstrated verbal and written communication skills, and ability to interface with Business, Analytics, and IT organizations
Ability to work within a team and individually in a fast-paced agile environment
WHAT WE OFFER:
Here are some of the things you can count on when working for Avid:
Being part of one of the most recognized brands in the movie, music and broadcast business (when we perform, Earth shakes and superheroes fly!).
A competitive salary, bonuses and benefits (such as private medical insurance, life insurance and sport package subsidies, depending on location).
Full employment contract.
Flexible working hours.
A modern work from home policy.
Visa sponsorship and relocation support (depending on the position).
Avid is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!
We help media visionaries create art that colors our perceptions and enriches our culture. We make innovative technology and collaborative tools that inspire and spark joy so creators can entertain, inform, educate and enlighten the world. We believe in our artists. We believe in our industry leaders. And we believe in the future of entertainment. We have a rich, 30-year history of powering media and entertainment. But we know our history doesn’t determine our future, so we are always evolving, committed to making good better and better best. We make many products, but we only do one thing: maximize the mediums of amazing makers. At Avid, every minute, of every day, we are powering greater creators.