About the Role
Downtown Music Publishing is seeking an experienced Data Engineer to be a key contributor to the design, development, and management of our global music data platform and ecosystem. This role will be responsible for advanced development of our enterprise data platform, orchestrating the full lifecycle of production data across multiple sources and targets. This position offers an opportunity to be a thought leader and influencer within and across the department, company, and market.
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.
- 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.
- 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.
Skills
- SQL
- Python
- RDBMS
- PostgreSQL
- MongoDB
- Snowflake
- Redshift
- AWS
- S3
- EC2
- ECS
- RDS
- DynamoDB
- Lambda
- Glue
- Elasticsearch
- Kinesis
- ETL/ELT
- REST APIs
- XML
- JSON
- Data Warehouse
- Data Lake
- BI reporting
- Data visualization
- Agile/CI
- Data modeling
- Performance tuning
- Scalability/capacity planning
- Backup/recovery
- Music data
- DDEX
- CWR
Location
- Remote
- New York
- Nashville
- Los Angeles
- Portland, OR
Work Type
- Remote
- Onsite
Experience Level
- Senior
- 3 years of relevant data engineering experience
Education Level
- Bachelor’s degree or demonstrable equivalent experience in Computer Science, Mathematics, Statistics
Salary/Compensations
- Up to $135,000 annually
Benefits
- Life Insurance
- 401k (with match)
- Paid Volunteer Hours
- Medical
- Dental
- Vision
- Generous paid time off
About the Company
- Downtown Music Publishing is a successful and expanding company in the music industry.
- The company fosters a collaborative environment full of innovative, passionate, and happy people.
- Downtown is committed to providing a comprehensive market-competitive total rewards program for its employees.
Equal Opportunity
- Ensuring a diverse and inclusive workplace where we learn from each other is core to Downtown's values. We welcome and encourage all applicants of different backgrounds, experiences, abilities and perspectives to apply.
