Job summary:


Title:
Data Architect with SQL Server

Location:
Raleigh, NC, United States

Length and terms:
Long term - W2 or C2C


Position created on 08/16/2019 05:57 pm

Job description:


Interview Type: Skype *** Very long term project; initial PO for 1 year, expect to go for 4+ years *** Onsite - No Remote ***

responsible for analyzing enterprise business needs and designing and developing complex logical databases, logical data models, relational data definitions, and data warehouses in support of Enterprise  information system needs. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations. Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models. 

 

This position identifies opportunities to increase efficiency and effectiveness, trends in data uses, and single sources (sources of record) of data. Responsible for designing, modeling, developing and supporting complex logical database designs, models, and definitions using market leading Database Management and Information Handling Systems. Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops database and warehousing designs across multiple platforms and computing environments. Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.

Required Skills:

  • 10 Years of Microsoft SQL Server 2008
  • 5 Years of Entity Relationship Diagrams (ERD)
  • 5 Years of Data Flow Diagrams
  • 5 Years of Star Schema
  • 3 Years of Microsoft SQL Server 2016 (on premise or Azure cloud based)
  • 2 Years of NoSQL Databases (MongoDB, MS Azure Cosmos)

Desired skills:

  • 5 Years of Sybase DB
  • 2 Years of PostgreSQL, AWS Redshift
  • 2 Years of Data Vault 2.0
  • 2 Years of Scripting Language such as Python
  • 2 Years of Visio
  • 2 Years of Agile Scrum Methodology

Contact the recruiter working on this position:



The recruiter working on this position is Bharath Raj Purohith
His/her contact number is +(1) (703) 4369409
His/her contact email is bharath@msysinc.com

Our recruiters will be more than happy to help you to get this contract.