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.
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.
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
Amazon Web Services, Inc. Pittsburgh, PA
Remote Warrendale, PA
Remote Warrendale, PA
SDLC Partners Pittsburgh, PA
International Services Management Pittsburgh, PA