About the job
TransPerfect is a global language services and technology company headquartered in New York City. With operations in more than 160 cities and support for over 170 languages, the company helps organizations manage multilingual content through its GlobalLink® technology. TransPerfect holds ISO 9001 and ISO 17100 certifications. More information is available at www.transperfect.com.
Role overview
The Business Intelligence Developer will be part of the TechOps Business Intelligence team based in New York City. This position centers on designing, developing, and maintaining BI solutions that handle real-time data. The role works closely with Microsoft SQL Server Reporting Services and integrates with the Snowflake cloud data warehouse. Collaboration with other teams is essential, using tools such as KNIME and Tableau to deliver analytics and reporting that inform business decisions.
What you will do
- ETL Development and Data Pipeline Management (25%)
Build and maintain ETL processes using Microsoft SQL Server, Snowflake, and KNIME. Support real-time data updates and ensure accurate replication. Set up error reporting and notifications via email and alerts. - Analytical Systems and Reporting (25%)
Design scalable analytical systems for end users, including interactive dashboards and reports in Tableau and KNIME. Automate production reports for daily, weekly, and monthly statistics. Develop reliable relational database models in SQL Server and Snowflake. - Stakeholder Collaboration and Data Integration (10%)
Work with internal and external stakeholders to understand business needs. Use data mining to unify data from multiple sources. Collaborate with cross-functional teams to design and deploy data storage and reporting solutions for audits, including new database schemas and automated analytics delivery. - Requirements Gathering and Dashboard Development (40%)
Collect and document data requirements from stakeholders. Build unified data sources and develop interactive Tableau dashboards that highlight key metrics and insights for decision-making.

