About the job
Join the dynamic TechOps BI team at TransPerfect as a Business Intelligence Developer. In this role, you will contribute to the design, development, and maintenance of contemporary business intelligence architectures and solutions. You will engage with a suite of TechOps technology products, harnessing real-time data from Microsoft SQL Server Reporting Services and Snowflake cloud data warehouse environments. Collaborate cross-functionally to deliver insightful analytics and reporting utilizing leading industry tools such as KNIME and Tableau, ensuring stakeholders have timely and reliable data for strategic decision-making.
RESPONSIBILITIES
• Develop and manage ETL processes utilizing Microsoft SQL Server, Snowflake, and KNIME to capture business, technical, and reporting requirements. Ensure data pipelines and workflows support real-time updates and accurate data replication across various databases and reporting environments. Establish robust error reporting processes and notifications. (25%)
• Create and deploy scalable analytical systems for users, encompassing interactive dashboards and reports using Tableau and KNIME. Automate production reports for daily, weekly, and monthly statistics, designing flexible and reliable relational database models within SQL Server and Snowflake. (25%)
• Engage with internal and external stakeholders to assess business needs, applying data mining techniques to amalgamate data from various sources. Collaborate with cross-functional teams to architect and implement data storage and reporting solutions for operational and financial audits, creating new database schemas and automating key analytics delivery. (10%)
• Work closely with stakeholders to document data requirements, build unified data sources, and develop interactive Tableau dashboards that reflect key metrics. Oversee Tableau Server environments, managing user access, permissions, and dashboard publishing and maintenance. Continuously enhance published dashboards in accordance with changing business needs. (10%)
• Identify opportunities to automate and streamline reporting workflows across the organization, promoting data-driven decision-making. Write SQL queries for relational and multidimensional databases (SQL Server, Snowflake) to address complex business needs. (10%)
• Collaborate with teams across the company to ensure seamless data integration and synchronization between systems, utilizing Snowflake and KNIME. Provide technical support for reporting tools and generate ad-hoc reports as needed through SQL queries; quickly implement dashboard and application updates to align with business and user requirements. (10%)
