Data Processing Automation In The Windows Platform Microsoft Technologies In BIDW   Requirement id 53358 Job title Specialist Job location in Little Rock, AR Skills required ANSI SQL., Data Modeling (DW Plus Dimensional), BI Data Integration Specialist, Data Processing Automation In The Window Open Date 03-May-2016 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: ANSI SQL., Data Modeling (DW Plus Dimensional), BI Data Integration Specialist, Data Processing Automation In The Window Description: Supporting Arkansas Insurance Departments role in the Affordable Care Act implementation with DW/Data Mart creation, Data Integration and Reporting using Microsoft and other technologies. Work hours will vary from week-to-week. Work will need to be performed at the Client Site. Local candidates preferred. Experience in Affordable Care Act QHP and Dental regulatory data processing highly desired. This senior role and calls for ability to work alone and deliver with minimal supervision and guidance. This is much more than a BI developer role. Candidate must be able to single handedly design and create sound Data Warehouse/Data marts & deliver reports using Microsoft technologies (SQL Server/SSIS/SSRS etc.). Person should be able to advise and engage with experienced Server Administrators, DBAs and/or BI experts on development and production standards, security, best practices and architecture implementations while building DW/DM/ETL/Reporting environments using Microsoft technologies. Data modelling skills will be needed from conceptual models to physical models. Candidate will be responsible for producing quality reports with an eye for detail. Experience working with regulatory data in the Affordable Care Act landscape is highly desirable. This especially relates to data handling within the Plan Management and Network Adequacy domains. This role will call for the ability to engage with non-technical customers, anticipate their data needs and deliver on them. Excellent communication skills needed (both oral as well as written) with ability to elicit requirements from non-technical Subject Matter Experts and organization leaders & executives. It is expected that the candidate would be able to immediately demonstrate at site, self-sufficient mastery using Microsoft technologies such as SQL, SSIS & SSRS. Person should be skilled in writing and maintaining complex SQL. High quality automation should be second nature to this person. Automation should be replete with failures alerts and logs for quick debugging. Candidate should be conversant with data visualization using Tableau Desktop. Candidate should be able and willing to quickly learn and use new tools as needed. Candidate must be able to produce quality documentation. Responsibilities will include (but not limited to) • Collaboration with RHLD leadership to develop NA technical support for regulatory goals • Adjustment of data imports and reporting to reflect changing requirements • Management of process to collect and aggregate network data from issuers • Assistance to regulatory staff in assessment of issuer submissions • Documentation of data processes • Training of RHLD staff These other areas of assistance needed are: •Enrollment Analytics: processing of enrollment data submitted on a biweekly basis by the carriers and publication of reports for internal and external use •Claims Data Usage (new): exploration industry Claims data within the ACHI hosted All Payers Claims Database towards supporting various health regulations •Systems Integration with Complaint Handling systems (new): methods and interfaces to integrate other regulatory systems with the complaint handling system already in place •Guide Management System and Moodle Administration data migration: assistance in transition of data from the Guide Management System and Moodle to replacement management systems •Public facing Consumer Assistance information: processing and publication of consumer assistance lists and maps •Quality Improvement initiative (new): a new area where Insurance companies would be required to provide data for the first time with the state providing oversight. What the industry engages in and what they would report is unknown. The state has the potential of evidence bas   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 53358 while calling.   Other jobs in AR: Acxiom (1), Arkansas (2), Little Rock (21), Rock (2),    ANSI SQL. job openings in other states Jobs List Data Analyst - 45636 Create date: 05-Apr-2019 Candidate must be your W2 Employee. Job Description : Metadata Analyst (BSC 6) 6 Month Contract+EXT Minneapolis, MN Project: This role is to lead a large, growing internal project to baseline data sources across programs. It started with Financial Crimes.... (This job is for - Jpg Jobs in MN Minneapolis Analyst - (in Minneapolis, MN))     (Specialist: ANSI SQL., Data Modeling (DW Plus Dimensional), BI Data Integration Specialist, Data Processing Automation In The Window in Little Rock, AR)

Featured Jobs Scrum Analyst (Jobs in Lincoln, Nebraska) MS Consultant (Jobs in Columbia, South Carolina) C# Engineer (Jobs in Lansing, Michigan) - Consultant (Jobs in Nashville, Tennessee) Dataverse Sharepoint Developer (Jobs in Raleigh, North Carolina) Large Administrator (Jobs in Denver, Colorado) CICS Metadata Architect (Jobs in Raliegh, North Carolina) Leadership Developer (Jobs in ANDERSON, South Carolina) Communications Analyst (Jobs in Lansing, Michigan) Editing Consultant (Jobs in Lansing, Michigan)