Constant Contact is hiring a
Senior Systems Analyst

Summary

Join Constant Contact as a Senior Systems Analyst to support the implementation of data privacy tools across a multi-system data landscape. This role involves system integrations, data lineage analysis, and technical troubleshooting across on-premises SQL databases, AWS storage, and SaaS platforms like Snowflake, Salesforce, and Tealium.

Requirements

• 5+ years of experience in technical systems analysis with a focus on systems integration, data lineage, and strong SQL skills
• Experience working with complex data environments, including on-premises databases (SQL), cloud platforms (AWS), and SaaS applications (Snowflake, Salesforce, Tealium, etc.)
• Proficiency in using SQL for querying databases, analyzing data flows, troubleshooting data issues, and ensuring accurate data lineage
• Proven experience in technical system integration and governance processes across diverse data systems, with experience in privacy-focused implementations preferred
• Strong understanding of data governance and system integration processes, with the ability to optimize systems for compliance and performance
• Experience developing technical documentation, including system architecture diagrams, data lineage, and governance workflows

Responsibilities

• Support the technical integration of a data privacy tool into various systems (on-prem, cloud, and SaaS), ensuring alignment with governance standards and compliance requirements
• Perform detailed data lineage analysis to map and understand data flows, storage points, and system interactions, ensuring effective governance and privacy compliance
• Collaborate with engineering, IT, and data teams to integrate the tool with existing data infrastructures, including SQL, AWS, Snowflake, and Salesforce
• Provide hands-on technical support for configuring, optimizing, and troubleshooting the integration, with a focus on governance workflows and system efficiency
• Develop and maintain comprehensive technical documentation, including system architectures, data flows, and governance workflows
• Utilize advanced SQL to query, analyze, and troubleshoot data flows, ensuring accurate lineage and compliance with governance processes
• Troubleshoot and resolve technical issues related to system performance, data integrity, and governance configurations, ensuring scalability and compliance
• Conduct root cause analysis for technical issues related to data integration and governance processes, proposing solutions that improve overall system performance

Benefits

The compensation package includes health and welfare benefits including paid leave