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