Data & Automation Analyst (T SQL)

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)

Benefits

Additional Information

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at TRG Screen? Share your experience