Description
We are looking for a skilled HubSpot Data & Marketing Operations Analyst to join our team on a contract basis in Mississauga, Ontario. In this role, you will be responsible for managing data operations and ensuring seamless integration between marketing and operational systems. You will collaborate across departments to optimize data processes and support reporting needs within the airline industry.
Responsibilities:
• Extract, transform, and load operational data from industry-specific systems into Azure Data Lake and HubSpot.
• Oversee the transition of data from Salesforce, ensuring clean-up and migration processes are handled effectively.
• Maintain data accuracy and consistency across HubSpot to support operational and marketing needs.
• Develop and manage data pipelines that facilitate comprehensive reporting for marketing and operations.
• Collaborate with marketing and operations teams to identify and address data requirements across aviation, private airport, and maintenance business lines.
• Create detailed documentation of data flows and processes to ensure scalability and long-term usability.
• Monitor and troubleshoot data systems to identify and resolve issues promptly.
• Conduct quality assurance checks to maintain the integrity of stored data and reporting outputs.
• Utilize SQL queries and stored procedures to extract and analyze data efficiently.
Requirements:
• Proficiency in CRM systems, particularly HubSpot.
• Strong knowledge of database objects, systems, and management.
• Experience with DB2 databases and Microsoft tools.
• Skilled in creating and executing SQL queries and stored procedures.
• Ability to perform quality assurance management and ensure data integrity.
• Familiarity with marketing operations and reporting processes.
• Excellent problem-solving skills and attention to detail.
• Effective communication and collaboration abilities to support cross-functional teams.
