Lead Data Engineer
The Lead Data Engineer will be responsible for overseeing a team of support engineers assisting with production and development operations for Ad Sales BI.
Responsibilities :
- Support for Prod and non-prod environments (Tidal, BODS, Kalido, BOE)
- Making sure batches run and complete daily
- Resolve and/or report issues to team
- Work with Dev team to run one off jobs in QA, UAT and Prod
- Incident resolution - tier 1 support (in the process of being revised)
- BOE and Tidal administration
- Granting access to development tools
- Migrating reports and universes from Prod to lower environments
- Performance monitoring
- Release management - weekly releases or ad hoc requests
- Audit documentation - quarterly
- User reviews for the Disney Compliance team
- Server patching and troubleshooting
- DR site build out and maintenance
Required Education :
- Bachelor's degree or better in Computer Science or a related technical field or equivalent job experience.
- 7+ years of experience working as an Oracle / Snowflake database developer (Oracle 11g or greater) or similar technologies
- At least 7+ years development experience in a data warehousing/ Data Mart or big data environment
- At least 7+ years with data warehouse / Data Mart design experience
- Experience with PL/SQL, SQL, database performance Tuning and optimization.
- Experience with Python Programming language.
- Experience with ETL and other data integration tools such as SAP Data Services, Oracle GoldenGate, and Tidal Enterprise scheduler.
- Ability to develop, implement and maintain standards established by the architecture and Development teams.
- Robust data analysis and root cause analysis skills
- Self-motivated independent thinker and collaborative team member.
- Experience in using CI/CD pipeline (Gitlab)
- Experience in Code Quality implementation (Used Pep8/Pylint) tools or any other code quality tool.
- Implement Industry Standards /Best Practices.
- Excellent analytical and problem-solving skills
- Excellent verbal and written communication skills