HubSpot Data Integration Specialist

The Potter's House, Inc.; Dallas (TX); On-site; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Data Integration Specialist to lead data management and automation initiatives. This role involves managing integrations into the HubSpot ecosystem, ensuring data quality and integrity, and leveraging advanced tools like SQL and Python for data analysis. You will work closely with cross-functional teams to create automated data pipelines and enhance operational efficiency. Join a dynamic environment where your contributions will directly impact strategic growth and operational success. This is a fantastic opportunity for those passionate about data and technology to make a real difference in a forward-thinking organization.

Benefits

401(k)

401(k) matching

Dental/Vision insurance

Employee assistance program

Flexible spending account

Health insurance

Life insurance

Paid time off

Tuition reimbursement

Qualifications

• 3+ years of experience in data management and automation.
• Strong SQL skills with the ability to optimize complex queries.

Responsibilities

• Manage data integrations and migrations into HubSpot ecosystem.
• Automate ETL processes and ensure data quality across systems.

Skills

SQL

Python

Data Integration

ETL Processes

Data Governance

Communication Skills

Project Management

Education

Bachelor's degree in Computer Science

Related certifications (e.g., CDIS, CDIA, AWS, HubSpot)

Tools

HubSpot

Power BI

PowerShell

JavaScript

Job description

1 week ago Be among the first 25 applicants

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 JavaScript is a plus
• APIs, 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.