Position involves designing, implementing, and supervising activities related to data management and automation. Manage data integrations and migrations into the HubSpot ecosystem, ensuring alignment with business objectives and seamless integration to drive operational efficiency and strategic growth. Ensure data quality and integrity across various database systems. Identify and deploy the optimal Data Integration (DI) framework tailored to the organization's specific requirements.
Responsibilities
- Manage data integrations and migrations into HubSpot ecosystem
- Create and optimize complex SQL queries to extract, transform, and aggregate data for reporting and analytics purposes.
- Automate and orchestrate ETL processes using scripts, and other technologies.
- Leverage Python and other related tools for data cleaning, manipulation, and statistical analysis.
- Work with AI team and integrate cognitive science/AI-related projects across the organization.
- Leverage generative AI to improve workflow, functions, and business processes.
- Integrate Power BI with external data sources and APIs to create dynamic, real-time dashboards, scalable data analysis and transformation.
- Provide full lifecycle support from implementation to maturity of DI solutions.
- Collaborate with cross-functional teams to understand data requirements and implement automated data pipelines.
- Ensure data quality and accuracy by implementing validation checks and error handling mechanisms.
- Handle complex data requests, reports, and predictive data modeling
- Identify inefficiencies in current databases and leverage solutions.
- Diagnose and resolve database access and performance issues.
- Prioritize project tasks and handle scope changes while ensuring projects meet deadlines and business objectives.
- Collaborate closely with stakeholders to align project goals with business needs.
- Maintain clear documentation of project plans, milestones, and outcomes to ensure effective communication and reporting.
Position Requirements
- Experience in leading HubSpot migrations and integrations
- SQL, with the ability to write complex queries and optimize performance.
- Microsoft Power BI.
- Python, PowerShell. Experience with Java Script is a plus.
- API’s, web services, message queuing, ESB.
- ETL processes, data pipeline orchestration, and automation.
- Forecasting models (ARIMA, Prophet) and statistical analysis.
- Strong understanding of data governance and compliance standards.
- Working knowledge of generative AI prompting.
- Excellent communication and collaboration skills to work with cross-functional teams.
- Familiarity with project management methodologies (e.g., Agile, Scrum, Waterfall).
Formal Education & Certification
Bachelor's degree in Computer Science, Data Science, or related field plus 3 years of experience.Related certifications (e.g., CDIS, CDIA, AWS, HubSpot) plus 5 years of experience.
Benefits:
- 401(k)
- 401(k) matching
- Dental/Vision insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Tuition reimbursement
Schedule:
- 8-hour shift
- Monday to Friday
This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by their supervisor. Such tasks shall be capable of being performed with reasonable accommodation, if necessary, that does not impair a business necessity or impose an undue business hardship and without presenting a direct threat to the safety to the applicant or others.
