ODS AWS OLTP Analyst (Jobs in Eden Prairie, MN)   Requirement id 108019 Job title Analyst Job location in EDEN PRAIRIE, MN Skills required ODS, AWS, BS Degree In Computer Science, OLTP Open Date 07-Jul-2020 Close Date Job type Contract to Hire Duration 5 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: ODS, AWS, BS Degree In Computer Science, OLTP Job Description : Position(s): Data Modeler/ Data Analyst role Project/Team/Role Details: They have a contract with Maryland and need to build a data warehouse to house data from 3k providers. Hundreds (of rows) of transactional data is being replicated into an ODS (Operational Data Store) temp. Challenges are 13 layer queries and non denormalized data are preventing accurate and efficient reporting. There are no dates stored on the individual lines of the claims, so cannot tell when the resolutions occurred. Claims are not closing since each line can have a different resolution like paid, denied, pended, and check cut. All lines in a claim must be paid in order for the claim to be considered paid, so they need a way to report this. Day to Day: Create a data warehouse of replicated OLTP data to OLAP data. Create a limited scope data mart for the healthcare claim data. Create dimensional data models for time and needed measures. Create data models that denormalize data needed for reporting. Tech Stack: Kato system ODS (like FACET) AWS WebServices environment SQL Server database on AWS cloud Replicated OLTP transactional data SSIS for ETL into ODS data mart Qualifications: • BS in Computer Information Systems, Computer Science, or related STEM field. Notes: OLTP (Online Transactional Processing) data => Day to Day transactions OLAP (Online Analytical Processing) data => Reporting Analytical data Must Have: • ETL SSIS package creation • Dimensional Data Modeling • SQL DBA / Developer skills • Advanced SQL query skills Strong Plus: • AWS cloud SQL Server DBA exp • Data Warehouse Creation exp • Reporting SSRS or PowerBI Screening Topics: • BI - SSIS • Data Analyst - SQL • Data Modeling - Erwin (If the candidate has this.) • Data Modeling - ER/Studio (If the candidate has this.) Search String: (Minnesota numbers ranging from 151 to 23 - Many more nationwide. Mix these up as needed.) • "SQL Server" AND ETL AND ("SSIS package" OR "SSIS process") AND ("Data Ware*house" OR "Data Mart") • "SQL Server" AND ("Data models" OR "Data modeling") AND ETL AND ("SSIS package" OR "SSIS process") AND ("Data Ware*house" OR "Data Mart") • "SQL Server" AND ("Data model" OR "Data modeling") AND ETL AND ("SSIS package" OR "SSIS process") AND ("Data Ware*house" OR "Data Mart") AND (OLAP OR Dimensional) • "SQL Server" AND ("Data model" OR "Data modeling") AND ETL AND ("SSIS package" OR "SSIS process") AND ("Data Ware*house" OR "Data Mart") AND (OLAP OR Dimensional) AND (AWS OR Azure)   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 108019 while calling.   Other jobs in MN: Coon Rapids (2), Duluth (6), Eagan (1), Edina (3), Little Falls (1), Maplewood (4), Mineapolis (1), Minneapolis (69), Minnesota (1), North Saint Paul (1), Plymouth (1), Roseville (2), Saint Cloud (3), Saint Paul (41), St Cloud (1), St Paul (5), Unknown (1),    ODS job openings in other states Jobs List NCDOT - SAP Developer/Programmer- Expert (663509) Create date: 16-May-2022 Start Date :05/14/2022 End Date :05/12/2023 Submission Deadline :05/18/2022 Client Info : Description : ***The candidate will work remotely until all staff return to site. At that time the candidate will be expected to work full time onsite. ***The candidate will need to use his or her ow.... (This job is for - ODS HANA SD Jobs in NC Raleigh Expert - (in Raleigh, NC)) Senior SAP/BI Developer Create date: 24-Apr-2020 Job Description: Our IT team is seeking a Senior SAP/BI Developer. The Senior SAP/BI Developer will be part of the SAP BI development team and is responsible for designing, developing, maintaining, modifying, testing, and implementing Business Intelligence/Business Warehouse (BI/BW) deliverables and supporting the production business int.... (This job is for - ODS Jobs in KY Frankfort Developer - (in Frankfort, KY)) BUSINESS ANALYST ENTRY - 8745-1 Create date: 16-Apr-2019 Start Date :05/13/2019 Submission Deadline :04/26/2019 Description : 1. REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE): Thoroughly knowledgeable with the University of South Carolina IMS and Cognos ODS data systems 2. Knowledgeable with Hummingbird OpenText 3. Extensive experience in .... (This job is for - Business Analyst ODS LMS Jobs in SC SPARTANBURG Analyst - (in Spartanburg, SC)) ODI Lead - J-11-385-490 Create date: 13-Mar-2019 Description: 1 Perform changes on ODI flows configuration and PL/SQL components to resolve incidents 2 Perform ODI servers recycle & trouble shoot any issues on server cluster instances and flows deployment 3 Identify and eliminate recurring issues on ODI flows configuration and batch jobs optimization on ODI Ent & ODI BI App.... (This job is for - ODI ODS Obiee Jobs in NJ BerkeleyHeights TechLead - (in BERKELEY HEIGHTS, NJ)) TS - Chef SME - J-11-257-887 Create date: 08-Sep-2017 Start Date : 08/28/2017 End Date : 12/15/2017 Submission Dead Line : 09/14/2017 Description : Role: Chef SME (Tier 2) 6 months onsite One Expert Consultant with Chef and repository use skills for a duration of six (6) months. Services will be performed with respect to assis.... (This job is for - SME ODS OLTP Jobs in NJ BRIDGEWATER Developer - (in Bridgewater, NJ))     (Analyst: ODS, AWS, BS Degree In Computer Science, OLTP in EDEN PRAIRIE, MN)

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) 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)