SQL Engineer

Working at the MLCThe MLC is committed to excellence, service, transparency, and diversity. Our culture is collaborative, our people are adaptable. On our team, you are respected, valued for your unique strengths and experiences, and empowered to identify and resolve your own challenges.Who we areThe Mechanical Licensing Collective (The MLC) is a nonprofit organization designated by the U.S. Copyright Office to administer blanket mechanical licenses for digital music services in the United States. Our mission is to ensure songwriters, composers, and music publishers are accurately compensated for the use of their music.Operating at the intersection of music, data, and technology , we process billions of usage records, match them to the correct musical works, and distribute royalties with accuracy and transparency. As we continue to grow, we are building scalable data platforms and workflows that power the future of digital music licensing.The RoleAs a SQL Engineer / Data Analyst, you will play a critical role in designing, building, and maintaining scalable data solutions that power usage and royalty processing, reporting, and internal analytics. You'll work closely with Data Platform, Engineering, Finance, and Member Experience teams to ensure data integrity, accessibility, and performance across systems.This role is ideal for someone who enjoys working with complex datasets, optimizing queries for performance, and building reliable data pipelines that directly support business-critical operations.Preference to individuals in Eastern and Central Time Zone to accommodate for UK team member collaboration.QualificationsRequired3+ years of experience writing complex SQL queries in a production environmentStrong experience with relational databases (e.g., PostgreSQL, Oracle)Proven ability to optimize queries and improve database performanceExperience working with large, complex datasetsStrong problem‐solving skills and attention to detailAbility to communicate technical concepts to non‐technical stakeholdersPreferredExperience with cloud data platforms (AWS Athena, Metabase, or similar)Familiarity with ETL/ELT processes and data pipeline conceptsExperience supporting financial, royalty, or transactional data systemsUnderstanding of data modeling concepts (star schema, normalization, etc.)Essential ResponsibilitiesAs a member of the tech team, you will:Design, develop, and maintain complex SQL queries, stored procedures, and views to support business operations and reportingOptimize database performance through query tuning, indexing strategies, and execution plan analysisPartner with Data Engineers and Analytics teams to support data pipelines and transformations across platforms (e.g., AWS Athena, Metabase, or similar)Support royalty processing workflows by ensuring accuracy, consistency, and timeliness of data outputsCollaborate with cross‐functional stakeholders (Finance, Rights Management, Member Experience) to translate business requirements into scalable data solutionsTroubleshoot data discrepancies and implement long‐term fixes to improve data qualityContribute to data governance, documentation, and best practices across the data ecosystemAssist in building and maintaining reporting datasets for internal and external stakeholdersDesign data quality and validation frameworks to ensure accuracyYou will champion the MLC's culture by:Embracing The MLC's leadership values and applying The MLC's Guiding Principles to your team's workBeing process‐oriented, data‐driven, and tech‐savvy; being collaborative, curious, and open to new ideasBuilding a dynamic team; mentoring team members; developing future leadersInspiring others with your enthusiasm and humility#J-18808-Ljbffr