Data Architect

Overview

On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

SQL
Python
ETL

Job Details

Role: Sr Data Architect
Location: Charlotte, NC and Addison, TX
Looking for a candidate who can work on a direct W2 without any sponsorship now or in the future
Duration:
Only W2
Required Skills:

  • 3-5 years experience in relational and dimensional data modeling as well as metadata build and management.
  • Hands on expertise in relational and NOSQL database systems. Strong SQL and Python skills a must.
  • Thorough understanding of real time, batch, and event-based data provisioning.
  • Hands on experience in ETL and API based data provisioning patterns.
  • Needs to be a skilled communicator with tools like Vision, PowerPoint, and be able to quickly put together
  • Strong Excel skills experience working with large amounts of data, conducting analysis and present findings
  • 3+ years of experience as a data architect in a complex data environment
  • 3+ years domain knowledge of the data domains supported by control functions(Finance, Regulatory Reporting, Compliance, Operational Risk, HR, Legal, Marketing, Audit, etc.) and experience in financial service industry.
  • 3+ experience with architecture and design of large scale shared data solutions with multiple stakeholders.
  • Hands-on design and implementation experience with one/more of the following data tools:
  • Data Analysis / Profiling Python (Jupyterlab, PyCharm,etc), Toad, MySQL
  • Data Platforms Hadoop, Spark, Oracle, Exadata, SQL Server, DB2, MongoDB, Teradata, Splunk
  • Data Transformation Informatica, SSIS, Alteryx, Trifacta
  • BI Tableau, Microstrategy, metadata/lineage tools, Distributed Caching tools.
  • Strong knowledge of database modeling principles, techniques, and enterprise data management best practices.
  • Familiar with Data Governance process identify critical data elements, metadata, data lineage, data dictionary, data model, Data Sharing Agreements, Service Level Agreements, Data Management Standards.
  • 1-3 years experience with Data Quality measurements/Scorecards, Control, Remediation along with Data reconciliation techniques.
  • Able to independently architect solutions, lead code reviews and ensure quality throughout the life of each project.
  • Experience working as part of the Agile team and using Agile SDLS tools
  • Demonstrate strong communication, analytical and organizational skills and strong presentation skills.

Desired Skills:

  • Experience working with large amounts of data, conducting analysis and presenting findings.
  • Knowledgeable in Audit and regulatory concerns.
  • Experience with next generation tools and technologies is a plus (AI/ML, RPA, Trino, etc.)
  • A bachelor s and/or master s degree in computer science or related field
  • Proficiency using the Data Vault methodology for modeling
  • Familiarity with ServiceNow Common Services Data Model (CSDM)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Intellisoft Technologies