Senior Data Architect in Charlotte, NC at Signature Consultants

Date Posted: 7/21/2020

Job Snapshot

Job Description

Data Model Lead/Architect:

Signature Consultants has an opportunity for a Data Model Lead/Architect. In this role the candidate will lead the design and implementation plan for the organization's Enterprise Data Warehousing solution. This position works collaboratively with Solutions Architect to define Data Strategy for the business, including policies, principles, governance etc.

Responsibilities:

  • Seek clarifications and understand new product requirements from Product functional team
  • Translate product requirements to conceptual design from database perspective
  • Own design and development/enhancement of Data model and database objects
  • Guide on technical solution for product requirements and provide direction to development teams
  • Development and maintenance of Conceptual, Logical & Physical Data Models Conceptual/Logical Data Models and related data dictionary documentation

Qualifications:

  • Experience leading a successful enterprise data warehouse strategy and implementation programme
  • Ability to think strategically about business, product, and technical challenges in an enterprise environment
  • Experience with data warehouse, data lake, and enterprise big data platforms
  • Understanding of database and analytical technologies in the industry including MPP and NoSQL databases, Data Warehouse design, BI reporting and Dashboard development
  • Knowledge of payments industry data standards is desirable, including ISO 20022, as well as regulatory experience within Payments
  • Excellent problem solving and communication skills; experience in interacting with technical and non-technical stakeholders at all levels

Technical Capabilities:

  • Data Architecture - Data Warehouse, Data Mart, ODS, ETL, reporting, analytics
  • Data Modelling - 3NF, Dimensional and Data Vault
  • Data pipeline integration: supporting high volume of daily transactions
  • Experience in Big Data, Real-time data streaming and event monitoring, Data ingestion
  • Understanding of Apache Hadoop and the Hadoop ecosystem. Experience with one or more relevant tools (Sqoop, Flume, Kafka, Oozie, Hue, Zookeeper, HCatalog, Solr, Avro). Familiarity with one or more SQL-on-Hadoop technology (Hive, Impala, Spark SQL, Presto)
  • Significant exposure to relational and NoSQL design methodologies
  • Understand common integration services: REST API exposure
  • Strong SQL experience
  • Structured and unstructured data storage

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.