- 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 extracts 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 purposes 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 MassHealth 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)
- Manage 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
- Evaluate requests, gather business requirements and creatively develop solutions, generating accurate queries and outputs consistently and under pressure
- Improve and innovate processes and programs that meet 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, Years’ 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