Data & Automation Analyst (T SQL)

Join TRG Screen: Building World-Class Teams. One Expert at a Time.

Are you ready to be part of a dynamic team at the forefront of subscription spend management innovation?

At TRG Screen, we're not just redefining how organizations manage their subscription expenses – we're shaping the future of the industry. With cutting-edge solutions and a commitment to excellence, we empower businesses around the globe to optimize their subscription investments and drive sustainable growth.

Join us in our mission to revolutionize subscription management and make a meaningful impact on the way businesses access and utilize critical information. At TRG Screen, your talent and ambition will find a home, where opportunities for growth and advancement abound.

About TRG Screen

TRG Screen is the leading provider of market data and subscription management technology and automation solutions, tailored to the unique needs of financial institutions and legal firms. Our integrated suite of solutions includes market data and subscription spend management, usage management, compliance reporting, and comprehensive managed services, which hundreds of clients worldwide use to remove cumbersome and inaccurate manual processes and gain control over market data and subscription costs at scale. For more than 25 years, TRG Screen has enabled businesses who rely on market data to monitor and strategically manage spending and usage of data and information services, including market data, research, software licenses, consulting and other necessary corporate expenses. TRG Screen solutions give decisionmakers full transparency into subscription spend and usage, enabling them to proactively manage subscription costs at scale, conduct more informed vendor negotiations, improve governance, and avoid unnecessary spending on these mission-critical business services. TRG Screen is headquartered in New York City, with offices in Europe and Asia, as well as a 24x7 client support center in Bangalore, India.

TRG Screen is a portfolio company of Vista Equity Partners, one of the world’s largest and most respected private equity firms.

Experience: 3+ Years

Role Overview

The Data & Automation Analyst is responsible for building, maintaining, and optimizing data-driven solutions that support business reporting, operational analytics, and automation initiatives.  This role focuses on T‑SQL development, data analysis, and process automation, working closely with business stakeholders, implementation teams, and senior technical leads to improve data accuracy, efficiency, and insight generation.

The role is hands-on and execution-focused, with opportunities to grow into advanced data engineering and automation responsibilities.

Key Responsibilities

Data Analysis & Reporting

• Analyze structured datasets to generate actionable insights for business and operational teams.
• Develop and maintain SQL-based reports, dashboards, and data extracts.
• Validate data quality, identify inconsistencies, and support corrective actions.
• Translate business requirements into clear analytical queries and outputs.

T‑SQL Development

• Write and optimize T‑SQL queries, views, and stored procedures for reporting and analytics use cases.
• Support data transformations and aggregations across multiple relational tables.
• Improve query performance through indexing, query optimization, and best practices.
• Assist senior team members with complex SQL analysis and troubleshooting.

Automation & Process Improvement

• Support the development of data-driven automation workflows to reduce manual effort.
• Build and maintain scripts or tools to automate recurring data tasks (loads, validations, extracts).
• Contribute to internal automation initiatives using SQL-based logic and low-code/no-code tools (where applicable).
• Document automation workflows and data logic for reuse and scalability.

Data Operations & Support

• Assist with routine data updates, corrections, and reconciliations under defined controls.
• Investigate data-related issues and support root cause analysis.
• Collaborate with engineering and platform teams to resolve data defects.
• Ensure adherence to data governance and access control standards.

Collaboration & Stakeholder Support

• Work closely with business users to understand reporting and data needs.
• Partner with implementation, analytics, and engineering teams on shared data initiatives.
• Clearly communicate findings, assumptions, and limitations of data analysis.

Required Skills & Qualifications

Technical Skills

• 3+ years of hands-on experience with T‑SQL
• Strong understanding of:
• Relational databases
• Joins, CTEs, subqueries, window functions
• Stored procedures and views
• Experience building reports and datasets from transactional systems
• Familiarity with data validation and reconciliation techniques

Automation & Tools

• Experience supporting or building automation using SQL and scripting logic
• Exposure to tools such as:
• Power BI / Tableau / Excel (advanced)
• Low-code automation tools (preferred, not mandatory)
• Understanding of basic ETL concepts

Analytical & Problem-Solving Skills

• Strong analytical thinking and attention to detail
• Ability to break down business problems into data-driven solutions
• Comfortable working with large and complex datasets

Preferred / Nice-to-Have

• Experience working with financial, operational, or market data
• Exposure to Python, PowerShell, or similar scripting languages
• Familiarity with data governance or production data controls
• Experience in a SaaS, analytics, or platform-based environment

Join TRG Screen and unlock your potential in an environment where innovation thrives, opportunities abound, and your contributions make a difference. We are an equal opportunities employer. We recognise and value the power of diversity in our workplace and are committed to being an employer of choice for everyone. We welcome and encourage applicants from all backgrounds. All applications for employment are considered strictly on the basis of merit.

At TRG Screen, we understand that diverse and inclusive teams are not just beneficial, they are essential to our success. We recognize that embracing diverse perspectives, backgrounds, and experiences fosters innovation, enhances problem-solving capabilities, and drives better business outcomes. By cultivating a culture of inclusion where every voice is heard and valued, we empower our world class teams to thrive, excel, and drive positive change.

We are proud of our diverse workforce and are dedicated to creating a safe and welcoming environment for all employees. People from various ethnicities, ages, genders, and abilities are encouraged to apply.