WORKING AT THE MLC

The 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 ARE

The 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 ROLE

As 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.

QUALIFICATIONS

Required

· 3+ years of experience writing complex SQL queries in a production environment

· Strong experience with relational databases (e.g., PostgreSQL, Oracle)

· Proven ability to optimize queries and improve database performance

· Experience working with large, complex datasets

· Strong problem-solving skills and attention to detail

· Ability to communicate technical concepts to non-technical stakeholders

Preferred

· Experience with cloud data platforms (AWS Athena, Metabase, or similar)

· Familiarity with ETL/ELT processes and data pipeline concepts

· Experience supporting financial, royalty, or transactional data systems

· Understanding of data modeling concepts (star schema, normalization, etc.)

ESSENTIAL RESPONSIBILITIES

AS A MEMBER OF THE TECH TEAM, YOU WILL:

· Design, develop, and maintain complex SQL queries, stored procedures, and views to support business operations and reporting

· Optimize database performance through query tuning, indexing strategies, and execution plan analysis

· Partner 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 outputs

· Collaborate with cross-functional stakeholders (Finance, Rights Management, Member Experience) to translate business requirements into scalable data solutions

· Troubleshoot data discrepancies and implement long-term fixes to improve data quality

· Contribute to data governance, documentation, and best practices across the data ecosystem

· Assist in building and maintaining reporting datasets for internal and external stakeholders

· Data quality and validation frameworks to ensure accuracy

About Truework

Truework, recently acquired by Checkr, provides access to crucial employment and income information needed for mortgage loans, apartment rentals, background checks, and more. We’re disrupting a $5B+ industry dominated by legacy incumbents and outdated processes. Within Checkr, Truework operates independently, allowing rapid iteration while leveraging the strengths and assets of the core business.

About the Role

This role sits on Checkr’s Operations Insights & Analytics team, directly supporting Truework’s operations team as its primary analytics partner. Truework’s operations are more complex than a typical help desk — and deeply understanding their processes will be central to your success in this role.

Truework already has some operations reporting and data infrastructure in place, but as the first dedicated analyst focused on this work, you’ll own the process of improving and expanding it. Some existing dashboards need to be rebuilt or consolidated, sources-of-truth established, and the team needs reliable performance & cost metrics. You’ll also contribute to the near-term migration from Looker to Omni Analytics.

The ideal candidate is someone who can context-switch between hands-on data work and strategic analysis, thrives in ambiguity, and is energized by making messy things clean. You should be someone who, when given a high-level goal, figures out what questions to ask, what data is needed, and what infrastructure would provide it — and then builds it.

What You’ll Do

Drive Analysis & Business Performance

• Build and maintain models for cost, headcount, and operational performance that inform leadership decisions across Truework operations
• Track and analyze team performance week-over-week, identifying trends, bottlenecks, and opportunities for efficiency gains
• Translate technical findings into clear recommendations for stakeholders at all levels, from operational teams to executive leadership

Build & Improve Reporting

• Define and standardize key operational metrics, working with stakeholders to ensure shared understanding of definitions and methodology
• Consolidate and rebuild existing dashboards, validating data accuracy and filling gaps in coverage
• Build production dashboards and self-service reporting in Omni Analytics, giving Truework’s operations teams reliable visibility into team performance

Strengthen Data Infrastructure

• Improve and expand existing data models to support reliable analytics across Truework’s operations
• Write and maintain dbt models, manage data pipelines, and work with raw database schemas to strengthen analytical foundations
• Identify and fix data quality issues — bad joins, missing records, misaligned definitions — before they become reporting problems
• Contribute hands-on to migrating Truework’s data infrastructure onto Checkr’s systems, working independently to navigate unknowns and solve technical problems as they arise

What You Bring

Required

• 5+ years of experience in analytics, data engineering, or a hybrid role — ideally in a high-growth or startup environment where you’ve had to build things from scratch
• Advanced SQL: complex joins, window functions, CTEs, query optimization. You should be able to navigate unfamiliar database schemas and figure out how data fits together.
• Hands-on experience with data modeling and pipeline tools (dbt, Airflow, or similar). You’ve built and maintained data models, not just queried them.
• Strong BI experience building production dashboards (Looker, Tableau, or similar). You know how to design reporting that’s actually useful, not just comprehensive.
• Comfort working in ambiguous environments with incomplete information. You don’t wait for perfectly defined requirements — you figure out what’s needed and start building.
• Strong communication skills: you can explain technical concepts to non-technical stakeholders and advocate for data quality and infrastructure investments
• An A-player mindset with a strong bias for action: you raise the bar, move with urgency, stay resilient through ambiguity, and take ownership to deliver meaningful outcomes.

Preferred

• Python for data manipulation, scripting, and statistical analysis
• Experience with data migration projects — moving data between systems, reconciling schemas, validating parity
• Domain experience in operations analytics, fintech, or verification/identity services
• Familiarity with version control (Git) and software engineering practices in an analytics context

What You Get

• A fast-paced and collaborative environment
• Learning and development allowance
• Competitive compensation and opportunity for advancement
• 100% medical, dental, and vision coverage
• Up to $25K reimbursement for fertility, adoption, and parental planning services
• Unlimited PTO policy
• Monthly wellness stipend