Previous Job
Solutions Architect
Ref No.: 18-01459
Location: Pittsburgh, Pennsylvania
Job Description:
  • Demonstrates expert proficiency in the design, development and implementation of data models, data warehousing, ETL processes, reporting and analytics capabilities, and database technologies and tools.
  • Develops and extends data architecture to support increasing user demands and application requirements.
  • Provides knowledge and expertise of enterprise data to lead the process of modeling the business and delivering value to the business users.
  • Develops logical database design through in-depth understanding of business needs and functions and available data sources.
  • Applies knowledge of target database technologies to develop efficient physical models from logical design.
  • Designs and develops correct, complete, and resilient ETL processes.
  • Provides expertise in reviewing and explaining data models.
  • Consults with business to resolve complex data issues.
  • Assesses and evaluates risk to understand the implications of design decisions and new technologies.
  • Consults with database administration to tune database performance, track performance and capacity, and resolve complex issues.
  • Uses expertise to evaluate market trends and provide input into the selection of tools and any necessary migration into the company's environment.
  • Contributes to the achievement of area objectives.
  • Leads and mentors other team members to develop team capability.

  • Bachelor's degree in computer science or a related discipline, or equivalent work experience required.
  • 5-10 years of experience in data modeling, data warehousing, ETL, data entity analysis, logical and relational database design.
  • Experience with Informatica, Vertica, Oracle, and Unix/Linux/Shell Scripting preferred.
  • Experience in the securities or financial services industry is a plus.
  • Experience with Finance and Accounting data is a plus.