SQL Engineer

Mechanical Licensing Collective • Nashville, TN

8d • Hybrid

About The Position

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.

Requirements

• 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

Nice To Haves

• 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.)

Responsibilities

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 11-50 employees