Data Modeler / Architect

Job Title: Data Modeler / Architect

Location: Jersey City, NJ [OR] Dallas / Coppell, TX [OR] Tampa, FL ( Choose Any 1 )

Hybrid: 3 days Onsite / 2 days REMOTE

Duration: 6 Months ( CONTRACT TO HIRE )

Skills & Experience Needed:

• 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, SQL Server
• Effective customer relationship management skills
• Experience with ETL tool(s): (Informatica, DataStage, Talend, etc.)
• Experience with Business Intelligence (BI) tools: (i.e. OBIEE, MicroStrategy, Tableau, Power BI, QuickSight, etc.)

Responsibilities:

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

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.