Data & Intergrations Engineer

Accountabilities: • Manage, maintain, and enhance the Microsoft Azure data warehouse architecture, ensuring the reliability, scalability, security, and performance of data infrastructure.

• Oversee ETL and ELT pipelines that collect and transform data from multiple internal sources, coordinating external consulting partners responsible for ongoing pipeline updates and maintenance.

• Identify potential risks, bottlenecks, and improvement opportunities within data pipelines, strengthening system redundancy, consistency, and reliability.

• Design and implement new database schemas, data pipelines, and semantic models to accommodate additional data sources and evolving reporting requirements.

• Collaborate with data analysts and reporting teams to ensure data accuracy, query performance, and usability across reporting environments.

• Troubleshoot and optimize SQL queries, stored procedures, pipeline jobs, and database processes.

• Implement and maintain appropriate security, access management, and data protection controls across data warehouse environments.

• Partner with Business Systems teams to design, develop, monitor, and improve integrations between NetSuite, HubSpot, other operational platforms, and the data warehouse.

• Develop and maintain integrations using Celigo as the primary integration platform, while evaluating alternative technologies when appropriate.

• Establish integration monitoring and alerting mechanisms, investigate synchronization failures, and resolve data discrepancies.

• Evaluate and integrate new business systems and data sources using APIs, webhooks, and other integration technologies.

• Support the configuration and extension of business applications whenever data or automation improvements are required.

• Coordinate changes across Data Warehouse and Business Systems environments to prevent disruptions and maintain system compatibility.

• Manage internally developed Azure-based applications, ensuring their ongoing reliability, security, and performance.

• Collaborate with business stakeholders to identify requirements, develop new application features, and deliver solutions aligned with operational needs.

• Diagnose and resolve application defects, conduct quality assurance testing, and validate new features and fixes before deployment.

• Gather business requirements and develop internal tools, reports, workflows, and applications that improve operational efficiency.

• Identify opportunities to automate repetitive manual processes across finance, sales, and operations.

• Maintain, consolidate, or retire legacy tools and applications that are no longer aligned with current business requirements.

• Integrate AI-assisted development tools into coding, code reviews, testing, and technical documentation while maintaining independent engineering judgment and accountability for results.

• Explore emerging AI technologies, assess their practical value, and share effective techniques and best practices with technical teams.

• Develop reusable prompts, utilities, connectors, and other AI-enabled resources to improve productivity and support consistent development practices.

• Contribute to guidelines governing the safe and responsible use of AI tools with organizational data and systems.

• Produce and maintain technical documentation, system definitions, operational runbooks, and implementation records.

• Ensure all technical changes are thoroughly tested before release and follow established deployment and quality assurance procedures.

Requirements:

• At least 5 years of professional experience in data engineering, business intelligence development, systems integration, or a related technical discipline.

• Strong proficiency in SQL and relational database technologies, preferably Azure SQL Database or Microsoft SQL Server.

• Demonstrated experience designing, developing, maintaining, and supporting ETL or ELT pipelines for enterprise data warehouse environments.

• Working knowledge of Microsoft Azure data services, including Azure SQL, Azure Data Factory, Azure Functions, Logic Apps, and Azure Storage.

• Hands-on experience developing and maintaining REST APIs, webhooks, and system-to-system integrations.

• Regular practical experience using AI-assisted development tools such as Claude, Claude Code, or GitHub Copilot in professional software development environments.

• Strong technical ability to review, validate, troubleshoot, and correct AI-generated code, ensuring its accuracy, security, and reliability.

• Experience writing and maintaining unit tests for application, database, and integration code.

• Familiarity with Azure DevOps or GitHub for source control, build pipelines, and software release management.

• Excellent written and verbal communication skills, with the ability to explain technical concepts and collaborate effectively with both technical and business stakeholders.

• Ability to work independently, take ownership of technical projects, and coordinate effectively across multiple teams.

• Willingness and ability to travel occasionally to support organizational and customer requirements.

• Experience with Celigo or comparable integration platforms such as Boomi, Workato, or Azure Logic Apps is preferred.

• Familiarity with NetSuite technologies, including SuiteQL, saved searches, SuiteScript, or SuiteTalk, and HubSpot APIs, workflows, and data models is an advantage.

• Experience developing reports and data sources for Tableau or other business intelligence platforms is preferred.

• Exposure to AI agents, Model Context Protocol (MCP) connectors, Claude skills, or shared prompt libraries is beneficial.

• Programming experience with C#/.NET, including Razor Pages, JavaScript, or Python, is advantageous.

• Familiarity with Azure App Services and Visual Studio database projects is a plus.

• Understanding of Agile development methodologies and experience working in iterative delivery environments is desirable.

• Background in financial reporting, operational analytics, or business intelligence is an advantage.

• Strong intellectual curiosity and enthusiasm for exploring emerging AI tools, evaluating their capabilities, and identifying practical applications.

• Demonstrated ownership and accountability, particularly when directing AI-assisted development, validating outputs, and ensuring the quality of delivered solutions.

• Excellent cross-functional collaboration skills, with the ability to understand dependencies and assess how changes in one system may affect others.

• Strong commitment to quality, security, documentation, and responsible technology practices.

• Willingness to share technical knowledge, communicate lessons learned, and help colleagues adopt effective development tools and practices.

Benefits:

• Remote working opportunities within the United States.

• Competitive salary.

• Flexible working environment.

• Opportunities for professional development and career growth.

• Exposure to innovative technologies, including Microsoft Azure, enterprise integrations, and AI-assisted software development.

• Opportunity to influence data architecture, automation strategies, and technology modernization initiatives.

• Collaborative working environment built around teamwork, continuous improvement, and knowledge sharing.

• Opportunity to contribute to solutions that improve workplace safety, security, and operational efficiency across multiple industries.

How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether?

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1