Application Architect (Informatica, Finance & Accounting) (813710)

Smart Cloud Solution; Ohio; Remote; USD 120,000 - 170,000; Full time

Job summary

Smart Cloud Solution in Columbus, OH, seeks an experienced Application Architect with deep Informatica data integration and finance domain expertise. You will lead design, development, and governance of enterprise data flows linking financial source systems, data warehouses, and reporting platforms to ensure data integrity and scalable architecture.

The role requires 8+ years IT, 4+ years in architecture, and strong stakeholder management.

Qualifications

• 8+ years in IT with at least 4+ years in enterprise architecture.
• Proven experience designing large-scale data warehouses and ETL with Informatica (IICS/PowerCenter/Data Quality).
• Strong working knowledge of core financial and accounting concepts.
• Experience integrating financial ERPs with data lakes, EDWs and reporting tools.
• Excellent stakeholder management and communication bridging technical concepts with business teams.

Responsibilities

• Define end-to-end application and data integration architecture for finance systems.
• Design, build, and optimize ETL/ELT pipelines using Informatica PowerCenter/IICS.
• Enforce data quality to ensure financial data accuracy and audit readiness.
• Establish coding standards, design patterns, and framework docs for teams.
• Guide cross-functional teams and act as liaison between finance and IT delivery groups.

Skills

8+ years IT

Enterprise architecture

Stakeholder management

Finance domain knowledge

Communication

Education

Bachelor's degree in CS/IT/Accounting/Finance

Tools

Informatica PowerCenter

Informatica IICS

Informatica Data Quality

ETL/ELT design

Job description

Job Title: Application Architect (Informatica, Finance & Accounting)
Location: Columbus, Ohio

Role Overview

We are seeking an experienced Application Architect with deep expertise in Informatica data integration and a strong foundation in Accounting and Finance domains. In this role, you will lead the design, development, and governance of enterprise data flows connecting the organization’s financial source systems, data warehouses, and reporting platforms. Your work will ensure financial data integrity and scalable architecture.

Key Responsibilities

• Define the end-to-end application and data integration architecture for finance and accounting systems, aligning technical solutions with enterprise financial goals.
• Design, build, and optimize robust ETL/ELT pipelines, data integration strategies, and metadata management solutions using Informatica PowerCenter / Intelligent Cloud Services (IICS).
• Enforce rigorous data quality and checks to ensure financial data accuracy and audit compliance.
• Establish coding standards, design patterns, and framework documentation for integration and delivery teams.
• Guide cross-functional teams, mentor junior developers, and act as the technical liaison between finance stakeholders and IT delivery groups.

Required Skills

• 8+ years in Information Technology, with at least 4+ years specializing in enterprise application or solution architecture.
• Proven track record designing large-scale data warehousing and ETL solutions using Informatica suite (IICS, PowerCenter, Data Quality).
• Solid working knowledge of core financial and accounting concepts.
• Experience integrating financial ERPs with data lakes, enterprise data warehouses, and reporting tools.
• Exceptional stakeholder management and communication skills to bridge complex technical concepts with business finance teams.

Preferred Skills

• Bachelor's degree in Computer Science, Information Technology, Accounting, Finance, or a related field.
• Certifications in Informatica or Cloud Platforms (AWS/Azure/GCP).

Years of Experience: 8+ years in Information Technology

Additional Notes

• This is a remote position.
• Candidates preferably reside in Ohio or within the Eastern Standard Time zone.
• Work hours: 7 AM - 4 PM EST.