About the job
TransPerfect is a global provider of language services and technology solutions, headquartered in New York City with a presence in over 160 locations worldwide. The company supports more than 170 languages and serves a diverse client base, offering tools like GlobalLink® to help organizations manage multilingual content. TransPerfect holds ISO 9001 and ISO 17100 certifications, reflecting its focus on quality and client satisfaction.
Role Overview
The TechOps Business Intelligence team at TransPerfect is looking for a Business Intelligence Developer based in New York City. This position centers on designing, developing, and maintaining business intelligence architectures and solutions. The developer will work with TechOps technology products to integrate real-time data, primarily using Microsoft SQL Server Reporting Services and Snowflake cloud data warehouse environments. Tools such as KNIME and Tableau are used to deliver analytics and reporting, ensuring business stakeholders receive timely and accurate information for decision-making.
Main Responsibilities
- Manage and improve ETL processes using Microsoft SQL Server, Snowflake, and KNIME. Capture business, technical, and reporting requirements. Maintain data pipelines and workflows for real-time updates and accurate data replication across databases and reporting environments. Develop error reporting and notification systems through email and alerts. (25%)
- Design and implement scalable analytical systems for end users. Build interactive dashboards and reports with Tableau and KNIME. Automate production reports for daily, weekly, and monthly statistics. Design flexible and reliable relational database models within SQL Server and Snowflake. (25%)
- Work with internal and external stakeholders to understand business needs. Apply data mining techniques to consolidate data from multiple sources. Collaborate with cross-functional teams to design and implement data storage and reporting solutions for operational and financial audits. Develop new database schemas and automate key analytics delivery. (10%)
- Partner closely with stakeholders to document data requirements, create unified data sources, and build interactive Tableau dashboards that highlight key performance metrics. (40%)

