Little Rock, Arkansas
Data Warehouse Architect Job Opening in Little Rock, Arkansas - The Data Warehouse Architect will help design, implement and support the organizations transactional and dimensional Data Warehouse development efforts under the direction of Director of Development; providing guidance and direction to clients and project team members. The Data Warehouse Architect interacts with all levels of technical and business resources to meet operational and strategic reporting and analytical needs.
Provide warehouse design, architecture, reporting, implementation and integration efforts, including data sourcing and transformation. Help define process to ensure that the client's business goals and objectives are met by the proposed data warehouse architecture and design. Leverage knowledge of current data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
Principal Duties and Responsibilities
Build and maintain MS SQL SSIS packages
Implement and manage MS SQL Server databases
Logical and physical data modeling (Transactional and Dimensional)
Develop and maintain vendor extract / import process
Identify logical issues between database models and reports.
Follow change management procedures
Provide cross training to other team members as needed
Provide after-hours support based on the on-call rotation
Support infrastructure changes as needed
Other duties as assigned.
Job Knowledge, Skills and Abilities
3+ years? experience with dimensional database design
4+ years? SQL Server experience implementing data warehouse solutions using SQL Server, Transact /SQL and DTS packages.
Experience in creating reports and dashboards
Experience with MS SQL Server 2008/2012 and SSIS
Logical and physical data modeling expertise
Knowledge of the software development lifecycle including systems analysis, design, development and deployment.
Strong communication skills including facilitation, presentation, and documentation.
Ability to capture and transform business requirements into functional and data specifications.
High level of initiative, self-starter, flexible, proactive and team player.
Professional maturity.
Education and Experience
Requires a Bachelor?s degree in a field related to the position (Information Systems, Business, Healthcare), or comparable experience to have developed equivalent skills / capabilities.
Requires knowledge of the software development lifecycle including systems analysis, design, development, and deployment.
Requires at least 3 years? experience designing a dimensional data warehouse.
Requires at least 4 years? experience developing a data warehouse using Microsoft SQL Server (SSIS).
Desirable Experience
Prefer at least 2 years? experience in a Healthcare setting.
Prefer at least 2 years? experience with Cognos, SSAS, Business Objects, or similar.
Prefer at least 2 years? experience with logical dimensional modeling.
Prefer at least 3 years? experience using a change data capture process as part of your warehouse development.
Prefer at least 3 years? experience with slowly changing dimensions as part of your warehouse development.
Prefer at least 2 years? experience gathering business requirements and developing a GUI dashboard from the requirements.
Please apply at: /about-us/Careers
Job Type: Full-time
Required education:
Bachelor's
Required experience:
Server: 4 years
Cognos, SSAS: 2 years
Healthcare setting: 2 years
|
