Responsible for the design, development and administration of transactional and analytical data constructs/structures. Included within those responsibilities are the areas of data access and delivery technologies. Is able to analyze and resolve data load issues by working with the business and technical teams.
Includes designing and developing enterprise-wide repositories for all corporate data tools, database systems, or other specialized decision support or expert systems. These systems interface with legacy data and use sophisticated query and analysis tools to support both internal and external customers.
Work Experience 5+ years
Financial Services experience 3+ years Experience
5+ years Technology specific experience (multiple technologies)
Leads multiple work-streams in delivering solutions
2-3 years experience in domain
Develops advanced domain specific technology solutions and guides their development into a final product.
Desired but not required
Data Warehouse Design Develops advanced domain specific technology solutions and guides their development into a final product
Data mapping experience in implementation and design (5+yrs.)
ETL experience in implementation and design (5+yrs.)
Demonstrated ability to lead end to end ETL project and team
Ability to effectively communicate across multiple levels (Executive Sponsors to team members).
This developer will help to lead an upgrade effort. A significant SQL-Server 2000 Data Mart is being upgraded to SQL-Server 2008. The candidate will need to provide direct technical contributions to the design of the upgraded mart and the decisions involved in upgrading a large DTS code base to SSIS.
Description Proficiency Years Experience
Data Modeling 4 - Very Good 3 Years
Data Warehousing 4 - Very Good 3 Years
Database Modeling 4 - Very Good 3 Years
Data Architect – IPS Service Quality Management
Required Technical Skills, Education, and Certifications:
At least three years of logical data modeling experience, and one year of experience developing physical/deployment models and the use of ERWin for data modeling.
Technical undergraduate degree or concentration in a technical field
A mastery of Transact SQL, T-SQL Stored Procedures, and a working knowledge of PL-SQL
A mastery of MS-Access and Visual Basic for the creation of rapid prototypes with at least three years of relevant experience
Rapid application prototyping using MS-Access, Visual Basic, and the .NET Framework
Demonstrated relationship management skills
Knowledge of the Microsoft Office Suite including Word, Excel, PowerPoint, Visio, and Outlook
Desired Technical Skills, Education, or Certifications:
Professional certification, formal academic training, or at least three years of significant professional experience in business systems analysis, financial auditing, or IT auditing
MBA, MS in Math, Engineering, or Accountancy
Certification as a Microsoft MCDBA, Application Developer MCSD/MCAD, or Oracle Application DBA
Working knowledge of Abinitio and/or Informatica
Working knowledge or BRIO, MicroStrategy, COGNOS, or other OLAP tools
Working knowledge of data mining practices and statistical inference
Application of Technical Skills:
This contractor will (primarily) support the IT Analysis and Metrics team by modeling the data from several financial applications. Instantiating these models, developing the transformation and load jobs, and developing processes to ensure data quality will be the next steps.
The modeler will create any user interfaces needed to create or maintain dimension tables, system “driver” tables, or others as needed.
The modeler will use MS-Access 2003 to prototype and create custom GUIs in an Agile project environment.
The modeler will meet with management to provide project statuses and offer opportunities for project performance enhancement.
Using ERWin or MS-SQL-Server Utilities, model data for storage in an analytical data mart
Using MS-SQL-Server, create entities, attributes, and relationships to persist data.
Using MS-SQL-Server Tools, create load jobs, T-SQL code, and other tasks to ensure database performance and quality.
Work directly with customers to prototype SQL-Server GUIs to instances modeled and created.
Interface with support staff to promote data model changes to production
Document the data model and the lineage of the data
Most Technically Challenging Task:
Creation of a (relatively flat) data store sourced from a highly normalized, object oriented instance.
Ensuring that reporting off of the data mart is as easy as possible will be challenging.
Assisting with rapidly changing user requirements in the GUI design will be challenging.
Developing a high level vision of the project and the post-implementation world will be difficult.
SQL-Server / T-SQL / DTS
MS-Access VBA and Visual Basic
Data Modeling - Physical / Logical
BRIO / MicroStrategy / COGNOS / OLAP
DTS / Abinitio / Informatica / Generic ETL
Please note that the evaluation matrix is provided to convey the relative importance of the criteria.
Additional criteria may be added or criteria may be deleted as needed to effectively and uniformly assess the pool of candidates.
Some of the criteria are gating, or minimum criteria, and not all candidates may clear the gates.