Commonwealth of Massachusetts

Lead ETL Developer - (2400017G)

Description

The Executive Office of Labor and Workforce Development (EOLWD) is responsible for seven agencies and departments under this organization. EOLWD and its agencies are committed to developing a world-class, highly skilled labor force to support business growth and innovation in the Commonwealth.

EOLWD is seeking to hire a highly motivated individual to join the team as a Lead ETL Developer. The Lead ETL Developer will be responsible for creating short-term tactical solutions to achieve long-term objectives and an overall application and data management roadmap. This individual will ensure a positive end-user experience, application availability, and address errors efficiently, as well as oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.

The primary work location for this role will be 100 Cambridge St., Boston, Massachusetts 02114. The work schedule for this position is Monday through Friday, 9:00AM to 5: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.

Duties and Responsibilities:

Strategy & Planning

• Create short-term tactical solutions to achieve long-term objectives and an overall application and data management roadmap.
• Assist with assessing and determining governance, stewardship, and frameworks for managing data across the organization.
• Ensure design governance across projects, applications, and infrastructure.
• Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement.
• Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks.
• Develop and deliver long-term strategic goals for data integration standards in conjunction with data users, department managers, clients, and other key stakeholders.
• Ensure that data strategies and architectures are in regulatory compliance.

Operational Management

• Ensure a positive end-user experience.
• Develop integration process data flows and data mapping analyses.
• Address data-related problems regarding systems integration, compatibility, and multiple-platform integration.
• Develop and promote data integration methodologies and standards.
• Act as an advocate of data integration and management, including coaching, training, and career development to staff.
• Develop and implement key components to create testing criteria to guarantee the fidelity and performance of data architecture.
• Identify and develop opportunities for code and data reuse, migration, or retirement of systems.
• Assist with the selection and implementation of the appropriate methodologies, standards, tools, software, applications, and systems to support data technology goals.
• Oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.

Required Knowledge, Skills, and Abilities:

• A minimum of five (5) years of experience in an application or database production support role.
• A minimum of five (5) years of experience with scripting and object-oriented programming languages. 
• A minimum of five (5) years of experience of relational database experience.
• Three (3) + years of experience with Informatica IICS.
• Three (3) + years of experience with Snowflake.
• Familiarity with Power BI development, GitHub, and GitHub Actions.
• Ability to manage multiple priorities and workstreams simultaneously and deliver under tight deadlines.
• Demonstrated ability to learn new technology and tools.
• Ability to observe steps and ascertain success of step or failure and root cause of step(s).

Qualifications

First consideration will be given to those applicants that apply within the first 14 days.

Minimum Entrance Requirements:

Applicants must have at least (A) five years of full-time, or equivalent part-time, professional experience in electronic data processing, of which (B) at least three years must have been in work in which the major duties included computer systems analysis, or (C) any equivalent combination of the required experience and the substitutions below.

SUBSTITUTIONS:

I. An Associate's degree with a major in the field of data processing or computer programming may be substituted for a maximum of one year of the required (A) experience.*

II. A Bachelor's degree with a major in the field of data processing or computer and/or information science may be substituted for a maximum of two years of the required (A) experience.*

III. A Graduate degree with a major in the field of data processing or computer and/or information science may be substituted for a maximum of two years of the required (A) experience.*

IV. A diploma for completion of a two year full-time, or equivalent part-time, program in a recognized non-degree granting business or vocational/technical school above the high school level with a major in the field of computer programming may be substituted for a maximum of one year of the required (A) experience.* 

V. An official transcript from a recognized business or vocational/ technical school as evidence of completion of a program consisting of at least 650 hours of instruction in the field of computer programming maybe substituted for a maximum of one year of the required (A) experience.*

VI. Graduation from the data processing course of a recognized vocational/technical high school may be substituted for a maximum of one year of the required (A) experience.

• Education toward such a degree or diploma will be prorated on the basis of the proportion of the requirements actually completed.

NOTE: No substitution will be allowed for more than two years of the required (A) experience.

NOTE: No substitution will be allowed for the three years of the required (B) experience.

Special Requirements: None.

Comprehensive Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

Want the specifics? Explore our Employee Benefits and Rewards!

An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.

Official Title: Edp Systems Analyst IV

Primary Location

: United States-Massachusetts-Boston-100 Cambridge Street

Job

: Information Systems and Technology

Agency

: Department of Workforce Development

Schedule

: Full-time

Shift

: Day

Job Posting

: Feb 21, 2024, 7:15:36 PM

Number of Openings

: 1

Salary

: 80,750.80 - 117,600.60 Yearly

If you have Diversity, Affirmative Action or Equal Employment Opportunity questions or need a Reasonable Accommodation, please contact Diversity Officer / ADA Coordinator: Dennis Johnson - 6176265111

Bargaining Unit: 06-NAGE - Professional Admin.

Confidential: No

Potentially Eligible for a Hybrid Work Schedule: Yes

Read Full Description