Senior Data & Integration Architect

Alliance of Professionals & Consultants, Inc.

Ivanhoe (AL)

On-site

USD 120,000 - 190,000

Full time

5 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Alliance of Professionals & Consultants, Inc. is seeking a Senior Data and Integration Architect to lead the data foundation across master data, warehouses, analytics, and inter-system data exchange.

The role is hands-on, overseeing design and implementation of ETL pipelines, dashboards, and AI-accelerated workflows. The candidate will define authoritative data models, enable self-service analytics, and govern data quality, security, and cost.

Qualifications

  • 6+ years in data engineering, data architecture, or analytics engineering.
  • Hands-on experience building or evolving a cloud data warehouse (Snowflake, Fabric, Databricks).
  • Experience with iPaaS platforms (Boomi, Workato, MuleSoft, Celigo, Logic Apps).
  • Familiarity with APIs: REST, JSON, OAuth, API keys.

Responsibilities

  • Define data architecture and build the data warehouse with trusted sources and reference content.
  • Stand up BI platform and deliver dashboards for executive, financial, and operational reporting.
  • Design, build, and maintain integrations and data pipelines using iPaaS and ETL tools; automate cross-system processes.

Skills

Data engineering
Data architecture
Analytics engineering
Data warehouse
Cloud data warehouse
REST APIs
Webhooks
JSON
OAuth
API authentication
IPaaS platforms
Python
dbt
Git
AI integrations

Tools

Snowflake
Microsoft Fabric
Databricks
Boomi
Workato
MuleSoft
Celigo
Azure Logic Apps

Job description

Job Title: Senior Data and Integration Architect. Type: Direct Hire. Work Location: Onsite position in Birmingham, AL.

Job Overview

The Senior Data and Integration Architect establishes and operates the company’s data foundation across multiple related areas: authoritative master data, data warehouses, analytics software, and inter-system data exchange and automation delivered through iPaaS and ETL platforms. Additionally, the role supports business process automation and AI-accelerated workflow design. The role is accountable for what data means, how its sources are trusted relative to one another, how it moves, and how it is consumed. It is a hands-on role with broad responsibility for design and architecture, as well as for building systems and developing custom reports and dashboards.

Essential Job Responsibilities
  • Data Architecture and Warehouse Define data architecture, including per-element sources of truth, intake pipelines, modeling layers, and curated reference content. Build, configure, and operate the data warehouse, including pipeline setup, data model / view creation, and orchestration. Establish a consistent model for core entities such as customers, locations, assets, and various financial metrics. Establish authoritative master data for core data elements and define the trusted source system for each. Recommends warehouse and tooling selection where platforms are not yet chosen.
  • Analytics platform and enablement Stand up the BI platform and deliver core dashboards for executive, financial, and operational reporting. Define a semantic layer with agreed definitions so that core metrics align across business functions and teams. Support self-service analytics for business users through documentation, training, and the publishing of verified, curated datasets and data views. Partner with finance and business leaders to translate questions and business challenges into trustworthy data solutions.
  • Integration and Automation Design, build, and maintain integrations and data pipelines between business systems using iPaaS and ETL platforms. Set integration standards: API-first patterns, publish/subscribe paradigms, error handling, monitoring, logging Automate manual, cross-system business processes in partnership with system and process owners. Apply AI tools and techniques to accelerate workflow design and automation, with appropriate safeguards for data security and integrity. Maintain an inventory of integrations, data flows, and dependencies. Create a flexible process for bringing acquired companies' data into the warehouse in support of interim (pre-integration) reporting.
  • Governance, quality, and security Implement data quality checks and reconciliation against source systems. Apply role-based access, secrets management, and least-privilege practices to data and integrations Document data ownership, definitions, and retention in partnership with business stakeholders Partners and vendors Manage relationships with platform vendors, consultants, and implementation partners. Coordinate with Information Technology Operations on identity and infrastructure dependencies. Track costs and make recommendations to optimize data tooling spend.
Required Skills & Experience
  • 6+ years in data engineering, data architecture, or analytics engineering, including leading the design of at least one data warehouse or analytics platform
  • Hands-on experience building or evolving a cloud data warehouse (for example Snowflake, Microsoft Fabric, Databricks)
  • Working knowledge of REST APIs, webhooks, JSON, and authentication methods (OAuth, API keys), sufficient to get started with an iPaaS platform
  • Hands-on experience with an iPaaS or integration platform (for example Boomi, Workato, MuleSoft, Celigo, Azure Logic Apps, or similar)
  • Experience integrating ERP, CRM, and field-operations systems
  • Python or a similar language for scripting and data work
  • Familiarity with dbt, orchestration tools, and version control (Git)
  • Experience with data governance, master data management, or data quality frameworks
  • Experience with API-based artificial intelligence integrations
  • Relevant certifications (data warehousing, modeling, analytics, or iPaaS platforms)
  • Valid Driver’s License
  • Builder's mindset: comfortable doing the work, not only designing it
  • Business fluency: reliably connects data work to revenue, margin, utilization, and cash
  • Pragmatism: delivers usable increments rather than waiting for a perfect platform
  • Ownership: works independently with little established process
  • Communication: documents clearly and builds trust with business and team leaders
  • Ability to analyze business workflows in coordination with functional business leaders and data project team members

Job Requisition # 40510 #LI-JN1

A reasonable estimate of the Base Salary for this role is $00,000 - $00,000 per year. The disclosed pay range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The compensation decisions are dependent on the facts and circumstances of each case, such as skills and experience levels.

APC is committed to creating a diverse work environment and is proud to be an Equal Opportunity Employer.

All qualified candidates will receive consideration without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetics, or veteran status.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data & Integration Architect
Senior Data & Integration Architect

Alliance of Professionals & Consultants, Inc. (APC) • Birmingham (AL)

On-site
USD 120,000 - 180,000
Data Architect - Permanent hire (no C2C or 3rd parties) #1022922
Data Architect - Permanent hire (no C2C or 3rd parties) #1022922

Dexian • Rosemont (IL)

Hybrid
USD 140,000 - 160,000
Data Architect
Data Architect

Brooksource • Indianapolis (IN)

Hybrid
USD 66,000 - 94,000
Data Architect
Data Architect

SherlockTalent • Miami (FL)

On-site
USD 80,000 - 120,000
Medical Insurance
Dental Insurance
Life Insurance
+3
Data Architect
Data Architect

Integris Group • Orlando (FL)

On-site
USD 120,000 - 150,000
Senior Data Architect
Senior Data Architect

TECHNOLOGY PARTNERS INC • St. Louis (MO)

On-site
USD 63,000 - 90,000
Data Integration Engineer
Data Integration Engineer

Red Arch Solutions, Inc. • Reston (VA)

On-site
USD 160,000 - 185,000
Health insurance
401K with company match
Performance bonus
+3
Senior Cloud Data & Ai Architect
Senior Cloud Data & Ai Architect

Tata Consultancy Services Limited • Dallas (TX)

On-site
USD 150,000 - 175,000
AI-Enhanced Data Platform & Integration Architect
AI-Enhanced Data Platform & Integration Architect

Alliance of Professionals & Consultants, Inc. (APC) • Birmingham (AL)

On-site
USD 120,000 - 180,000
Associate Data Engineer
Associate Data Engineer

Baker Tilly • United States

Remote
USD 86,000 - 163,000