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 AOC QA Tester (750142) Create date: 15-Nov-2024 No of Submissions : 2 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 11/20/2024 Client Info : 2258 Note: * Onsite * The Quality Assurance Tester is responsible for ensuring the overall quality and reliability of our software products that support the.... (This job is for - AWS NET FRAMEWORK UI Jobs in AR LittleRock Tester - (in Little Rock, AR)) NCDIT - Technical Specialist- Expert (750606) Create date: 14-Nov-2024 No of Submissions : 2 Start date : 11/04/2024 End Date : 05/06/2025 Submission deadline : 11/15/2024 Client Info : NCDIT Note: * Agency Interview Type : Either Webcam Interview or In Person * Remote Description : Contractor Title: Cloud Enginee.... (This job is for - Azure AWS GCP Jobs in NC Raleigh Specialist - (in Raleigh, NC)) 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))    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 Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)