Senior Data Architect & Modeler - Only W2

AppLab Systems, Inc; Alpharetta (GA); On-site; USD 140,000 - 200,000; Full time

Job summary

AppLab Systems, Inc. seeks a Senior Data Architect & Modeler (Hands on) with deep expertise in Erwin and SQL for banking data environments.

You will design and optimize ODS and near real-time data warehouses, model enterprise data across conceptual to physical layers, and implement performance-tuned data solutions using Oracle Exadata, Snowflake, and Hadoop/Spark. Strong communication and leadership are essential.

Qualifications

• Strong data modeling skills and experience with Enterprise Data Models (Conceptual, Logical, Physical)
• Hands-on experience with Erwin for data modeling
• Advanced SQL development and performance tuning in large data environments
• Financial services domain experience with accounts, cards, payments, and digital transactions
• Ability to design and optimize data pipelines and data stores for near real-time analytics

Responsibilities

• Design highly performant Operational Data Stores (ODS) and near-real-time Data Warehouses using Kimball and Inmon methodologies
• Develop enterprise data models and ER models; communicate complex concepts clearly
• Lead data analysis and data modeling across financial services domains such as accounts and payments
• Tune SQL and database designs for Oracle Exadata, MongoDB, Hadoop, Spark, and Snowflake
• Create dashboards and data visualizations in Power BI; build macros in Excel to speed analysis
• Coach junior staff and collaborate in a fast-paced matrix environment

Skills

Erwin

SQL

Tools

Oracle Exadata

MongoDB

Hadoop

Spark

Snowflake

Power BI

PowerPoint

Excel

Splunk

Job description

Job- Senior Data Architect & Modeler (Hands on)

Primary Skill – Erwin

Secondary Skill – SQL

Domain – Banking

Responsibilities:

12+ years of experience designing highly performant Operational Data Stores (ODS) and near real-time Data Warehouses, with strong knowledge of industry-standard Kimball and Inmon data modeling methodologies.

12+ years of hands‑on experience in data analysis and data modeling within the financial services industry, including domains such as accounts, cards (credit and debit cards), payments, and digital transaction processing.

Proven expertise in developing Enterprise Data Models, including Conceptual, Logical, Physical, and Entity Relationship (ER) models. Strong hands‑on experience with data modeling tools such as Erwin is required. Prior experience modeling data for financial services organizations is highly preferred.

Advanced SQL development, data analysis, database design, and performance tuning skills across technologies such as Oracle Exadata, MongoDB, Hadoop, and Spark, supporting the implementation of highly optimized physical data models.

Expert hands‑on development, and performance tuning experience in Snowflake including writing pipelines, coding stored procedures, and establishing data share.

Well versed in Power Point and be able to design complex dashboards in Power BI.

Expert in Excel and Splunk with experience in writing complex macros to expedite data analysis.

Qualifications:

Excellent interpersonal, written, and verbal communication skills – able to break down complex information and articulate in a manner that is easy to understand.

Comfortable working in a fast paced, highly complex, matrixed environment and capable of handling multiple tasks concurrently.

Be able to understand current data landscape, interpret results of analysis, identify trends and issues, and develop data standards to support business objectives.

Ability to exercise independent judgment and creative problem-solving techniques for data solutions in a large and complex environment.

Strong organizational skills with demonstrated ability to work with partners to meet business SLAs and plan and deliver work to expectations.

Functional knowledge of the Financial Services industry with experience promoting a robust risk & control environment is preferred.

Be able to coach, train, and mentor junior staff.

Qualifications:

Excellent interpersonal, written, and verbal communication skills – able to break down complex information and articulate in a manner that is easy to understand. Comfortable working in a fast paced, highly complex, matrixed environment and capable of handling multiple tasks concurrently. Be able to understand current data landscape, interpret results of analysis, identify trends and issues, and develop data standards to support business objectives. Ability to exercise independent judgment and creative problem-solving techniques for data solutions in a large and complex environment. Strong organizational skills with demonstrated ability to work with partners to meet business SLAs and plan and deliver work to expectations. Functional knowledge of the Financial Services industry with experience promoting a robust risk & control environment is preferred. Be able to coach, train, and mentor junior staff.