Linux OS Shell Scripting ETL Experience AWS Cloud Medicaid Database Architecture A   Requirement id 102750 Job title Architect Job location in Quincy, MA Skills required Healthcare Experience, ETL Scripts, PL/SQL, Linux OS Shell Scripting ETL Experience Open Date 29-Jan-2020 Close Date Job type Not specified Duration 6 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Architect: Healthcare Experience, ETL Scripts, PL/SQL, Linux OS Shell Scripting ETL Experience Note: RTR form must be submitted Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/7/2020 Start Date: 2/17/2020 End Date: 8/16/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: 102750 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), Healthcare Experience job openings in Quincy, MA Jobs List ITS63 EHS FY21 Business Analyst 002-OPS-DWbfng -SP Create date: 01-Oct-2020 Note: Email Submission Note: RTR form must be submitted Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 10/8/2020 Start Date: 10/19/2020 End Date: 6/30/2021 Client: EHS Description: The Business Analyst, will be responsible for working with internal and extern.... (This job is for - job Jobs in MA Quincy Analyst - (in Quincy, MA)) ITS63 FY20 EHS Business Analyst 006- Bfjm -MMIS -SP Create date: 26-Feb-2020 Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 3/5/2020 Start Date: 3/16/2020 End Date: 9/15/2020 Client: EOHHS Description: This position is a Business Analyst on the Member/Managed Care team at MassHealth. .... (This job is for - Medicaid Medicare Jobs in MA Quincy Analyst - (in Quincy, MA)) ITS63 FY20 EHS Business Analyst 004-HIX -SP Create date: 20-Feb-2020 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: 2/27/2020 Start Date: 3/9/2020 End Date: 9/8/2020 Client: EOHHS Description: EOHHS is seeking an exceptional “Business.... (This job is for - job Jobs in MA Quincy Analyst - (in Quincy, MA)) ITS63 EHS FY20 Data Warehouse Developer 001-100H-Re-Post -SP Create date: 29-Jan-2020 Note: RTR form must be submitted. Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/10/2020 Start Date: 2/20/2020 End Date: 8/19/2020 Client: EOHHS Description: As a member of the Executive Office o.... (This job is for - job Jobs in MA Quincy Developer - (in Quincy, MA)) ITS63 EHS FY20 Senior Project Manager 015-MMIS -SP Create date: 29-Jan-2020 Note: RTR form must be submitted Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 2/10/2020 Start Date: 2/20/2020 End Date: 8/19/2020 Client: EOHHS Description: The ideal candidate must possess strong.... (This job is for - SDLC Jobs in MA Quincy Manager - (in Quincy, MA))    Healthcare Experience job openings in other states Jobs List Travel RN - 63039 Create date: 11-Jul-2024 No of Submissions : 4 Start date : 07/24/2024 End Date :10/26/2024 Submission deadline : 07/12/2024 Client Info : TN TDOC Position Location : On Site Description : ------------------------------------------------------ MENTAL HEALTH NURSES DAY SHIFT Jobs in TN Nashville Developer - (in Nashville, TN)) Project Manager, Sr - 62807 Create date: 28-May-2024 Hybrid No of submissions : 5 Start date : 07/08/2024 End date :12/30/2024 Submission deadline :06/10/2024 Client info : TN TennCare *Note : This is a hybrid position - only candidates in middle Tennessee and able to commute to Nashville, TN regularly will be considered. .... (This job is for - job Jobs in TN Nashville Manager - (in Nashville, TN)) Registered Nurse 1 - 60851 Create date: 21-May-2024 No of Submissions : 15 Start date : 06/01/2024 End date : 01/01/2025 Submission deadline : 06/30/2024 Client info : TN MHSAS Note : * Position Location : On Site Description : Currently licensed as a Registere.... (This job is for - Jobs in TN Chattanooga Consultant - (in CHATTANOOGA, TN)) Social Worker 2 - 62355 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline :03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : The Clinical Care Team will take referrals from primary care providers and.... (This job is for - Jobs in TN Knoxville Consultant - (in Knoxville, TN)) Social Worker 2 -62365 Create date: 14-Mar-2024 start date : 03/11/2024 End date :06/30/2024 submission deadline :03/22/2024 client info : TN DOH Note: * Position Location: Hybrid Description : Social Worker Supervisor · Team Lead: Funct.... (This job is for - Jobs in TN Jackson Consultant - (in Jackson, TN))    Healthcare Experience job openings in MA Jobs List ITS63 EHS FY20 Data Analyst 003 -DSRIP -SP Create date: 05-Mar-2020 Note: Email Submission Note: RTR form must be submitted Note: Total number of positions sought: 1 Note: Maximum number of resumes per ITS63 Vendor: 3 Submission Deadline: 3/12/2020 Start Date: 3/23/2020 End Date: 9/22/2020 Client: EOHHS Description: Under the general directi.... (This job is for - job Jobs in MA Boston Analyst - (in Boston, MA)) ITS63 FY20 EHS Business Analyst 005-HIX -Op Specialist -SP Create date: 21-Feb-2020 Note: RTR form must be submitted. Note: Email Submission Note: person must be local Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 3/5/2020 Start Date: 3/16/2020 End Date: 9/15/2020 Client: EOHHS Description: The Massachusetts Health Insurance Exch.... (This job is for - Implementation Jobs in MA Boston Analyst - (in Boston, MA)) Healthcare Business Analyst Create date: 22-Jun-2015 NOTE : START DATE : 07/02/2015 SUBMISSION DEADLINE : 06/26/2015 CLIENT INFO : Winter Wyman Companies DESCRIPTION : -Location- Worcester -Rate- 60 (flex) -Duration- 6-12 mo -Must be able to interview in person -Must currently be on your payroll -Must have excellent commu.... (This job is for - ICD 10 ICD9 Jobs in MA Worcester Analyst - (in Worcester, MA)) (Architect: Healthcare Experience, ETL Scripts, PL/SQL, Linux OS Shell Scripting ETL Experience in Quincy, MA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)