AWS SQL Facets OLTP SSIS ODS ETL SQL Query Development Data Modelling Analyst (Job   Requirement id 108073 Job title Analyst Job location in EDEN PRAIRIE, MN Skills required AWS, SQL Server, Facets, OLTP SSIS ODS ETL SQL Query Development Open Date 08-Jul-2020 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: AWS, SQL Server, Facets, OLTP SSIS ODS ETL SQL Query Development client info : UnitedHealth Group ** Note: * OLTP (Online Transactional Processing) data => Day to Day transactions * OLAP (Online Analytical Processing) data => Reporting Analytical data Description: 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 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.)   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 108073 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), AWS job openings in EDEN PRAIRIE, MN Jobs List Sr Engineer Microservices/Cloud - 68833 Create date: 26-Oct-2020 Note :Remote until after COVID. Job Description : Microservices/Cloud Developer Optum | Eden Prairie, MN 6 Month Contract PROJECT: Provider Link Portals are the application provider self-service to the Providers. They can save their provider provider preferences, view the status of the document.... (This job is for - Azure AWS Jenkins Jobs in MN EdenPrairie Engineer - (in EDEN PRAIRIE, MN)) Data Modeler Data Analyst - 64744 Create date: 07-Jul-2020 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. .... (This job is for - ODS AWS Jobs in MN EdenPrairie Analyst - (in EDEN PRAIRIE, MN)) IT - Applications Development Consultant III - 64685 Create date: 06-Jul-2020 Candidate must be our W2 Employee. Candidate must be local : Yes We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Android Developer UHG/Optum Eden Prairie, MN - will be remote for the forseeable future PROJECT: Mobile Apps for Optum .... (This job is for - Cloud AWS Azure Jobs in MN EdenPrairie Consultant - (in EDEN PRAIRIE, MN)) DevOps (Kafka) - 63515 Create date: 22-May-2020 Job Description : Top 3 requirements? Kafka Angular Must have experience with integrations Candidates with Kafka and restfiul integration: • Kafka Service now and Restful • Interact with restful and know how service now interacts with r.... (This job is for - AWS Kafka Angular Jobs in MN EdenPrairie Consultant - (in EDEN PRAIRIE, MN)) DevOps Engineer (Cloud) - 61366 Create date: 20-Mar-2020 * Candidate must be our W2 Employee. * We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : DevOps Engineer (Cloud) Location: Eden Prairie, MN (must sit on-site) Projected 6 month contract-to-hire Conversion salary competitive Our .... (This job is for - Azure AWS Jobs in MN EdenPrairie Engineer - (in EDEN PRAIRIE, MN))    AWS job openings in other states Jobs List DOAS Systems Administrator 1 (744658) Create date: 12-Aug-2024 No of Submissions : 2 start date :09/01/2024 End date :06/30/2025 submission deadline :08/16/2024 client info : DOAS Note: * Agency Interview Type:Either Web Cam or In Person * Hybrid Description : Systems Admin - I.... (This job is for - AWSCloudWatch Jobs in GA Atlanta Administrator - (in Atlanta, GA)) Technical Architect-III-RFS 131748 Create date: 16-Jul-2024 Maximum Submissions per Supplier : 2 Start date : 07/15/2024 End Date : 06/30/2025 Submission deadline : 06/19/2024 by 8:00 A.M. CST Client Info : Madison, WI - IT - WHS - DBS – BITS Department of Wisconsin Historical Society (WHS) Note : * Interview Process: • Teams inte.... (This job is for - AWS Jobs in WI Madison Architect - (in Madison, WI)) Technical Architect III - 126501 Create date: 24-Jan-2024 Start date : 02/01/2024 End date : 1 Years from projected start date Submission deadline : 1/30 @4:00PM CST. Client info : UW - Madison Note : * Interview Process: Remote, Microsoft Teams * Duration: 1 year from start date * Onsite or Remote? Candidates MUST be WI res.... (This job is for - AWSDatabase Admin Jobs in WI Madison Architect - (in Madison, WI)) Cloud Architect-126091 Create date: 10-Jan-2024 Start date : 01/08/2024 End Date : 1 Years from projected start date Submission deadline :1/18/2024 at 10am EST Client Info : PDSS Note : * Interview Process: Virtual Interview via MS Teams video. * Duration: 1 Year with extension likely * This is a fully remote position - must be l.... (This job is for - Azure AWS DevSecOps Jobs in MI Dimondale Architect - (in Dimondale, MI)) NCDHHS- PSO IT Security Specialist St (723584) Create date: 09-Jan-2024 Remote Start date :10/30/2023 End Date :11/01/2024 Submission deadline :01/15/2024 Client Info :NCDHHS - Privacy and Security Office Description : ------------------------------------------------------ NC DHHS - Privacy and Security Office (PSO) requiring services of an IT Security Co.... (This job is for - AWS Azure Jobs in NC Raleigh Specialist - (in Raleigh, NC))    AWS job openings in MN Jobs List Cloud Operations Admin - 72598 Create date: 04-Mar-2021 Candidate must be our W2 Employee. Job Description: Cloud Ops Engineer This resource will be responsible for assisting with the migration of cloud environments from a company that has been acquired to the greater cloud footprint for the larger parent organization, adhering to security and compliance standards for cloud deploy.... (This job is for - AWS Azure Patching Jobs in MN Maplewood Administrator - (in Maplewood, MN)) Front End Engineer - Mid - 72535 Create date: 02-Mar-2021 Job Description: Ameriprise – Mid Level Front End Engineering Remote 12 month contract + Project Scope / Components: · This role is a Core Team for Ameriprise site. Anything prior to the log-in is the public (core) site, and thats what this resource will work. At this stage they dont have somet.... (This job is for - AWS HTML CSS CI CD Jobs in MN Minneapolis Engineer - (in Minneapolis, MN)) AWS Automation Engineer - 72342 Create date: 25-Feb-2021 We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description: 3M - AWS Infrastructure Automation Engineer 6-12 month contract 100% Remote Project · Seeking an AWS Infrastructure Automation Engineer to join our agile team to develop scalable, production grade, cloud .... (This job is for - AWS Python Jobs in MN Maplewood Engineer - (in Maplewood, MN)) UI Developer - 71925 Create date: 12-Feb-2021 Candidate must be our W2 Employee. Job Description: Lead React Developer Contract through August 2021 Remote Team Overview: · Good base started on where to go with the app · Current guy is awesome – a lead who can direct the team, understand best practices and has a full knowledge o.... (This job is for - React AWS HTML Jobs in MN SaintPaul Developer - (in Saint Paul, MN)) Cloud Application Developer - 70925 Create date: 15-Jan-2021 Candidate must be our W2 Employee. We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description: We are seeking a Cloud Application Developer to join a Corporate Research and systems lab function to develop scalable, production grade, cloud applications. In this role, you will leverage your experie.... (This job is for - AWS CI CD Jobs in MN Maplewood Developer - (in Maplewood, MN)) (Analyst: AWS, SQL Server, Facets, OLTP SSIS ODS ETL SQL Query Development in EDEN PRAIRIE, MN)

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)