Senior Data & Integration Architect

Alliance of Professionals & Consultants, Inc. (APC)

Birmingham (AL)

On-site

USD 120,000 - 180,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

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

Get past ATS filters

Job summary

Alliance of Professionals & Consultants, Inc. (APC) in Birmingham, AL, seeks a Senior Data and Integration Architect to own the data foundation across master data, warehouses, analytics, and iPaaS/ETL pipelines.

This hands-on role designs, builds, and operates data systems and dashboards to inform business decisions. You will drive data governance, integrate ERP/CRM ecosystems, apply AI-assisted workflow design, and partner with leaders to translate questions into trusted data solutions while

Qualifications

  • 6+ years in data engineering, data architecture, or analytics engineering.
  • Experience leading the design of at least one data warehouse or analytics platform.
  • Hands-on experience with cloud data warehouses (Snowflake, Microsoft Fabric, Databricks).
  • Familiarity with API-based AI integrations and iPaaS platforms.

Responsibilities

  • Define data architecture, including sources of truth and pipelines.
  • Build and operate the data warehouse with models and dashboards.
  • Establish a trusted master data set and governance practices.
  • Design, build, and maintain integrations and data pipelines between systems.
  • Implement AI-assisted workflow design with security and integrity safeguards.

Skills

Data engineering
Data architecture
Analytics engineering
Python
Git
REST APIs
dbt

Tools

Snowflake
Microsoft Fabric
Databricks
Boomi
Workato
MuleSoft
Celigo
Azure Logic Apps

Job description

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

Base Salary

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.

Meet APC

APC is a professional staffing and services organization focused on engaging people and positively impacting lives. As "Professionals serving Professionals"®, we take pride in providing our employees and contractors with the highest level of customer service and support.

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. • Ivanhoe (AL)

On-site
USD 120,000 - 190,000
Data Architect
Data Architect

Brooksource • Indianapolis (IN)

Hybrid
USD 66,000 - 94,000
Data Architect, AI and Supply Chain Insights
Data Architect, AI and Supply Chain Insights

HP • Spring (TX)

On-site
USD 147,000 - 231,000
Health insurance
Dental insurance
Vision insurance
+5
Data Architect
Data Architect

Integris Group • Orlando (FL)

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

Commerce Bank • St. Louis (MO)

Hybrid
USD 105,000 - 123,500
Health, dental, and vision insurance
401(k)
Paid vacation
+1
Data Architect
Data Architect

Empower • Greenwood Village (CO)

On-site
USD 138,000 - 200,000
Health insurance
401(k) matching
Tuition reimbursement
+3
Data Integration Architect
Data Integration Architect

HomeServe USA • Norwalk (CT)

On-site
USD 126,000 - 168,000
Annual bonus 10%
Data Architect and Lead Data Engineer
Data Architect and Lead Data Engineer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 91,000 - 124,000
Data Architect and Lead Data Engineer
Data Architect and Lead Data Engineer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 89,000 - 126,000
Data Architect and Lead Data Engineer
Data Architect and Lead Data Engineer

Quantum Technologies LLC • Atlanta (GA)

On-site
USD 89,000 - 126,000