Integration Services Engineer

Pyramid Consulting, Inc; Fort Washington (Montgomery County); Hybrid; USD 96,000 - 103,000; Full time

Job summary

Pyramid Consulting, Inc. is seeking an Integration Services Engineer for a 12 Months Contract in Fort Washington, PA (Hybrid). The role pays $70-$75/hour and includes standard benefits.

You will design and deliver enterprise integration solutions, build APIs and workflows, and implement Azure-based data integration across Snowflake/Databricks environments. The candidate will work with Cloud Architects to connect disparate systems, configure security, and enable CI/CD with IaC tooling.

Qualifications

• Experience designing and delivering integration solutions.

Responsibilities

• Setting up and managing ADO

Skills

Azure

Data integration

CI/CD

DevOps

IaC

SQL Server

Security & governance

Snowflake/Databricks

JDE integration

Azure DevOps

Tools

SQL Server

Azure DevOps

Snowflake

Databricks

Bicep

Terraform

Job description

Immediate need for a talented Integration Services Engineer. This is a 12 Months Contract opportunity with long-term potential and is located in Fort Washington, PA (Hybrid).

Job ID:26-25675

Pay Range: $70 - $75/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• Setting up and managing ADO
• Azure datahub using SQL Server (with database skills to write DDL/DML, stored procedures, and triggers)
• Azure ETL capabilities using Function application and stored procedures
• Configurating Azure Fabric and deploying its packaged components
• Integrating AIS with Snowflake or Databricks
• Experience in integrating with Enterprise One (JDE) or similar enterprise applications
• Implement Azure Landing Zone framework, setup Azure security model, and access using Entra Id/MFA

Key Requirements and Technology Experience:

• Integration Design & Delivery
• Design and implement integration solutions aligned to enterprise patterns
• Build APIs, workflows, and event-driven solutions using Azure Integration Services
• Translate requirements into specifications and interface contracts
• Platform Engineering & Operations
• Configure connectors, endpoints, authentication, and resiliency patterns
• Monitor performance and troubleshoot issues
• Perform root cause analysis and implement improvements
• Work with Cloud Architect and Cloud Engineer to focus on connecting disparate system, manage data flows and implement more complex, secure IT Infrastructure, middleware solutions and back-end systems/applications integrations.
• Security, Governance & Compliance
• Implement identity-based access and API security
• Enforce governance standards and support audits
• DevOps, CI/CD & Infrastructure as Code
• Build CI/CD pipelines and automate deployment
• Use IaC (Bicep, Terraform)
• Set-up and manage Azure Dev Ops
• Experience with Azure Landing Zone framework, set-up Azure security model, and access using Entra ID/MFA
• Collaboration & Stakeholder Engagement
• Partner with application teams, data, and security teams
• Contribute to standards and best practices
• Systems Integration:
• Works with Application Software Engineers to produce software build for loading onto the target hardware from software source code.
• Uses established CI/CD tools and methodologies.
• Collaborates with network administrators, systems analysts, database administrators, systems engineering administrators, software engineers, and quality assurance to ensure software is implemented effectively.
• Azure ETL capabilities using Function application and stored procedures
• Configure Azure Fabric and deploying its packaged components
• Work data warehousing platforms (Snowflake or Databricks) and integrating with AIS
• Integrate Enterprise One (JDE) with similar enterprise level applications (Salesforce, Workday, Zendesk)

Our client is a leading homebuilding and residential construction Industry.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.