Client: Commonwealth of Massachusetts
Title: Data Developer
Location: 100 Hancock Street, Quincy, Massachusetts 02171
Schedule: Hybrid
Pay Range: $60-70/Hr
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.
The primary work location for this role will be 100 Hancock Street, Quincy, Massachusetts
02171. The work schedule for this position is Monday through Friday, 8:00AM to 4:00PM EST.
This position would be expected to follow a hybrid model of reporting to work that combines
in office workdays and work from home days as needed.
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