About the job
Become an integral part of the rapidly expanding TechOps BI team at TransPerfect as a Business Intelligence Developer. This role focuses on the design, development, and ongoing maintenance of cutting-edge business intelligence architectures and solutions. You will engage with a comprehensive suite of TechOps technology products, integrating real-time data from Microsoft SQL Server Reporting Services and utilizing Snowflake cloud data warehouse environments. Collaborate with diverse teams to deliver impactful analytics and reporting through industry-leading tools such as KNIME and Tableau, ensuring business stakeholders have timely and reliable access to data for informed strategic decision-making.
DESCRIPTION
Oversee and enhance ETL processes using Microsoft SQL Server, Snowflake, and KNIME to capture business, technical, and reporting requirements. Maintain data pipelines and workflows for real-time updates and accurate replication across various databases and reporting environments. Develop robust error reporting and notification processes through email and alerts. (25%)
Design and deploy scalable analytical systems for end users, featuring interactive dashboards and reports created with 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 understand core business needs, applying data mining techniques to integrate data from multiple sources. Collaborate with cross-functional teams to architect and implement data storage and reporting solutions for operational and financial audits, including the creation of new database schemas and automation of key analytics delivery. (10%)
Work closely with stakeholders to document data requirements, build unified data sources, and develop interactive dashboards in Tableau that reflect critical metrics. Administer Tableau Server environments, managing user access, permissions, and dashboard publishing and maintenance. Continuously enhance published dashboards in accordance with evolving business needs. (10%)
Identify opportunities to automate and streamline reporting workflows organization-wide, enhancing data-driven decision-making. Craft SQL queries for relational and multidimensional databases (SQL Server, Snowflake) to meet complex business demands. (10%)
Collaborate with teams across the organization to ensure seamless integration and synchronization of data between systems, utilizing Snowflake and KNIME. Provide technical support for reporting tools and generate ad-hoc reports as necessary via SQL queries; quickly implement dashboard and application updates to align with business needs. (10%)

