GovCIO is hiring a Data Architect

In this role you will: • Develop enterprise Data Architectures strategies and provide solution recommendations in support of business strategies • Work across all phases of data modeling, from conceptualization to visualization and database optimization. This extends to SQL development and database administration. • Review business requests for data and data usage, research data sources and create requirements documentation • Coordinate design and develop new data sources and usage ensuring consistency and integration with existing warehouse structure • Design extract, transform and load logic of data, analyze data logs to enhance performance and increase functionality • Design control and monitoring mechanisms to ensure accuracy and data integrity • Coordinate development of and / or develop BI presentation layers • Design, develop, test and deploy dashboards, scorecards, reports and alerts/notifications for the presentation of business metrics according to business user requirements consistent with integrated BI applications and warehouse structure • Develop support documents for BI applications and provides user support and training • Lead design of high-level conceptual and logical models that facilitate a cross-system/cross functional view of data requirements • Oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality • Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement • Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks • Collaborate with project managers and business unit leaders for all projects involving enterprise data • Identify and develop opportunities for data reuse, migration, or retirement • Provide consultation during business requirements gathering efforts • May work with organization departments to design and develop data marts • Design, develop, and implement the data architecture for a data warehouse, including high-performance ETL (Extract, Transform, and Load) tools, routines and infrastructure • Lead Data Profiling and Data Quality analysis using SQL or other query based analysis • Develop and implement solutions for cleansing data to remove errors and ensure consistency • Recognize and leverage data sources both internally and externally to enhance the analysis capabilities • Reverse engineer data specifications from source systems through data discovery, analysis, and other techniques