About the job
Join the rapidly expanding TechOps Business Intelligence team at TransPerfect as a Business Intelligence Developer. In this role, you will be instrumental in the design, development, and upkeep of cutting-edge business intelligence frameworks and solutions. You will engage with a range of TechOps technology products, integrating real-time data from Microsoft SQL Server Reporting Services and utilizing Snowflake cloud data warehouse environments. Your collaboration with cross-functional teams will enable the delivery of impactful analytics and reporting using industry-leading tools such as KNIME and Tableau, ensuring business stakeholders have timely and reliable access to data to inform strategic decisions.
RESPONSIBILITIES
• Oversee and enhance ETL processes utilizing Microsoft SQL Server, Snowflake, and KNIME to effectively capture current business, technical, and reporting requirements. Maintain data pipelines and workflows to support real-time updates and accurate replication across diverse databases and reporting environments. Establish robust processes for error reporting and notification via email and other alert systems. (25%)
• Design and implement scalable analytical systems for end users, including interactive dashboards and reports developed on Tableau and KNIME. Automate production reports for daily, weekly, and monthly statistics while creating flexible and reliable relational database models within SQL Server and Snowflake. (25%)
• Consult with both internal and external stakeholders to comprehend their business needs, employing data mining techniques to unify data from various sources. Work alongside cross-functional teams to architect and implement data storage and reporting solutions for operational and financial audits, which involves creating new database schemas and automating the delivery of essential analytics. (10%)
• Collaborate closely with stakeholders to document data requirements, build unified data sources, and create interactive dashboards in Tableau that reflect key metrics. Manage Tableau Server environments, including user access, permissions, and the publishing and maintenance of dashboards, while continuously enhancing published dashboards in line with evolving business demands. (10%)
• Identify automation and streamlining opportunities to improve reporting workflows across the organization, thereby enhancing data-driven decision-making. Write SQL queries for relational and multidimensional databases (SQL Server, Snowflake) to address complex business requirements. (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 required through SQL queries, implementing dashboard and application updates swiftly to respond to business and end-user needs. (10%)

