Data Architect

Location: Durham, NC
Date Posted: 02-10-2017
The role is a combination of customer facing and Data Architecture / Modeling skills. Customer facing skills include working closely with customers to
  • independently drive the scope and requirements with minimal guidance
  • understand, prototype, analyze and validate requirements
  • gain business knowledge, understand data flow, business process/ rules and data usage
  • impart user education and recommend solutions
  • undertake and perform activities that advances overall customer satisfaction
Data Architecture / Modeling skills will include overall design and delivery of intuitive, quality and efficient Data Warehouse and Data Mart solutions, which meet business partner needs and align with strategic direction.
The overall goal for this role is to take ownership and accountability for understanding the various data sets and relations, existing landscape, challenges/gaps with Analytical needs, creating data models in an incremental value add and agile manner, and helping drive sustainability built around a framework for Data Governance, Quality and on-going user education.
Skills and Experience
  • Senior BI / DW consultant with strong background and 8+ years of hands-on practical experience in Business Intelligence, Master Data Management, Data Warehouse, Reporting & Analytics domains and technologies.
  • Experienced in working with business users and should be customer centric, good analytical skills, identifying gaps, validating and prototyping requirements to ensure requirements meet business partner needs.
  • 5+ years of extensive experience in a Data Architect role leading the design, developing and documenting conceptual, logical and physical models for complex requirements, multiple data sources and creating cross-functional data marts.
  • Experience in Life Sciences domain especially working with various Crop Science data sets - Marketing & Sales, Growers Data, Seeds & Traits, Third-Party Sources, Market Data, CRM (MS Dynamics, SalesForce, Stay in Front), Sales Force data.
  • Experienced working in an Agile life cycle environment, leading requirements gathering sessions with various groups, conducting source data analysis, data discovery, data profiling, creating and publishing prototype models with data for user verifications, and working with implementation team for build and operate phases.
  • Experienced in a BI / DW Center of Excellence / Competency Center setup for Data Governance & Quality, establishing on-going user data education framework, understanding and following strategic direction & priorities working with Steering Committee.
  • Strong analytical skills to understand impact of changes and upstream / downstream dependencies
  • Experienced in working with data modelling, multi-dimensional, star and snow flake models, SCD’s, time-series analysis, etc.
  • Experienced in creating & publishing data models, technical design specifications, testing, release management documents, conducting formal test cycles -unit/integration/user testing, knowledge transfer and support hand-off.
  • Good hands-on problem solving skills in BI, data related quality, ETL and performance issues.
  • Good leadership & communication skills, details and results oriented, take ownership and drives topics to completion, self-motivated, collaborates and works well with team and business partners.
Primary Technical Skills:
  • 8+ years of hands-on core experience in BI, MDM, DW, Reporting & Analytics domain and technologies of which 5+ years experience is in a Data Architect / Modeler role.
  • 5+ years experience with various Data Modelling tools such as Erwin, Power Designer, and Embarcadero.
  • Requires strong Sql skills and 5+ years of solid experience with Oracle / Sql Server /Teradata.
  • Good experience in ETL design and development using various ETL tools such as Informatica, BODS, Talend using external flat file sources, FTP process, DOS/ Shell batch scripting.
  • Experienced with job scheduling tools, understanding job dependencies, data refresh and job optimization techniques.
Secondary Technical Skills:
  • Talend ESB, Tableau.
  • Project Management Skills
Providing IT Solutions and Staffing
Pittsburgh, PA
this job portal is powered by CATS