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 were not just redefining how organizations manage their subscription expenses were 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 worlds largest and most respected private equity firms.

Experience: 3 Years

Role Overview

TheData & Automation Analystis responsible for building maintaining and optimizing data-driven solutions that support business reporting operational analytics and automation initiatives. This role focuses onTSQL developmentdata analysis andprocess 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.

TSQL Development

• Write and optimizeTSQL 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 ofdata-driven automation workflowsto 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 TSQL
• 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.