Senior Data Architect / Data Modeler

Job Title: Senior Data Architect / Data Modeler

Job Location: Alpharetta, GA

Job Type: Contract

Pay Range: $60.00hr - $65.00hr

Job Overview:

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.

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 Splunk with experience writing complex macros to expedite data analysis.

Qualifications:

• 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.

== ==

• Medical, Dental, and Vision Insurance
• 401(k) Retirement Plan
• Health Savings Account (HSA)
• Disability Insurance (Short-Term and Long-Term)
• Life and AD&D Insurance
• Paid Sick Leave (where required by applicable state or local law)
• Supplemental Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Employee Wellness Programs
• Employee Assistance Program (EAP)
• Career Growth and Professional Development Opportunities