SENIOR DATA ARCHITECT & MODELER

SENIOR DATA ARCHITECT & MODELER (Hands on)

Primary Skill – Erwin

Secondary Skill – SQL

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.

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.