DATA ARCHITECT & MODELER

StratG Inc
Atlanta, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Atlanta, United States of America

Tech stack

Microsoft Excel
Data analysis
Data Architecture
Data Governance
ETL
Data Warehousing
Database Queries
Oracle Exadata
Python
Meta-Data Management
MongoDB
Network Architecture
Performance Tuning
Microsoft PowerPoint
Power BI
SQL Stored Procedures
Data Streaming
Scripting (Bash/Python/Go/Ruby)
Macros
Snowflake
Informatica Cloud
Collibra
Star Schema
Real Time Data
Physical Data Models
Domain Driven Design
Splunk
Data Pipelines
Microservices

Job description

  • Design and deliver a robust data architecture that enforces best practices, policies, and procedures across the data landscape.
  • Create ER, Logical, Physical, and Conceptual data models for the enterprise using tools such as Erwin.
  • Facilitate data modeling sessions with various stakeholders to assess business requirements and deliver design prototypes and models.
  • Drive reuse of data and establish standards to maintain a single version of truth.
  • Utilize modern data design methodologies such as Domain Driven Design and Microservices Based Architecture.
  • Perform data analysis and profiling in the financial services industry, including account, card, payment, or digital processing.
  • Develop highly performant physical data models using technologies such as MongoDB, Oracle EXADATA, and Snowflake.
  • Design complex dashboards in Power BI and analyze data using Excel and Splunk.
  • Utilize scripting languages such as Python to automate data governance and build data pipelines.
  • Maintain a comprehensive Data Catalogue with robust metadata and lineage.

Requirements

This position is for a Senior Data Architect & Modeler who will be responsible for designing and implementing data architecture solutions for an enterprise. The ideal candidate will have extensive experience in data modeling, data analysis, and data governance in the financial services industry., * Communication skills

  • Banking industry knowledge
  • Dashboard design
  • Data analysis
  • Data architecture
  • Data flow analysis
  • Data governance
  • Meta-data management
  • Experience with IBM tools
  • Knowledge of ISO 9000 standards
  • Building interfaces between systems
  • Macros development
  • Experience with Domain-driven Design
  • Finance industry experience
  • Experience in Financial Services
  • Understanding of Microservices architecture
  • Data modeling expertise
  • Data warehouse design
  • Database management
  • Experience with ERwin
  • Knowledge of policies and procedures
  • Network architecture knowledge
  • Experience with Oracle Exadata
  • Performance tuning skills
  • Proficiency in Microsoft Power BI
  • Proficiency in Microsoft Excel and PowerPoint
  • Experience with MongoDB
  • Prototyping skills
  • Real-time data analysis experience
  • SQL proficiency
  • Experience with Snap Logic
  • Knowledge of Snow Flake Schema
  • Experience with Splunk
  • Development of stored procedures
  • Python scripting skills
  • Understanding of scalability in data architecture
  • Experience in Systems Analysis and design
  • Excellent writing skills

Preferred Skills:

  • Experience with industry reference frameworks such as BIAN, IBM Banking & Financial Markets Model, ISO20022
  • Knowledge of tools such as Matillion, SnapLogic, or DBT
  • Experience with data catalog tools like Alation or Collibra

Apply for this position