Maintain CT’s existing robust data management system, perform data audits, and build out/incorporate new integrations for the organization.
Develop and implement data collection strategies to ensure comprehensive and accurate data gathering from various sources.
Collaborate proactively with other team members, suggest innovative metrics and construct data pipelines to facilitate advanced analytics as needed.
Lead and manage the migration of data to/from various systems to ensure data synchronization across multiple platforms.
Recommend and implement solutions to enhance data security and ensure adherence to privacy policies and regulations.
Work alongside CT’s finance department to ensure that sales tax is properly collected and oversee transaction files for sales tax remittance.
Track patterns in the customer service ticket systems and provide marketing automation support related to data integration.
Perform additional job-related duties as assigned.

Requirements

3+ years of experience with Python and R or similar coding language.
3+ years of experience with Snowflake or similar relational databases and SQL language.
3+ years of experience with data visualization, including experience with Shiny Apps, visualization tools in R, Power BI, or equivalent.
Experience with data orchestration and architecture including cross-platform integration, data pipelines, API calls, GA4, and webhooks.
Experience with industry-specific integrations and migrations including but not limited to website JS tags, payment tokens, and cybersecurity expertise.
Competence in data migration across a variety of platforms.
Previous knowledge and experience with any of the following platforms: ActiveCampaign, BigCommerce, Blackbaud, GAM, GA4, GTM, Megaphone, Piano, Razor’s Edge, Sage Intacct, Shopify, Squarespace, Stripe, Substack, WordPress, Zapier, and Zendesk.
Experience with tax compliance and payment processing software.
Preferred experience includes, but is not limited to computer science, information systems, statistics, or other technical/quantitative sciences.

Benefits

CT offers a comprehensive benefits package - check out our careers page to learn more

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonRSQLdata visualizationShiny AppsPower BIdata orchestrationdata architecturedata migrationcybersecurity

Soft Skills

collaborationinnovationleadershipdata analysisproblem-solving