Vacancy expired!
and those authorized to work in the U.S. can be considered as W2 candidates. Role: ETL DeveloperStart Date: 06/21/2021End Date: 02/28/2022Location: Concord, NH 03301
Short Description:Client needs a resource to extract data from various systems that track COVID-19 cases, labs, contract tracing, publicly available sources, etc., and transform this data so it can be properly loaded and integrated with our current data warehouse.SUMMARY:This position can be worked remotely, however, ability to work during the State's business hours (Eastern Time), and participation in video conferencing meetings is a requirement. Ability to physically come on-site is not required, but would be a big plus. Resource is expected to work as full time, 7.5 hours a day, 5 days a week. May need to work off-hours on the weekend.Description:The evolving nature and reach of the COVID-19 pandemic requires evaluating different types of data to inform decision-making and provide useful, transparent information to the public. As the time goes by, there is a need to evaluate different types of data, integrate it with the case and testing data and provide this integrated information in reporting and dashboards. For example, as states have eased their travel restrictions, it's important to understand the infection rates of the people Client . Also, as schools open up, tracking cases and possible community spread within these institutions will be critical to containment and overall education strategy. There is a need for resources that can extract data from various systems that track cases, labs, contract tracing, publicly available sources, etc., and transform this data so it can be properly loaded and integrated with our current data warehouse. Timeliness is important since the issues surrounding COVID-19 is ever evolving.Responsibilities include: •Understand and translate business needs into data models supporting long-term solutions.•Create logical and physical data models using best practices to ensure high data quality.•Maintain conceptual, logical and physical data models along with corresponding metadata.•Develop ETL processes to support integrating various datasets for business intelligence reporting.•Responsible for the development of queries, of varying complexity, and other specialized analytical projects, in connection with Data Warehouse data sets.•Participates in multiple projects adhering to the current SDLC process.•Produces estimates of time and resources required to perform various tasks as part of a team.Sklls•Experience with ETL development to integrate disparate data sources with the specific goal of dashboard reporting (Dashboard exper. is a must-have) Required 3 Years•Informatica experience Required 3 Years•Experience following set standards for design, security, and supportability Required 3 Years•Experience working with Oracle DB and various data sources (ODS, csv, xlsx, dat, API, etc.) Required 3 Years•Experience creating documentation of ETL workflows and ETL workflow dependencies Required 3 Years•Experience understanding and translating business needs into data models supporting long-term solutions Required 3 Years•Experience creating logical and physical data models using best practices to ensure high quality data Required 3 Years•Experience maintaining conceptual, logical, and physical data models along with corresponding metadata Required 3 Years•Experience developing ETL processes to support integrating various datasets for business intelligence reporting Required 3 Years•Experience developing queries of varying complexity, and other specialized analytical projects, in connection with Data Warehouse data sets Required 3 Years•Experience producing estimates of time and resources required to perform various tasks as part of a team Required 3 Years•Experience working in a fast-paced environment with highly sensitive data Required •Experience working with similar data sets in a public health environment Desired •Experience with Tableau, Power BI or another visualization tool Desired •Any Sharepoint site/page creation experience Nice to have •Must have excellent communications skills and be comfortable leading discussions with various stakeholders in video meetings Required •Must be comfortable working in a remote environment Required Benefits:Vacancy expired!