Data Warehouse Architect

20 Mar 2025

Vacancy expired!

<!DOCTYPE html><html><head></head><body><p>Neos is a leading Austin-based IT Staffing and Consulting firm. Neos was recognized as a one of the in Austin by the Austin Business Journal. </p><p>Neos is currently seeking a Data Architect for a long-term contract position with our client in Austin, Texas<strong> </strong></p><p><strong>Only Candidates local to Texas need apply</strong></p><p><strong>Remote</strong><strong> </strong></p><p>Performs advanced (senior-level) data analysis and architecture work. Work involves data modeling; implementing and managing database systems, data warehouses, and data analytics; and designing strategies and setting standards for operations, programming, and security.</p><p>Key Responsibilities:</p><ul><li>Manages project staff augmentation resources.</li><li>Drives projects related to development of the data warehouse.</li><li>Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.</li><li>Creates a robust, sustainable data warehouse architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources</li><li>Obtains data model requirements, develops and implements data models for new projects, and maintains existing data models and data architectures.</li><li>Develops data structures for data warehouses and data mart projects and initiatives; and supports data analytics and business intelligence systems.</li><li>Implements corresponding database changes to support new and modified applications, and ensures new designs conform to data standards and guidelines; are consistent, appropriate for their intended use, and perform as required; and are secure from unauthorized access or update.</li><li>Develops guidelines on creating data models and various standards relating to governed data.</li><li>Manages conformity of the data warehouse and enforces design and development guidelines and standards.</li><li>Reviews changes to technical and business metadata, realizing their impacts on enterprise applications, and ensures the impacts are communicated to appropriate parties.</li><li>Reviews measures to chart progress related to the completeness and quality of metadata for enterprise information; to support reduction of data redundancy and fragmentation and elimination of unnecessary movement of data; and to improve data quality.</li><li>Selects data management tools and develops standards, usage guidelines, and procedures for those tools.</li><li>Identifies appropriate data sourcing and extraction processes, and identifies and nominates sources as systems of record for data usage in various applications.</li><li>Performs root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.</li></ul><table width="616"><tbody><tr><td width="118"><p>Years</p></td><td width="498"><p>Skills/Experience</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Full life cycle development, architecture and implementation, of an enterprise data warehouse</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Experience w/ Oracle, PLSQL</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Data engineering for business intelligence and business analytics</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Enterprise information management processes and methodologies, relational database management systems</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Creating and implementing Data Governance solutions</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>End-to-end design and architecture of enterprise-level data warehouse solutions</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Dimensional modeling and design following the Kimball methodology to data warehouse development</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Designing Master Data Management solutions</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>ETL and ELT development</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>ROLAP and MOLAP development</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Development following the Agile formal/structured methodology</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Development of reports and dashboards</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>Experience leading stakeholder engagements on the gathering, documentation & detailed analysis of business requirements.</p></td></tr><tr><td width="118"><p>15</p></td><td width="498"><p>SQL Server and stored procedure development</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>ERwin Data modeling tool</p></td></tr><tr><td width="118"><p>10</p></td><td width="498"><p>MS Project or comparable project management tool</p></td></tr><tr><td width="118"><p>Strong</p></td><td width="498"><p>Experience working independently with minimal supervision; ability to effectively prioritize and manage multiple tasks and directional changes under short and firm deadlines</p></td></tr><tr><td width="118"><p>Strong</p></td><td width="498"><p>Strong analytical, trouble shooting and problem-solving skills in data related projects</p></td></tr><tr><td width="118"><p>Strong</p></td><td width="498"><p>Demonstrated ability to communicate effectively with all project stakeholders; including executive leadership, business subject area leaders, and project staff. Excellent written and oral communication, facilitation, and presentation skills</p></td></tr><tr><td width="118"><p>Strong</p></td><td width="498"><p>Advanced interpersonal skills; adept at quickly developing healthy relationships and ascertaining how to work with a variety of individuals at all levels.</p></td></tr><tr><td width="118"><p>Degree</p></td><td width="498"><p>Bachelor’s degree or equivalent work-related experience</p></td></tr><tr><td width="118"><p>Preferred</p></td><td width="498"><p>Informatica</p></td></tr></tbody></table><p><strong> </strong></p></body></html>

  • ID: #49506152
  • State: Texas Austin 73344 Austin USA
  • City: Austin
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-03-20
  • Deadline: 2023-05-16
  • Category: Et cetera