Job Id : 1012
Jobtitle : RDBMS Data Architect
Location : Pittsburgh, Pennsylvania
Company Name : Gables Search Group
Industry : Information Technology
Salary : $50,000 - $70,000 YEAR
Job type : Fulltime
Posted on: 2019-07-06
Required Skills : Engineering, Information Technology, Design
Benefits : No benefits are available
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
Intone Networks Inc. Commerce City, CO
Job Description: At least have 12+ yrs. of experience with minimum 1-2 + years in AWS ...
Intone Networks Inc. Indianapolis, IN
Job Description: 4 or more years of relevant IT experience, 2 or more years of experience ...
Intone Networks Inc. Indianapolis, IN
Job Description: 4 or more years of relevant IT experience 2 or more years of experience ...
Intone Networks Inc. Secaucus, NJ
Job Description: Need a VB.net Developer SQL Server 2008 exp. API & XML web services ...
Intone Networks Inc Montville, NJ
Duties Partner with other Architecture teams to develop solution designs and review ...
We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.