| Urgent Hiring || Sr. Data or Database Engineer with Census (CDC) || Fully Remote || , , at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1246212&uid= From: Steve, GVD SYSTEMS LLC [email protected] Reply to: [email protected] Job Title: Sr. Data or Database Engineer with Census (CDC) Location: Fully Remote Duration 2 months Contract (extension not confirmed) CDC (Centres for Disease Control and Prevention) exp MUST Job Title: Our client, a major software Development Company is seeking a Sr. Data Engineer. The Preferred candidate must have the following: Oracle Cloud, SQL, and non-federated relational data warehouse architecture to help complete the Map Builder capability as part of a larger Social Determinants of Health capability. The candidate will also need to be familiar with Census and CDC data. High-Level Tasks: Redesign the database using a single partitioned FACT Table to improve system performance and data management efficiency. Refactor Geography DIM dataset structure to improve handling, performance, and utilization for mapping functionalities in the Map Builder tool. Update how total deaths are coded in the CDC Mortality Data while ensuring accuracy and reliability. Deploy SDoH code to production instance supporting its first specific geography (implementation for a county in New Mexico). Comprehensive review & validation of SDoH data readiness for product launch Prepare the SDoH data for the initial launch of Map Builder 1.0, ensuring data accuracy and integrity. Set up and configure ETL orchestration processes to support a data subscription model, enabling dynamic data access and updates. Create a schema that facilitates a data subscription model for accessing the SDoH DataMart, allowing for flexibility and scalability. Required Skills: *8+ Years experience in data warehousing in both Inmon and Kimball methodologies *8+ Years experience (expert level) in Oracle PL/SQL *Hands-on experience using Erwin Data Modeler for complex 3NF/Dimensional/Hybrid models. *Experience with metadata-driven solutions. *Hands-on experience working with VLDB and partitioning strategies. *Hands-on experience leveraging external API-s for augmenting DW content. *5+ Years experience working with cloud databases, preferably OCI and AWS. *Experience with a variety of database architectures including row stores, column stores, fully in-memory systems, etc. *Understanding of data architecture and performance optimization techniques including multi-node data distribution, partitioning/sharding, indexing, in-memory data structures, parallelization techniques, explain plans and/or tracing techniques, etc. *Detailed understanding of common data warehouse security requirements including dedicated/system users and roles, row-level security, masking and/or anonymization, SSO capabilities, etc. Keywords: card procedural language http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1246212&uid= |
| [email protected] View All |
| 01:58 AM 23-Mar-24 |