Database Administrator/ETL Developer

Commonwealth of Massachusetts; Boston (MA); Hybrid; USD 91,000 - 121,000; Full time

Job summary

An established industry player is seeking a Database Administrator/ETL Developer to join their dynamic team. This role involves monitoring and maintaining databases, developing ETL processes, and ensuring data quality and integrity. The successful candidate will work in a fast-paced environment, collaborating with various teams to optimize data flow and support analytics. With opportunities for training and development, this position promises to enhance your skills while contributing to impactful projects. Join a forward-thinking organization that values innovation and teamwork.

Qualifications

• Experience with relational databases and ETL processes.
• Knowledge of Linux and Windows operating systems.

Responsibilities

• Monitor and maintain databases and ETL processes.
• Collaborate with cross-functional teams for data flow.

Skills

SQL

Database Performance Optimization

Problem-Solving Skills

Communication Skills

Education

Bachelor's Degree in Computer Science

Tools

MySQL

PostgreSQL

SQL Server

AWS

Azure

Google Cloud

Microsoft Excel

Microsoft Word

Microsoft Outlook

Microsoft SharePoint

Job description

An Official website of the Commonwealth of Massachusetts

Job Description - Database Administrator/ETL Developer (2500044S)

Job Description

Database Administrator/ETL Developer - ( 2500044S )

Description

JOB SUMMARY

The DBA/ETL Developer will be responsible for monitoring, maintaining, creating and supporting MSLC databases and ETL processes as assigned by the Lead DBA/ETL Developer. The DBA/ETL Developer will maintain software, scripts and reports that access MSLC databases and will contribute ETL expertise with integration, transformation, and loading of data. The DBA/ETL Developer will assist the data analytics team with troubleshooting SQL queries. This is an exciting opportunity to work in a fast-paced environment, collaborating with cross-functional teams to ensure efficient data flow and accurate analytics for our organization.

Note: If your experience is stronger in one area versus the other, training will be available.

ESSENTIAL FUNCTIONS

• Using DBMS(s) currently employed by the MSLC, create and maintain databases accessed by all MSLC users.
• Solid understanding of SQL and experience working with relational databases (e.g., MySQL, PostgreSQL, SQL Server).
• Monitor MSLC databases and proactively perform modifications, optimization adjustments, updates and upgrades as necessary.
• Update, modify, reconfigure, backup and restore systems and servers.
• Experience with database performance optimization.
• Familiarity with data warehousing concepts and methodologies.
• Strong problem-solving skills and the ability to analyze complex data integration challenges.
• Excellent communication skills to collaborate effectively with cross-functional teams.

· Design, develop, test, and maintain ETL processes to ensure the accurate and efficient movement of data from various sources into our data warehouse.

· Optimize and fine-tune ETL workflows for performance and scalability, identifying and resolving bottlenecks and inefficiencies.

· Ensure data quality and integrity through validation and cleansing processes.

· Stay current with industry trends and best practices in ETL development and data integration.

· Knowledge of IT best practices for maintaining patch management, documentation, and archiving protocols.

· Perform additional duties and responsibilities as assigned.

NOTE: Per the bargaining unit contract, the salary for this position will increase by 2% effective July 13, 2025.

Qualifications

· Bachelor’s degree in computer science or equivalent work experience.

· Knowledge of Linux and Windows operating systems, with demonstrated ability to navigate in each and to write simple scripts and reports.

· Ability to use standard Microsoft software (Excel, Word, Outlook, Sharepoint).

· Experience with cloud platforms such as AWS, Azure, or Google Cloud is a plus.

The Massachusetts State Lottery Commission 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.

Primary Location

Job

Job

: Information Systems and Technology

Agency

Agency

: State Lottery Commission

Schedule

Schedule

: Full-time

Shift

Shift

: Day

Job Posting

Job Posting

: Apr 28, 2025, 7:54:20 AM

Number of Openings

Number of Openings

: 1

Salary

: 91,196.50 - 120,403.61 Yearly

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

Potentially Eligible for a Hybrid Work Schedule : Yes