Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Responsibilities:

All roles specified in DWS1 plus the following:

Setting or enforcing standards and overall architecture for data warehouse systems. Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team. Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. The EBI Data Warehouse Specialist will work closely with members of the EBI & analytics data team to define and implement new data models and analytic structures to support DHHS reporting and analytic needs. This includes the design of dimensionally modeled data mart, database views, and development of complex ETL/data integration software using technologies such as Informatica, metadata management, Erwin or similar data modeling tool. Analyze multiple heterogeneous data sources to formulate data models in support of business reporting needs. Analyze DHHS EBI data and transformations and perform data validation and integration testing. Analyze data system to develop sustainable methodology to share and update data among multiple source systems and the EBI data warehouse. Maintain conceptual, logical and physical data models along with corresponding metadata. Investigate and troubleshoot data quality issues from source systems through data warehouse Informatica transformations and data models to Tableau visualizations and outbound interfaces. Design, develop, and test ETL processes to accommodate changes in source systems and new business requirements. Effectively communicate with business SMEs regarding data quality concerns and data gaps or limitations restricting data models and reporting. Responsible for root cause analysis and complex problem resolution. Proficiency with Informatica Powercenter, EDC (MetaData Management), IDQ (Data Quality). Erwin, and Tableau Work as directed by DoIT management to apply DoIT coding standards, Release Management procedures, source code control (GitHub) and best practices. Must safeguard and protect data in compliance with established EBI Data Governance, any state, federal or industry regulations and standards. Produces estimates of time and resources required to perform various tasks as part of a team.

Skills and Technologies:

Could include various technologies and roles including Data Warehouses and Data Marts, Star Schema, Snowflake design methodologies, SQL Server, Oracle and other BI systems from Cognos, Hyperion, SSRS/SSAS, Actuate, SAS, and many more

Experience required: 3-8 Years