As a member of the Information Architecture team, the BI Data Architect is key to the architecture, design, development, and maintenance of the data warehouse; data marts, staging and archival databases through the life cycle: from business requirements to development of logical design, translation to physical design, ETL architecture and code development, through implementation and maintenance.
Architect, design and develop enterprise data warehouse, data mart, operational and other miscellaneous components required for BI applications using stored procedures, functions, views, and other ETL Tools.
Assist BI Reporting team in the design of database solutions. Work with business owners and users to understand and translate user requirements into practical data models
Define and prepare conceptual, logical and physical data models
Review database architectures and designs to ensure data integrity and quality, performance, management, scalability, etc.
Develop and execute test plans and scenarios to ensure viability of code prior to implementation in production
Design, develop and deploy back-end systems to support operational and analytical reporting
Troubleshoot programmed code and provide timely resolution and solutions.
Optimize programmed code for best possible speed and performance
Create and maintain documentation of processes, reports, applications, and procedures
Bachelor’s degree or equivalent combination of relevant education and experience
Experience writing T_SQL code and procedures
Familiarity with SSIS or other ETL tools
Experience in data warehousing, including experience working with ETL processes, OLAP structures and dimensional modeling
Understanding of data modeling and metadata concepts
To apply for this job email your details to Connect@vantagepointrecruiting.com