Business Systems Analyst 3

Metropolitan Council; Saint Paul (MN); Hybride; USD 90 000 - 130 000; Plein temps

Résumé du poste

The Metropolitan Council is seeking a Business Systems Analyst 3 in Minnesota to advance data documentation, metadata management, and data cataloging. You will collaborate with data scientists, IS, and analysts to standardize data practices and improve data quality across the department.

You will coordinate documentation, support data development, and act as a liaison between business teams and Information Services, ensuring scalable, transparent data processes while advancing equity and

Qualifications

• Advanced computer skills across word processing, spreadsheets, and presentations.
• Experience with SQL-based data development and cloud data platforms.
• Strong communication and documentation abilities.
• Knowledge of Azure Databricks and related data tools.

Responsabilités

• Lead data documentation standards, templates, and conventions.
• Coordinate metadata maintenance and a data catalog across datasets.
• Serve as liaison to Information Services for data systems and needs.
• Document data ownership, stewardship, and data-quality roles.
• Identify improvements to data-development processes for consistency.

Connaissances

SQL

Python

R

Azure Databricks

Databricks

Excel

Word

PowerPoint

Formation

Master's degree

Bachelor's degree

Associate's degree

Outils

Databricks

Description du poste

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.

The Metropolitan Council is an Equal Opportunity, Affiantive 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 [e-mail].