ERwin PLSQL Analytical Skills Linux OS Shell Scripting AWS Cloud Medicaid Healthca   Requirement id 100352 Job title Architect Job location in Quincy, MA Skills required Database Architecture, SQL Code, ETL Scripts, ERwin PLSQL Analytical Skills Linux OS S Open Date 15-Nov-2019 Close Date Job type Not specified Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Database Architecture, SQL Code, ETL Scripts, ERwin PLSQL Analytical Skills Linux OS S Note: Email Submission Note: RTR form must be submitted. Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 11/25/2019 Start Date: 12/5/2019 End Date: 5/4/2020 Client: Executive Office of Health and Human Services (EOHHS) Description: As a member of the Executive Office of Health and Human Services, (EOHHS), data warehouse, (DW), team, The Data Warehouse Architect, DWA, will be responsible for analysis, design, coding, and testing of moderate to extremely complex data extraction routines and report development. The DWA will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a Business Analyst. The DWA will also support existing warehouse infrastructure and provide input on best practices and potential efficiencies. The DWA will work on multiple assignments concurrently and be required to complete work by aggressive due dates. This DWA / Developer role may work in both the Architect capacity as well as an ETL Developer capacity. This role uses a range of expert technical skills based on a keen knowledge of data warehouse concepts and must be highly proficient with Oracle SQL. The Architect will help identify and implement continuous improvement opportunities. The Architect is responsible for regular peer code reviews and frequently mentors others. The ideal candidate must demonstrate that they have relevant experience, creativity, a keen problem-solving ability along with collaboration and facilitation skills to work with a broad range of people while keeping projects on track. DUTIES: • Creates data models and designs to meet specific business needs • Determines appropriate sourcing and storage of data from multiple source systems • Understands and is able to translate business requirements into Data Warehouse solutions • Codes Oracle ETL scripts that will extract data from an operational database and populate the staging and target data warehouse schemas • Documents code and processes for distribution to all interested parties • Documents design using industry standards including ERWIN diagramming • Provides query writing support and tuning expertise to analysts and end users • Develops shell scripts for production job automation • Work in a 24x7 environment which requires on-call rotation QUALIFICATIONS: • 5+ years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data architecture modeling • Exceptional Oracle SQL skills and PL/SQL skills • Hands on experience with set based operations, analytic functions and query hints • Command of data warehouse modeling concepts is required • Strong problem solving and analytical skills • Strong ERD modeling • Proficiency with Linux and shell scripting • Experience working with a large, multi-terabyte data warehouse ADDITIONAL EXPERIENCE which will distinguish candidates: • BS in Computer Science or related degree, or equivalent experience • Medicaid or other healthcare or claims processing experience • AWS (Cloud) Experience • Informatica ETL experience   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 100352 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1), Database Architecture job openings in Quincy, MA Jobs List ITS63 EHS FY19 DW EA Sr Application Architect 004-Re-POST-SP Create date: 05-Apr-2019 Note: RTR form must be submitted. Note: Maximum number of resumes per ITS63 Vendor: 2 Submission Deadline: 4/12/2019 Start Date: 4/22/2019 End Date: 6/30/2019 Client: EOHHS Description: The Commonwealth of Massachusetts is currently seeking exceptional individuals to join the Data Warehous.... (This job is for - job Jobs in MA Quincy Architect - (in Quincy, MA))    Database Architecture job openings in other states Jobs List Project Manager 3 - 115361 - SP Create date: 20-Mar-2023 start date : 04/10/2023 End date : 11/03/2024 submission deadline : 3/24/2023 4:00:00 PM client info : DESE Note : * Interview Process: Virtual * Duration of the Contract: 1.5 years * 100% remote work Descr.... (This job is for - job Jobs in MO JeffersonCity Manager - (in Jefferson City, MO)) Project Manager 3 - 114466 - SP Create date: 17-Feb-2023 start date : 03/06/2023 End date : 11/03/2024 submission deadline : 02/27/2023 1:00 pm CST. client info : DESE Note : * Interview Process: Virtual * Duration of the Contract: 1.5 years * Hybrid position: * The expectation is for occasional onsite meetings. .... (This job is for - job Jobs in MO JeffersonCity Manager - (in Jefferson City, MO)) Senior Application DBA - Aurora/Postgres - 113851 - SP Create date: 31-Jan-2023 start date : 03/06/2023 End date : 5 Years from projected start date submission deadline : 2/7/2023 4:00:00 PM client info : DWS Note : * Position is primarily remote, however the contractor must reside in Utah. Description : job Jobs in UT SaltLakeCity Consultant - (in Salt Lake City, UT)) PR111124-R13221 Job1440 Database Administrator (Oracle) -SP Create date: 24-Oct-2022 Bid URL: https://service.ariba.com/Supplier.aw/ad/collabReqDetail?requestDocId=30000000000000001024222134&anp=Ariba&community=3 Note: Exhibit F: Resume Self - Certification form must be signed by the candidate Submission Deadline: 11/4/2022 2 pm ET Start Date: 11/14/2022 End Date : 6/30/2023 Client: Flori.... (This job is for - job Jobs in FL BocaRaton Administrator - (in BOCA RATON, FL)) Doc192521 Job 1440 Database Administrator-Boca Raton -SP Create date: 18-Mar-2022 Bid URL: http://sourcing.myfloridamarketplace.com/Sourcing/Main/ad/webjumper?passwordadapter=SourcingSupplierUser&username=coolsoft1&itemID=iim480.fd&awcharset=UTF-8 Note: This is NOT a remote position. Note: We are accepting THREE (3) candidate submissions per vendor for this VACANT position. Submission Deadline: 3/31/2.... (This job is for - job Jobs in FL BocaRaton Administrator - (in BOCA RATON, FL))     (Architect: Database Architecture, SQL Code, ETL Scripts, ERwin PLSQL Analytical Skills Linux OS S in Quincy, MA)

Featured Jobs Troubleshooting Engineer (Jobs in Des Moines, Iowa) Application Developer (Jobs in Richmond, Virginia) Business Analyst Business Analyst (Jobs in Richmond, Virginia) Consultant (Jobs in Murfreesboro, Tennessee) TFS Automation Analyst (Jobs in Dimondale, Michigan) Cloud Architect (Jobs in Lansing, Michigan) GitHub Consultant (Jobs in Lansing, Michigan) IT Developer (Jobs in Atlanta, Georgia) Microsoft Consultant (Jobs in ANDERSON, South Carolina) Business Analyst JAD SQL Analyst (Jobs in Lansing, Michigan)