Business Systems Analyst 3 at Metropolitan Council

Job description

We are the Metropolitan Council, the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services. More information about us is on our website. The Community Development Division is responsible for the Council’s regional long-range planning efforts; planning and technical assistance to local governments; planning for and funding the regional parks and open space system; delivering rent assistance through the Metropolitan Housing and Redevelopment Authority; and delivering the Livable Communities Act grant programs. We are committed to supporting a diverse workforce that reflects the communities we serve. In Community Development, we have set the following goals to guide our work: • Our division builds competency, takes meaningful actions, and creates the necessary infrastructure to advance racial equity. • Our division’s workplace culture is diverse, and inclusive, and empowers employees of color. The Community Development research department develops, disseminates, and analyzes quantitative and qualitative data about demographic trends, development patterns, climate change, parks visitation, equity, and the regional economy. We believe research can improve the lives of residents in our region, and see our skills, creativity, and platforms as resources to further shared understanding about regional issues that matter. How your work would contribute to our organization and the Twin Cities region: The Business Systems Analysts (BSA 3) will join a collaborative, interdisciplinary team of data scientists, economists, ecologists, sociologists, qualitative and climate researchers. Given the business functions and systems specific to the research department, the best-qualified candidates will have technical knowledge and skills in database management systems, data modeling, and data integration. The BSA 3 position provides advanced analytical, coordination, and technical support for the department's data development and analysis functions. The position leads efforts to modernize and standardize data documentation, metadata management, data cataloging, and related data-management practices; identifies and implements improvements to data development and documentation processes; supports department's use of Databricks; and serves as a primary business liaison between the department and Information Services (IS). The position works collaboratively with researchers, data scientists, data developers, subject-matter experts, management, and IS staff to develop sustainable standards and processes that improve the discoverability, usability, quality, transparency, and maintainability of departmental data assets. The position does not supervise staff but provides managerial functional leadership, coordination, guidance, and technical expertise across the department. This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin. Lead Data Documentation, Metadata Management, and Data Cataloging Develop, coordinate, and maintain standards and processes for documenting departmental datasets, data products, and related data-development activities. Example of activities, but not limited to are: • Assess existing documentation practices and develop recommendations for a modern, consistent, and sustainable departmental documentation framework. • Develop and maintain documentation standards, templates, conventions, guidance, and minimum documentation requirements. • Collaborate with data developers, analysts, and subject-matter experts to document datasets and associated business and technical information. • Establish processes and responsibilities for maintaining metadata throughout the lifecycle of departmental datasets. • Coordinate maintenance and continued development of the department's data catalog. Analyze and Improve Data Development and Data-Management Processes Analyze departmental data-development and data-management processes and coordinate improvements that increase consistency, efficiency, reproducibility, and maintainability. • Analyze current business processes, data workflows, documentation practices, and technology use to identify opportunities for improvement. • Work with staff to document current-state and future-state process improvement using process maps, workflows, procedures, business rules, and other appropriate methods. • Facilitate collaborative development of departmental standards, procedures, naming conventions, and other common practices. • Define and document roles and responsibilities associated with data ownership, stewardship, documentation, metadata maintenance, and data-quality activities. Serve as Business Liaison to Information Services Serve as a primary liaison between departmental business users and Information Services for technology matters affecting data development, data management, analysis, and related departmental systems. • Develop and maintain effective working relationships with Information Services staff, enterprise architects, application and platform administrators, and other technology partners. • Identify, gather, analyze, document, and communicate departmental business and system requirements. • Translate data-development and analytical needs into business and functional requirements that can be evaluated by technical staff. • Coordinate departmental technology requests, system enhancements, integrations, platform changes, and related initiatives. • Represent departmental business needs in meetings, working groups, governance activities, and technology projects. • Evaluate proposed technology changes for potential impacts on departmental data, workflows, applications, documentation, and analytical processes. Any of the following combinations of education (in Computer science, Data science, Geographic information systems, Data engineering, or related field) and experience in management analysis or related analytical experience: • Master's degree and 2 years of experience, including at least 1 year performing configurations and modifications within the specific business application • Bachelor's degree and 4 years of experience, including at least 1 year performing configurations and modifications within the specific business application • Associate's degree and 6 years of experience, including at least 1 year performing configurations and modifications within the specific business application What additional skills and experience would be helpful in this job (desired qualifications): • Experience developing or implementing organizational data-documentation standards • Experience managing projects involving database migration • Experience with metadata-management or data-catalog systems • Expert or proficient SQL • Knowledge of R and/or Python • Knowledge of geospatial analytics (Spatial SQL, ESRI ArcGIS) • Experience working with Databricks or similar platforms • Experience working with Twin Cities (Minneapolis-St. Paul) regional data • Experience promoting an equitable, positive, and respectful work environment that values cultural diversity among all employees Knowledge, skills, and abilities necessary for this position: • Advanced computer skills in word processing, complex spreadsheets, graphics presentations and database management required (Word, Excel, Access and Power Point). • Ability to clearly describe technical processes throughout the data lifecycle. • Knowledge of Microsoft Azure Databricks or comparable cloud-based data platforms. • Ability administering, coordinating, or serving as a business owner for a shared data or analytical platform. • Ability to communicate effectively with staff with varying levels of technical knowledge. • Ability to work independently and in a team-orientated, collaborative environment • Ability to be flexible during times of change, to conform to shifting priorities, demands and timelines through analytical and problem-solving capabilities What you can expect from us: • We offer the opportunity to make a difference and positively influence the Twin Cities metropolitan area • We encourage our employees to develop their skills through on-site training and tuition reimbursement • We provide a competitive salary, excellent benefits and a good work/life balance • We encourage and support staff in bringing the full range of experiences and identities that define them to the workplace • We encourage and support staff in contributing to a dynamic work culture that improves the Council's ability to serve the region and strives to effectively support all employees More about why you should join us! Union/Grade: AFSCME / Pay Grade H FSLA Status: Exempt Safety Sensitive : No Work Environment: Work is performed in a standard office setting. Requires travel between priority work site to other sites. The responsibilities listed are typical of the positions included in the job classification; however, not all duties are necessarily performed by each specific position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential duties of the position. Regular attendance is an essential responsibility. What steps the recruitment process involves: • We review your minimum qualifications • We rate your education and experience • We conduct a structured panel interview • We conduct a selection interview Once you have successfully completed the steps above, then: If you are new to the Metropolitan Council , you must pass a background check which verifies education, employment, and criminal history. A driving record check and/or physical may be conducted if applicable to the job. If you have a criminal conviction, you do not automatically fail. The Metropolitan Council considers felony, gross misdemeanor and misdemeanor convictions on a case-by-case basis, based on whether they are related to the job and whether the candidate has demonstrated adequate rehabilitation. If you are already an employee of the Metropolitan Council , you must pass a criminal background check if the job you're applying for is safety sensitive, is a supervisory or management job, is in the Finance, Information Services, Audit, or Human Resources departments, or has access to financial records, files/databases, cash, vouchers or transit fare cards. A driving record check and/or physical may be conducted if applicable to the position. IMPORTANT: If you make a false statement or withhold information, you may be barred from job consideration. The Metropolitan Council is an Equal Opportunity , Affirmative Action, and veteran-friendly employer. The Council is committed to a workforce that reflects the diversity of the region and strongly encourages persons of color, members of the LGBTQ community, individuals with disabilities, women, and veterans to apply. If you have a disability that requires accommodation during the selection process, please email HR-OCCHealth@metc.state.mn.us .

Requirements

Must-haves

We are committed to supporting a diverse workforce that reflects the communities we serve.
In Community Development, we have set the following goals to guide our work:
Our division builds competency, takes meaningful actions, and creates the necessary infrastructure to advance racial equity.
Our division’s workplace culture is diverse, and inclusive, and empowers employees of color.
How your work would contribute to our organization and the Twin Cities region:
Lead Data Documentation, Metadata Management, and Data Cataloging
Develop, coordinate, and maintain standards and processes for documenting departmental datasets, data products, and related data-development activities. Example of activities, but not limited to are:
Assess existing documentation practices and develop recommendations for a modern, consistent, and sustainable departmental documentation framework.
Develop and maintain documentation standards, templates, conventions, guidance, and minimum documentation requirements.
Collaborate with data developers, analysts, and subject-matter experts to document datasets and associated business and technical information.
Establish processes and responsibilities for maintaining metadata throughout the lifecycle of departmental datasets.
Coordinate maintenance and continued development of the department's data catalog.
Analyze and Improve Data Development and Data-Management Processes
Analyze departmental data-development and data-management processes and coordinate improvements that increase consistency, efficiency, reproducibility, and maintainability.
Analyze current business processes, data workflows, documentation practices, and technology use to identify opportunities for improvement.
Work with staff to document current-state and future-state process improvement using process maps, workflows, procedures, business rules, and other appropriate methods.
Facilitate collaborative development of departmental standards, procedures, naming conventions, and other common practices.
Define and document roles and responsibilities associated with data ownership, stewardship, documentation, metadata maintenance, and data-quality activities.
Serve as Business Liaison to Information Services
Serve as a primary liaison between departmental business users and Information Services for technology matters affecting data development, data management, analysis, and related departmental systems.
Develop and maintain effective working relationships with Information Services staff, enterprise architects, application and platform administrators, and other technology partners.
Identify, gather, analyze, document, and communicate departmental business and system requirements.
Translate data-development and analytical needs into business and functional requirements that can be evaluated by technical staff.
Coordinate departmental technology requests, system enhancements, integrations, platform changes, and related initiatives.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonazure

Platform: governmentjobs
Effort: medium

Benefits

Benefits detected in the listing.

Vision