Senior Data Architect / Data Modeler

Cynet Systems • Alpharetta, GA

2d

About The Position

Seeking a Senior Data Architect and Modeler with 12+ years of experience in financial services to design performant Operational Data Stores and near real-time Data Warehouses using Kimball and Inmon methodologies.

Requirements

• Excellent interpersonal, written, and verbal communication skills, with the ability to break down complex information and articulate it clearly.
• Comfortable working in a fast-paced, highly complex, matrixed environment and capable of handling multiple tasks concurrently.
• Ability to understand the current data landscape, interpret analysis results, 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, complex environment.
• Strong organizational skills with demonstrated ability to work with partners to meet business SLAs and deliver work to expectations.
• Functional knowledge of the financial services industry with experience promoting a robust risk and control environment.
• Ability to coach, train, and mentor junior staff.

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, with strong hands-on experience using Erwin.
• 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 sharing.
• Well-versed in PowerPoint with the ability to design complex dashboards in Power BI.
• Expert in Excel and Client with experience writing complex macros to expedite data analysis.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed