
Job Information
State of Massachusetts Business Intelligence Data Analyst Lead - Contractor in Boston, Massachusetts
The Department of Mental Health (DMH) is seeking a dynamic individual to serve in a contracted role as Business Intelligence Data Analyst Lead. Thiscontract position reports to the Director of Strategyinthe Data and Analytics Unit. This role supports the Strategy Directorandthe Department to provideanalytic and technical skills necessary to innovate, build, andmaintainwell-managed data solutions and capabilitiesfor the DMH. The Business Intelligence Analyst Lead appliesvarious research methods to mine, collect, examine, analyze,validate, and organize data and derive insights and present information from data analysesto support decision-making. This incumbent will also collaborate with Information Technology Departments to manage and make improvements across a variety of programs and develop policies to integrate data across distinct systemsand ensure adherence to laws, regulations, and policies. // /_Duties and Responsibilities (these are a general summary and not all inclusive):_/ * Lead the planning, coordination, and implementation of analytics solutions for the Data and Analytics Unit that ensure proper communication and execution with project stakeholders. * Responsible forestablishingand ensuring adherence to the principles of data quality management, including metadata, lineage, and business definitions fordataand analyticalapplications. * Act as coach,mentorand motivator todataanalysts across DMH and project team members. * Conduct detailed data analysis on data used across business units to evaluate business processimprovement thatoptimizesefficiency and quality. * Designandestablishprocesses that ensure the use of standarddataand analyticalapplicationsand operationalize the use of data in business decision making. * Provideexpertise, translate, and document the business needs to design; and develop tools, techniques, and metrics, dashboards, and reports for insights and data visualization. * Work with IT and business stakeholders to definethe data storage systems, data collection systems, data analytics approaches, processes and other strategies thatoptimizemethodological efficiency, quality, and compliance. * Respond to data and product related inquiries to support business and technical teams. * Provide relational databaseexpertiseto construct and execute SQL queries to be used in data analysis activities. * Develop reports and queries to extract data from various data warehouses and other sources using various methods (e,g, SQL, API, among others). * Analyze data toidentifypatterns and trends in data sets using statistical or other techniques. * Test analytics solutions and verify data for accuracy by conducting code walk-throughs, reviewing data patterns, reports, and performance indicators tolocateandcorrect code and process problems, or inaccuracies in source data. * Plan, develop, and deliver training ondata and analyticsconcepts, tools, techniques,anddata andanalyticalsolutions. * Activelyparticipatesin ensuring adequate security measures and procedures are in place tomaintainthe confidentiality of the gathered data and distribution/access is only made to theappropriate, designated personnel. * Performs other related duties as assigned or requestedtomaintaina high levelof service. * Completes required continuous training and education, including department-specific requirements. _Preferred Qualifications:_ * Proven track record of relevant technical experience; SQL and relational database knowledge. * Experience in defining business requirements and technical specifications for technical solutions. * Demonstrated proficiency in designing and developing data models for analytical applications. * Experience working with Business Intelligence (BI) Tools and Software (e.g. MS Excel, Tableau, Microsoft Power BI, Python, SQL Server Reporting Services). * Experience working within process management and improvement methodologies. * Working experience with software test planning and execution. * Knowledge of data governance, data quality management concepts and metadata management tools. * Understanding of System Development Lifecycle (SDLC), Agile development methodologies, software design patterns, network design and architecture. * Knowledge of and ability to perform data analysis and apply query design principles, data visualization, and/or statistical analysis. * Knowledge of project management and business planning * Given the population served, bilingual or multilingual fluency _Period of Service:_ 4/30/2025 - 4/30/2026.Contracts are renewable, subject to the Department approval, performance and allocation of funds _Additional Information:_ * Benefits are unavailable with the exception of sick leave accruals. * Contracts are renewable, subject to the Department approval, performance and allocation of funds. * All employees will be paid on a biweekly basis and must have direct deposit. _DMH Mission Statement:_ The Department of Mental Health assures and provides access to services and supports to meet the mental health needs of individuals of all ages, enabling them to live, work and participate in their communities. The Department establishes standards to ensure effective and culturally competent care to promote recovery. The Department sets policy, promotes self-determination, protects human rights and supports mental health training and research. __ _Pre-Hire Process:_ A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit http://www.mass.gov/hhs/cori Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines. Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the Commonwealth’s website. If you require assistance with the application/interview process and would like to request an ADA accommodation, please click on the link and complete the ADA Reasonable Accommodation Request Form. For questions regarding this requisition, please contact Executive Office of Health and Human Services Human Resources at 1-800- 510-4122 Ext. #4 * *First consideration will be given to those applicants that apply within the first 14 days. Minimum Entrance Requirements: None. * * Salary placement is determined by a combination of factors, including the candidate’s years of directly related experience and education, and alignment with our internal compensation structure as set forth by the Human Resources Division’s Hiring Guidelines. For all bargaining unit positions (non-management), compensation is subject to the salary provisions outlined in the applicable collective bargaining agreement and will apply to placement within the appropriate salary range. *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! Title 101 CMR 23.00 (“Regulation”) requires certain agency staff to have received the COVID-19 vaccination and Influenza vaccination, or have taken required mitigation measures, to prevent viral infection and transmission in State Hospitals and State Congregate Care Facilities. The Regulation applies to this position. Successful candidates will be required to acknowledge and attest to your vaccination status for both COVID-19 and Influenza. 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: Administrative Services* *Organization: Department of Mental Health *Title: *Business Intelligence Data Analyst Lead - Contractor Location: Massachusetts-Boston-25 Staniford Street Requisition ID: 250002QI