State of Massachusetts
Database Administrator/ETL Developer
State of Massachusetts - Boston, Massachusetts, us, 02298
Work at State of Massachusetts
Overview
- View job
Overview
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.
Job:
* Information Systems and Technology
Organization:
* State Lottery Commission
Title:
Database Administrator/ETL Developer
Location:
Massachusetts-Boston - 150 Mt. Vernon Street
Requisition ID:
2500044S
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.
Job:
* Information Systems and Technology
Organization:
* State Lottery Commission
Title:
Database Administrator/ETL Developer
Location:
Massachusetts-Boston - 150 Mt. Vernon Street
Requisition ID:
2500044S