Data Warehouse contractor

JOB DUTIES:

Develop reports and data visualizations using Tableau Server

 Perform ETL development and manage data exchange on AWS and Azure platforms

 Provide ad-hoc reports and extract based on user requests

 Provide gap analysis of current data extract process

 Identify remediation of data extract process gaps and propose solutions

 Validate results of all extracts and reports

 Interact on a professional basis with internal and external staff in a personable manner

 Develop reports for general, financial, clinical and case management, Managed Care, and 

Health Care and payment Reform purpose as requested.

 Support on-going development of cost, utilization and other reporting metrics, including 

collaboration with business program managers for MCO, HIX, and MMIS source data

 Communicate business requirements to Cognos and Oracle developers and work with 

them to implement solutions for the business community.

 Communicate progress, or impediments to progress, to users and managers.

 Recode existing macro-based code, including remediation as approved

 Review technical documents and test plans, test results and coordinate implementation 

activities with end-users and Data Warehouse staff

 Organize and maintain workload and work independently with limited supervision

 Participate in, and contribute to, team projects and meetings

SKILLS AND QUALIFICATIONS (Special Skill Set, Abilities & Knowledge):

 Mange assigned requests from a variety of diverse business users.

 Understand business requirements, and regulatory needs and their impact on business 

and DW 

 Maintain comprehensive code and documentation consistent with DW practice and 

policy

 Generate accurate queries and outputs consistently and under pressure

 Evaluation requests, gather business requirements and creatively develop solutions, 

generating accurate queries and outputs consistently and under pressure

 Improve and innovation processes and programs that meeting user needs

 Produce standard and ADHOC reports using various tools and data sources

 Conduct advanced data mining in a timely and accurate manner as required

 Produce business and system documentation based on EOHHS standards

EDUCATION and EXPERIENCE: (Education, Year’ Experience & Certificates):

 BS in Computer Science, related degree, or equivalent experience

 Extensive SQL experience within a data warehouse environment required

 3+ years’ experience working as a programmer/developer, preferably in healthcare