Data Architect

Did you know that Gartner has positioned COMPUCOM as #1 in its Magic Quadrant for End-User Outsourcing? Come work for the leader today!

We are the leading IT outsourcing company seeking a Senior Data Architect, participating in the design and implementation of data models that can support ongoing company projects. An understanding OLTP, OLAP, normalization, ETL, naming standards and metadata is key to this position. The position requires utilizing data modelling tools to develop logical and physical data models and documenting design documents. The ability to work independently is essential.

RESPONSIBILITIES/DUTIES

Design and review logical and physical data models for OLTP and OLAP in compliance with corporate standards.

Use business requirements to document clear and concise technical database and ETL design.

Maintain design and naming standards

Maintain data dictionaries and integration of systems through database design.

Create DDL, View SQL, and contribute to performance tuning.

Contribute to project planning discussions, provide status updates for development progress and be a critical resource for issue resolution.

Collaborate with report builders on design for optimum performance.

QUALIFICATIONS

Bachelor's degree in Computer Science or related discipline.

Minimum 5 years as data architect.

Strong oral and written communication skills.

Banking or financial experience.

TECHNICAL KNOWLEDGE

Expert knowledge of normalized and dimensional modelling techniques

Expert knowledge of Erwin or System Architect.

Experience with RDBMS (DB2 UDB, Oracle preferred).

Prior experience working with data modelling repository server environment.

Excellent SQL and DDL skills.

Experience with project life cycle development.

Ability to write clear design and process documentation.

Experience with Microstrategy and/or Cognos

AbInitio EME/EMMS for the analysis of metadata

Extremely detail-oriented and able to follow clear methodologies for troubleshooting and development.

*CompuCom supports Employment Equity and Diversity* CompuCom, the leading IT outsourcing specialist, delivers IT your way. Our clients like working with us because they know that, with CompuCom, it's all about you. Our unique ITSM strategy blends your data center, network, voice, and end user computing environments in an innovative fashion. This radically simplifies your IT, allowing you to focus on growing your business and serving your customers. We are highly regarded by worldwide and regional organizations alike for our pragmatic approach, best practices, and highly skilled workforce. This balance provides the perfect alternative to address the evolving challenges facing you, today and in the future. More than a trusted advisor, CompuCom is your trusted doer. To learn more, visit our website