Database Administrator/ETL Developer

Massachusetts; Boston (MA); On-site; USD 60,000 - 95,000; Full time

Job summary

Join a dynamic team as a DBA/ETL Developer, where you'll play a key role in managing databases and ETL processes within a fast-paced environment. This position offers the chance to collaborate with cross-functional teams, ensuring efficient data flow and accurate analytics. You'll utilize your SQL expertise and problem-solving skills to optimize database performance and tackle complex data integration challenges. With opportunities for training and professional growth, this role is perfect for those eager to make a significant impact in data management and analytics.

Qualifications

• Bachelor’s degree in computer science or equivalent experience.
• Solid understanding of SQL and relational databases.

Responsibilities

• Monitor and maintain MSLC databases and ETL processes.
• Design, develop, and maintain ETL processes for data movement.

Skills

SQL

Database Performance Optimization

Problem-Solving

Data Warehousing Concepts

Communication Skills

Education

Bachelor's Degree in Computer Science

Tools

MySQL

PostgreSQL

SQL Server

AWS

Azure

Google Cloud

Microsoft Excel

Microsoft Word

Microsoft Outlook

SharePoint

Job 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.

· 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.