OVERVIEW
The analytics team at TransPerfect is responsible for servicing reporting requests from both internal and client users. We are responsible for connecting to production systems’ data stores, creating ETL flows that publish the results to a variety of destinations, and building visualizations from the resulting data.
DESCRIPTION
Design, build, and maintain Python-based data pipelines in Snowflake to service the reporting needs of clients and internal teams
Write and optimize complex, high-performing SQL against large, multi-client datasets
Translate reporting requirements and raw data requests into robust, production-grade data flows
Build data flows that combine data from a variety of data sources, including MySQL, SQL Server, MongoDB, Sharepoint, AWS, Azure, Excel, XML, JSON, REST APIs, and log files
Troubleshoot failed data flows and resolve in a timely manner to reduce impact on production activities
Identify areas for performance improvements in existing, long-running data flows
Troubleshoot, fix, or enhance data workflows created by other team members
Build Snowflake Streamlit applications as needed to support internal data workflows
REQUIRED EXPERIENCE AND QUALIFICATIONS
3+ years professional experience developing in Python
3+ years professional experience writing SQL, including complex queries against large datasets
2+ years experience developing on a team that uses source control (git or similar)
Experience building and maintaining data pipelines or ETL/ELT workflows
DESIRED SKILLS AND EXPERIENCE
Experience with Snowflake
Experience building Streamlit applications
Familiarity with Tableau or another BI/visualization tool (bonus, lower priority than Snowflake/Streamlit)
Experience in the Translation and Localization industry
Experience with Openflow or Airbyte
Experience with Knime or Alteryx
Job details are sourced from the employer's original posting.
Open job postingAbout the company
For over 20 years, TransPerfect has provided comprehensive language and technology solutions to help our clients communicate and conduct business more effectively in a global marketplace. Equipped with a quality management system certified to both the ISO 9001:2008 and EN 15038:2006 standards, TransPerfect provides a full array of language and business support services, including translation, interpretation, multicultural marketing, website globalization, subtitling, voiceovers, staffing services, multicultural marketing, training and learning, and legal support services. TransPerfect also offers a suite of cutting edge technologies that significantly reduce costs and improve consistency throughout the translation process, making TransPerfect the vendor of choice for the world's leading multinationals. With annual revenues of over $470 million, TransPerfect is the world's largest privately held provider of language services and technology solutions. From offices in more than 85 cities on six continents, TransPerfect offers a full range of services in 170+ languages to clients worldwide. With an unparalleled commitment to quality and client service, TransPerfect is fully ISO 9001 and EN 15038 certified. TransPerfect has global headquarters in New York, with regional headquarters in London and Hong Kong. TransPerfect offers a comprehensive benefits package including: medical, dental, vision, 401k, paid time-off, company sponsored life insurance, short term and long term disability, flexible spending account options, and a pro-active and accessible HR department that focuses on the staff's health and happiness.