About the job
About Us:
TransPerfect is the premier global provider of language services and cutting-edge technology solutions tailored for international business. Operating from over 160 offices across six continents, we offer a comprehensive suite of services in more than 170 languages to a diverse clientele. Our innovative GlobalLink® technology is trusted by over 6,000 organizations to streamline the management of multilingual content. With a steadfast commitment to quality and client satisfaction, we proudly hold ISO 9001 and ISO 17100 certifications. Our headquarters is based in New York City, with regional offices in London and Hong Kong. To learn more about us, please visit www.transperfect.com.
Position Overview:
We invite you to join our dynamic TechOps Business Intelligence (BI) team at TransPerfect as a Business Intelligence Developer. In this role, you will play a crucial part in designing, developing, and maintaining state-of-the-art business intelligence architectures and solutions. You will leverage TechOps technology products to integrate real-time data from Microsoft SQL Server Reporting Services and utilize Snowflake cloud data warehouse environments. Your collaborative efforts will ensure that business stakeholders have timely access to reliable analytics and reporting through leading industry tools like KNIME and Tableau, thereby driving informed strategic decisions.
Key Responsibilities:
Oversee and enhance ETL processes utilizing Microsoft SQL Server, Snowflake, and KNIME to capture business, technical, and reporting requirements. Ensure the maintenance of data pipelines and workflows for real-time updates and accurate data replication across various databases and reporting environments. Develop robust error reporting processes and notifications through email and alerts. (25%)
Design and implement scalable analytical systems for end users, including the creation of interactive dashboards and reports using Tableau and KNIME. Automate production reports for daily, weekly, and monthly statistics, while designing flexible and reliable relational database models within SQL Server and Snowflake. (25%)
Engage with internal and external stakeholders to discern business needs, utilizing data mining techniques to consolidate data from multiple sources. Work with cross-functional teams to architect and implement data storage and reporting solutions for operational and financial audits, including the development of new database schemas and automating key analytics delivery. (10%)
Collaborate closely with stakeholders to comprehend and document data requirements, create unified data sources, and develop interactive dashboards in Tableau that reflect key performance metrics. (40%)

