Senior Data Architect & Modeler – Erwin, SQL (Hands-on)

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

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.