Data Engineer

Downtown Music Publishing is seeking a Data Engineer to be a key contributor to the design, development, and management of their global music data platform and ecosystem. This role will involve advanced development of the enterprise data platform, orchestrating the full lifecycle of production data across multiple sources and targets.

Responsibilities:

• Collaborate with business, technology, and product teams to deliver data-driven products, services, and initiatives
• Evaluate, design, build, implement, and manage scalable, cloud-based databases, frameworks, pipelines, integrations, and environments that facilitate the secure, automated management, governance, synchronization, workflow, analytics, and reporting of data across internal systems, products, customers, and 3rd party data providers
• Maintain, improve, and scale the company’s enterprise data platform, a music rights data management, analytics, and workflow ecosystem
• Ensure compliance with industry data standards and best practices
• Develop, document, test, and manage logical and physical models as well as data lifecycle strategies and data-related SOPs
• Create and maintain test data, and perform/test upgrades, code changes, and bug fixes
• Manage daily monitoring of data jobs and queues and troubleshoot/resolve errors
• Share knowledge and promote the professional growth of team members through collaboration and mentorship

Requirements:

• A minimum of 3 years of relevant data engineering experience in an enterprise production environment
• Bachelor's degree or demonstrable equivalent experience in a professional engineering or technical discipline such as Computer Science, Mathematics, Statistics
• Expertise in RDBMS (PostgreSQL experience preferred) and at least one other relational or non-relational data platform (e.g., MongoDB, Snowflake, Redshift, etc.)
• Experience with data modeling, performance tuning, scalability/capacity planning, and backup/recovery
• Experience designing, deploying, and managing production enterprise data on AWS using some/all of the following AWS services: S3, EC2, ECS, RDS, DynamoDB, Lambda, Glue, Elasticsearch, Kinesis
• Expertise in writing efficient and reliable SQL and Python code
• Experience with designing, developing, and managing custom ETL/ELT pipelines
• Experience creating, implementing, and using REST APIs
• Experience with automating the processing of XML, JSON, and delimited data files
• Experience with Data Warehouse / Data Lake design, BI reporting, and data visualization tools
• Experience with Agile/CI software development methodologies
• Must be proactive in root cause analysis, problem solving, and mitigation
• Must be proactively communicative and possess strong verbal and written communication skills in English
• Experience with music data and music data standards (DDEX, CWR)