Data Developer Apply
POSITION OVERVIEW DATA DEVELOPER
The Commonwealth of Massachusetts' Executive Office of Health and Human Services is currently seeking an exceptional individual to join the EHS IT team. This is an exciting opportunity to join a highly skilled team and contribute to critical and highly visible projects and processes within the Executive Office of Health and Human Services.
As a member of the Executive Office of Health and Human Services Enterprise Data Management & Engineering, the Senior Data Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programs. Creates tactical solutions to achieve long-term objectives and an overall data management roadmap. Establishes methods and procedures for tracking data quality, completeness, redundancy, and improvement. Conducts data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks. Develops integration process data flows and data mapping analyses. Addresses data-related problems regarding systems integration, compatibility, and multiple-platform integration. Extensive knowledge and skill with relational database structures and cloud engineering. May also act as team or project leader on major applications projects. The ideal candidate must demonstrate confidence, creativity, and keen problem-solving abilities.
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
- Involve in Design and development of cloud-based data management systems.
- Understand and translate business requirements into user acceptable solutions.
- Generate data to meet specific business needs that require sourcing data from appropriate source systems.
- Document code and processes that can be used by all interested parties, including the business, Federal Reporting team, data warehouse team members and others as directed.
- Provide query writing support to other analysts and end users.
- Be able to understand and implement user requests technically and operationally.
- Be available to attend meetings and participate on calls with users and others as requested or directed.
- Participate in team meetings and technical reviews as requested.
- Communicate effectively with business, peers and management, so they are kept aware of requirements, project status, concerns, processing roadblocks.
- Ensure timely delivery of solutions meeting requirements and expectations
- Expertise in basic MassHealth knowledge, practices and processes.
- Focused attention to detail in all assignments that fall under the purview of the EDME reporting team.
- Continually develop skills in SAS and/or SQL, Tableau and Snowflake.
- Support analytic and business requirements gathering efforts for ongoing reporting.
- Interact with business users and communicate business needs to the Federal Reporting and Data Warehouse development teams when necessary.
- The data analyst/developer is responsible for generating tables, files, reports and datasets upon request and as directed by team lead, senior staff or management
- Deliver product to satisfy business request by required deadline.
- Generate code in SAS or in SQL to read data from the EHS Data Warehouse and output files in a format as requested by users or others.
QUALIFICATIONS: Minimum allowable
-
- 5+ years of experience in Cloud Data warehousing, data analysis, BI Reporting, enterprise and business information system architectures, and system engineering
- Possess High level SQL (Preferably in Oracle and Snowflake) and/or SAS skills.
- Have experience with data warehouse-based operations, analytic functions and query generation.
- 3-5 years of experience developing Cloud-based (AWS) data solutions.
- 5+ years of Cloud database platform experience such as Snowflake.
- Experience in creating and maintaining end-to-end data pipelines.
- Strong communication skills comfortable explaining/proposing solutions to technical stakeholders, vendors, and business consumers.
- Experience working with a large, multi-terabyte enterprise data platform in Cloud.
- Experience working with highly sensitive health care information and familiar with HIPAA and other data privacy controls.
- Ability to build trusted relationships with stakeholders, managers, and employees at all levels
- Ability to quickly assess/summarize information and effectively identify issues, risks, solutions
- Demonstrated strength in multi-tasking and application of strong logical reasoning skills
- Familiarity with eligibility and claim based system and Medicaid Federal Reporting processes
PREFERRED SKILLS AND CERTIFICATIONS
- Amazon Web Services (AWS) Certification
- Snowflake and/or SAS certification
- Cognos and/or Tableau reporting experience
- Experience with Federal Reporting for Medicaid is a plus