Data and Risk Management Analyst I

DescriptionThe Division of Banks (DOB) is currently accepting applications for the position of Data and Risk Management Analyst in the Data Analytics unit.The selected candidate will join a collaborative team of experienced data professionals who use data analytics to support the Division’s mission as the primary financial regulator for the Commonwealth of Massachusetts. The analyst will assist in designing, building, and maintaining automated data pipelines and other analytical tools, improving the Division's data collection and reporting processes. This position provides an opportunity to further develop technical and analytical skills while gaining valuable experience in financial regulation.About the Division:As an employee of the Division of Banks, you will contribute to the mission of the Division of Banks by ensuring a sound, competitive, and accessible financial services environment throughout the Commonwealth. The Division maintains public confidence in Massachusetts financial institutions through the oversight of state-chartered banks and credit unions as well as non-depository licensees doing business in Massachusetts. We are a consumer protection agency, and we support financial literacy education and programs benefiting residents across the Commonwealth. The majority of the Division's employees are Examiners who conduct a variety of on-site and off-site examinations of financial institutions and licensed entities under the Division's jurisdiction.At the Division of Banks, every employee’s ideas and experiences are welcomed. We value and respect that each individual brings different skills and perspectives that uniquely contribute to our agency and the work that we do. It is important that each employee feel empowered to contribute as this allows for more effective collaboration and better results. Within our workplace community, we offer a variety of training and mentoring to create and maintain learning environments that are inclusive, equitable, and welcoming.To learn more about the Division of Banks, click here.As a Data and Risk Management Analyst, you can expect to:Assist in designing, building, and maintaining automated data pipelines in the Division’s Snowflake environment.Support AI development to build secure, governed AI agents to support internal processes.Work with experienced data scientists on projects involving large financial and regulatory datasets.Collaborate with colleagues across the Division to help address real-world financial regulatory challenges.Participate in various internal committees and working groups to promote data-driven decision-making.Consider joining our Data Analytics team if you:Are interested in a public position and enthusiastic about serving the public good.Can independently drive projects from design and architecture through development, testing, and deploymentHave experience in large-scale data engineering and ETL/ELT pipelines.Are interested in developing AI tools for financial regulation.Enjoy collaborating with others and communicating with individuals from different professional backgrounds.Are curious, detail-oriented, and enjoy developing creative solutions to data-related challenges.Are eager to learn new analytical tools, technologies, and techniques.Work/Life Balance & Benefits:Hybrid Position: This is a hybrid position offering remote work flexibility. Staff are expected to be on-site at a Division office or at trainings at least once per pay period (every two weeks). Additional in-person attendance may be required based on unit activities or operational needs.Flexible Schedule: Division staff may choose from flexible start and end times and may be eligible for a compressed work schedule that includes every other Friday off.Paid Leave: Commonwealth employees receive generous paid leave in addition to a competitive state holiday schedule.Retirement: Participation in the Commonwealth’s State Employee Retirement System.Training and Development: The Division offers training opportunities through the agency, regulatory partners, and the Commonwealth. Employees are also eligible for tuition remission at Massachusetts public colleges and universities.This position is a union role in the National Association of Government Employees (NAGE) Unit 6 and the salary is within Grade 15. The salary range for this grade is $84,445.40 - $122,918.64 yearly. Salary (step) placement within the range is based on relevant experience.Primary Duties:Assist in the development and maintenance of the Division’s data infrastructure. Work on data engineering projects to improve automation, testing protocols, and efficiency.Support Division staff with data and insights from custom developed data products. Provide queries, data visualizations, and work with Division staff to inform business decisions.Assist on developing agentic AI use cases for agency staff.Assist in reviewing and analyzing complex financial and regulatory datasets to identify trends and potential risks related to the Division’s supervisory responsibilities.Collaborate with team members and agency staff to identify needs, gather requirements, and source use cases.Assist in developing and improving data collection, cleaning, and validation processes.Identify patterns and trends using relevant data and escalate to appropriate management to guide examination and supervision decisions and assist to focus resources on priority risk areas.Support agency strategic planning initiatives through data analysis, research, and identification of emerging trends.Assist in analyzing data associated with regulatory applications and other supervisory matters involving the Division’s depository and non-depository units.Participate in agency-specific risk assessments and updates to the Internal Control Plan.Participate in relevant data analytics working groups in coordination with other regulatory or industry groups.Preferred Qualifications:We encourage individuals who believe they have the skills necessary to thrive to apply for this role, even if you don’t meet 100% of the job requirements.Strong Python experience, preferably with ETL/ELT pipelines and third-party REST APIsExperience with Snowflake or other data lake platforms, including RBAC management or other user access control systems.Experience applying best practices for processing and managing large-scale datasets, with a focus on computational efficiency, optimized code, resource utilization, and cost-effective data workflows.Advanced SQL skills for Snowflake stored procedures, testing, and validation.Strong organizational skills to manage simultaneous projects and competing priorities.Experience with version-control tools, promoting code and database objects from design to production, using Git branching, CI/CD pipelines (Github Actions, Azure DevOps, other) to support collaborative development and management of data science projects.Strong written and verbal communication skills, including the ability to explain technical information and meaningful findings to nontechnical audiences and support informed decision making.Interest in finance, economics, banking, financial regulation, or related financial services topics.Familiarity with financial statements, financial reporting, or financial, banking, or economic data analysis.The filling of this position is subject to appropriation and obtainment of all necessary approvals from the Office of Consumer Affairs and Business Regulation and the Executive Office for Administration and Finance. The Division reserves the right not to fill this position without notice. This position will report directly to the Chief Risk Officer.QualificationsFirst consideration will be given to those applicants that apply within the first 14 days.Minimum Entrance Requirements:Applicants must have (A) at least two years of full-time or equivalent part-time professional or technical experience performing related duties that include business data recovery, analysis, query design, reporting and statistical analysis; or (B) any equivalent combination of the required experience and the substitutions below Substitutions: I. A Bachelor’s degree or higher with a major in Mathematics, Economics, Computer Science, Information Management, Statistics or a related field may be substituted for the required experienceComprehensive BenefitsWhen 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.Job Field: Information Systems and TechnologyOrganization: Division of BanksSchedule: Full-timeShift: Day