Job Openings

RDBMS Data Architect

Twitter Facebook
Location
Pittsburgh, PA
Job Type
Direct Hire
Date
Aug 22, 2019
Job ID
2672692

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