US Data Architect

Data Architect/Modeler
Location: Jersey, Dallas, Tampa
CTH
Pay Rate-$85
Reviewing business requirements and/or conducting in-person interviews, profiling source system data, documentation, analysis, and design of proposed systems. This role encompasses all aspects of data management; conceptual, logical, and physical data model creation. The individual will be involved in end-to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies and standards.

• Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data models

• Translate the business requirements into design artifacts, employing the core design principles

• Profiling the data in the source system(s) by writing SQL statements

• Designing logical data models that conform to existing standards and conventions

• Develop mapping documents that demonstrate data lineage

• Revising data dictionaries, governance practices, standards, guidance, architecture patterns

• Converting logical data models into working physical data models and, document and maintain lineage between the two artifacts

• Developing and maintaining reference architecture artifacts

• Conduct weekly walkthroughs of the data models with different stakeholders

Sound Like You?

• Bachelor's degree preferred with Masters or equivalent experience

• 7 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies

• 5 years of data architecture experience

• Thorough knowledge of Erwin Data Modeler (V9 or higher) or a comparable CASE tool

• Working knowledge of data warehousing concepts and the ability to convert a physical design into a dimensional design

• Knowledge of Agile development methodology and concepts

• Experience working as a member of distributed data architecture teams

• Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC)

• Hands-on SQL experience

• Good understanding of the cloud technology and some of the tools used in that space

• Experience with two or more of the following DBMS technologies: Oracle, PostgreSQL, Snowflake, Microsoft SQL Server

• Effective communication skills and customer relationship management skills

• Thorough knowledge of Microsoft Office suite of products

• Experience with ETL tool(s): (Informatica, DataStage, Talend, etc.)

• Experience with Business Intelligence (BI) tools: (i.e. OBIEE, MicroStrategy, Tableau, Power BI, QuickSight, etc.)

Desired Skills:

• Experience with any commercially available industry data model (i.e. IBM's Financial Services Data Model)

• Good understanding of the concepts in the financial industry, especially in trade, clearing and settlement

• Experience with any data profiling/data discovery/data quality tool
Education/Certification:

• Bachelor's degree in an appropriate area of specialization (Computer Science or Information Systems)

• Data management and data architecture related certificatio

• Minimum of 4 years of related experience

• Previous internal or external audit experience is helpful, but not required.

• Strong analytical and problem-solving skills

• Strong commitment to teamwork and collaboration

• Strong written and oral communication skills

• Certifications related to the candidate's coverage responsibilities are beneficial, but not required, such as CPA, CFA, Financial Risk Manager (FRM), Certified Internal Auditor (CIA), and Certified Information Systems Auditor (CISA)

• Knowledge or experience related to financial risk management, quantitative analysis, or coding (e.g., Python, SQL, R, VBA) will be a plus