*Please send resume to [email protected] <[email protected]>*
Location: Boise, Idaho Duration: 12 Months Interview: local preferred, but not required. Will do phone and/or Skype Communication: Must have excellent verbal and written communication skills. Nothing lower than a 9/10. *Experience in both strategic design of Data Warehouse and the ABILITY to implement the Strategy* *Excellent communication skills and HANDS on experience working with the database and warehouse teams.* - Works with the senior IT architecture team to design, implement and deploy a functional, maintainable/sustainable and scalable enterprise data warehouse. - Must be able to work with a team and also independently to achieve the highest quality enterprise data warehouse. - Data models and ETL must address data quality best practices and rule sets that promote data integrity. - The data warehouse must be in synch with various data systems to provide reporting and data usage that is auditable, defensible and repeatable. - Must have the ability to understand the reporting needs of various divisions within the agency and be able to provide a complete solution that meets the requirements of Idaho’s Department of Health & Welfare. *Agency Expected Deliverables* - Six Plus years of experience - Four year college degree in a technical field of study - Designs and implements data warehouse, data marts and data stores, while ensuring high level of data availability. - Designs and implements processes that meets the agreed upon performance metrics - Employs industry standard best practices in data warehouse design and implementation - Design and implement data structures and commonly used data business intelligence tools for data analysis - May evaluate database warehouse management systems and select infrastructure components such as software, hardware, database warehouse management systems and networking capabilities. - Works closing with the database architects and database administrators to ensure extract functions meet the needs of the end users - Works closely with the application development teams to ensure capture of all new data elements and process changes as they are made at the application level *Specific Skills Required (Programming languages, databases, operating systems, etc.)* - Must have working knowledge of a modern welfare eligibility case management system and hands-on experience with IDHW Division of Welfare's automated eligibility system, IBES, and related components. - Experience with both Oracle and SQL Server databases. - Extensive experience designing, implementing and deploying into production an enterprise data warehouse - Experience understanding data users and data consumers, both system consumers as well as user groups - Experience complying with governmental agency and federal security reporting policies and best practices - Experience designing security at both the schema level and the accessibility level in conjunction with the DBAs - Extensive experience collaborating with the application architects, functional architects, infrastructure architects and database architects - Extensive experience defining data standards and creating data models - Experience in designing and implementing data warehouse for optimal performance and low process overhead - Extensive experience tuning ELT and reporting processes - Experience working with government agencies is required. - Experience in both strategic design of data warehouse & the ability to implement the strategy. - Excellent communication skills and hands on experience working with the database & warehouse teams. *Warm Regards,* *Amit Vajpayee* *IDC Technologies* *1851 McCarthy Blvd. Suite 116, Milpitas, CA 95035* *Email: **[email protected] <[email protected]>* *Phone: * *408-459-3314 Web: www.idctechnologies.com <http://www.idctechnologies.com/> * -- You received this message because you are subscribed to the Google Groups "IT RECURITER" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/it-recuriter. For more options, visit https://groups.google.com/d/optout.
