RDBMS Data Architect

Our Client is a dynamic and fast-paced, privately held consulting firm with 400+ employees. They deliver customized digital solutions to transform organizations through our uniquely enabled talent, processes, and leadership. They hire individuals who embody their goal to enable performance for their clients and they believe strongly in growing and developing talent.

RESPONSIBILITIES

The RDBMS Data Architect is responsible for solution design and data development of transactional, reporting, analytics and Business Intelligence solutions to meet the information needs and the strategic goals of the organization.

Develop target data architecture that enables intended business architecture and architecture vision, while addressing request for architecture work and stakeholder concerns. Identify candidate architecture roadmap components based upon gaps between baseline and target data architectures

Provide overall direction, oversight, and successful delivery of data design and implementation.

Apply industry standards for development of data architecture, design principles, and quality control.

Collaborate with Architecture & Governance leadership to develop and evolve and data standards for the organization.

KNOWLEDGE/EXPERIENCE

10+ years of professional experience in IT or consulting with focus on software development

Bachelor's or Graduate degree in Computer Science, Information Systems, a related degree, or equivalent experience

Hands-on experience and expertise with SQL RDMBS tools including MS-SQL, Oracle, DB2, PostgreSQL (At least 6 years)

Experience with end-to-end solution architecture for data capabilities including:

o ELT/ETL development, patterns and tooling (Informatica, Data Stage Talend)

o BI tools (BusinessObjects, Tableau) and other visualization tools

o Test Driven Code Development and SCM tools

Fluent understanding of best practices for building Data Lake and analytical architectures on Hadoop

Strong Scripting/programming background

Strong SQL experience with the ability to develop, tune, and debug complex SQL applications

Expertise in schema design, developing data models, and proven ability to work with complex data is required

Experience in Real Time and batch data ingestion

Proven experience in working in large environments such as RDBMS, EDW, NoSQL, etc.

Data Warehousing experience (Teradata, Netezza etc) helpful

Understanding of security, encryption and masking using various technologies