Data Engineer (Snowflake / Python)

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