Skip to navigation
Skip to main content
Skip to footer

Data Architect in Columbus at Huntington

Date Posted: 10/11/2018

Job Snapshot

Job Description

The Enterprise Information Management team is seeking a Data Architect for the Enterprise Data Warehouse. The primary responsibility of the role is to gather business requirements for data, reporting and translate these into physical data models and implement the same into EDW. The Data Architect will also be responsible for creation of technical design specifications and create source to target mapping documentation for ETL developers. Also implement proper indexing and partitioning mechanisms for table, view structures to provide best sql performance.

Responsibilities:

  • Conduct and lead discussions with business leads and SMEs to understand and document the scope, business requirements and translate these into the technical design for Enterprise Data Warehouse.
  • Lead the translation of business needs into feasible and acceptable data-centric semantic layer designs
  • Create physical data models using 3NF and de-normalized dimensional design philosophies.
  • Architect, Design and build Third Normal Form & Dimensional Data Models that adhere to data warehouse best practices
  • Develop semantic tables/views with complex business rules for reporting
  • Build Segregated views for PII and Non PII Data
  • Drive and document the source to target mappings from data models for ETL developers
  • Implement Role Based Access Layer for End User Reporting
  • Document ETL specifications for ETL development
  • Design highly performant and secure structures such as staging areas, integrated data, data marts, cubes and operational data stores.
  • Estimate and communicate the work effort to EDW management, Stakeholders and own the deliverables from inception, review and signoff of the deliverables.

Basic Qualifications:

  • Bachelor's degree preferably in computer science
  • 5+ years of experience as a data architect for multi-terabyte data warehouse projects
  • 4 years of experience in physical data modeling - relational and dimensional;
  • 3 years of SQL experience and performance tuning
  • 2years of experience with Erwin Enterprise Data Modeler Suite OR equivalent;
  • 2 years of ETL design and development experience

Preferred Qualifications:

  • Understanding of data warehousing design and development best practices;
  • Ability to work with business leads and SMEs in gathering data and reporting business requirements
  • Ability to communicate clearly in writing to document data requirements and translate into technical solutions
  • Good communication and interpersonal skills for interacting and collaborating with developers, analysts, and business staff throughout the organization;

EEO/AA Employer/Minority/Female/Disability/Veteran/Sexual Orientation/Gender Identity Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details. Huntington does not accept solicitation from Third Party Recruiters for any position.
TOP