Colorado Technology Jobs

Colorado Jobs

Job Information

Apex Systems, Inc Allscripts Report Writer (1101902) in Denver, Colorado

Allscripts Practice Management Report Writer - OptumCareWe are looking for a SQL report writer with SSRS experience deeply knowingAllscripts Practice Management. We need to build productivity and OPSreports, maybe some dashboards. We need help also with one off APM dataanalysis. Contract duration will be 2 months (and maybe more).Notes from the ManagerReports to Craig Lamb (CIO on Southwest Medical Associates SW NV)Span across 4 statesAllscripts PM - billing system for 400+ physician entity (multi-specialty)Migrating from GE Platform that is 20 years oldWorking on this project for 2 yearsLot of contracts - managed care like and value based type of businessTake patient pop from HMO and do a lot of care measures to properly manage thepatientLooking for reporting vertical whatsoeverPartnered with Allscripts to do some of the reporting but their reportingvertical is offshoreDon't have the business understandingNeed someone who has done reporting on APM and understands business in generalClaims vouchers, for exampleTheir data is unique and they have complexity of system and nuances of thedataResource will work with Amanda primarily and the business secondarilyShe doesn't want to have to teach them APM or healthcare business aroundwhat is a claim, an appointment with managed careDoesn't mind bringing someone up to speedGo-live is in 2 weeksNeed to deliver in 30-60 daysUnique data situations and business needsShe knows most of the tables and structures - she will work with them andhelp them along the wayReally know SQL beyond a select statementReports are complexity from a business model - not your basic statements orreportsMay require writing some codeTalk to the business and make them feel comfortable that they understand theneed and appreciate the differences in the data and scenarios coming inLoad and configure the data into the new systemCome prepared with knowledge of how to write SQL in APMJust 1 resource need right nowWants this person to own this after they build the verticalLift the entire data, mash it together, and create the reports by writing codeUnderstand how Allscripts writes thisMimicking in SSRS b/c they need additional data b/c there is counter datathat needs to be balancedOperations, productivity, front-end reportsOther person they have will do back-endRev cycle and financial reportsAllscripts is trickyIt has to be Practice ManagementTouchWorks is clinical - she doesn't want TouchWorks experienceStructure of tables and databases are differentFinancial reports, vouchers, statements, appointments - that is what she needsThey have done co-developments with AllscriptsVersion just got out in the market in August - they are doing patching andthings that are uniqueThey will teach them that - someone coming in wouldn't know thisGet their hands on the code that is unique and new for AllscriptsUse Tableau to join and do a lot of dashboardsIf they know Tableau, that is a plus but not requiredGet data into a table using SQL is more importantSSRS is more important as wellStrong on SQL, strong on APM, Tableau is not a requirementDon't have a warehouse - reporting on transactionalThis person needs to have good documentationThey will give them requirements, and then they will need to write code togive it to someone to own itEEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allowdiscrimination on the basis of race, color, religion, creed, sex(including pregnancy, childbirth, breastfeeding, or related medicalconditions), age, sexual orientation, gender identity, nationalorigin, ancestry, citizenship, genetic information, registereddomestic partner status, marital status, disability, status as a crimevictim, protected veteran status, political affiliation, unionmembership, or any other characteristic protected by law. Apex will considerqualified applicants with criminal histories in a manner consistent with therequirements of applicable law. If you have visited our website in search ofinformation