Data Modeler & Architect

Inizio Partners Corp; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading financial services firm in New York is seeking a skilled Data Modeler and Architect to optimize data architecture for clients. The ideal candidate will have over 8 years of experience and expertise in ETL processes, SQL database modeling, and banking data structures. The role includes evaluating data performance, designing data models, and collaborating with cross-functional teams on data solutions.

Qualifications

• Strong experience in a Data Architect or Data Modeler role within banking.
• Expertise in SQL modeling and ETL processes.
• Ability to manage complex data sets effectively.

Responsibilities

• Evaluate existing data structures for performance and standards.
• Design and implement data models for various applications.
• Develop scalable data pipelines using ETL processes.

Skills

Data architecture understanding

ETL processes

SQL database modeling

Building dashboards

Problem-solving skills

Communication skills

Education

Bachelor's or Master's degree in relevant field

8+ years' experience as a Data Modeler & Architect

Experience in Banking & Financial Services

Job description

We are seeking a skilled Data Modeler and Architect to join our team, dedicated to optimizing the data architecture for our clients. This role is ideal for someone who thrives in understanding architecture, data lineage and mapping to identify data gaps.

Key Responsibilities

• Evaluate and interpret existing data structures to ensure optimal performance and alignment with industry standards in the banking and financial services domain.
• Understanding of Data architecture, data lineage and mapping to identify data gaps
• Build controls based on the gaps identified
• Design and implement robust data models that support the integration and functionality of various applications and analytics platforms.
• Develop and maintain scalable and efficient data pipelines using ETL processes tailored for AWS and Databricks environments.
• Collaborate with cross-functional teams to gather requirements and deliver high-quality data architecture solutions that meet the strategic needs of the business.
• Implement and manage SQL modeling techniques to enhance data retrieval and analysis.
• Leverage knowledge of visualization tools to aid in data interpretation and decision-making processes.
• Ensure adherence to best practices in database management and data integration.

Required Skills and Qualifications

• Proven experience as a Data Architect or Data Modeler, specifically within the banking and financial services sector.
• Expertise in ETL processes and SQL database modeling.
• Experience in building Dashboards is a plus
• Experience in Recon tools is a plus
• Excellent problem-solving skills and the ability to manage complex data sets.
• Strong communication and interpersonal skills, capable of working collaboratively in a dynamic environment.

Education

• Bachelors or Master's degree in Computer Science, Data Science, Information Technology, or a related field.
• 8+ years' experience as a Data Modeler & Architect
• Experience in Banking & Financial Services is a must