"Alerted.org

Data Systems Analyst 3 (Long-Term Temporary)

Print (https://www.governmentjobs.com/careers/metrocouncil/jobs/newprint/4747040)

Apply



Data Systems Analyst 3 (Long-Term Temporary)

Salary

$85,987.20 - $139,526.40 Annually

Location

390 Robert St. N St. Paul, MN

Job Type

Full-Time

Job Number

2024-00370

Division

Community Development

Opening Date

07/21/2025

Closing Date

8/10/2025 11:59 PM Central

+ Description

+ Benefits

+ Questions

WHO WE ARE

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. (https://metrocouncil.org/About-Us/The-Council-Who-We-Are.aspx)

The Metropolitan Council’s Community Development division is accepting applications for2Data Systems Analyst 3 positions, both long-term temporary (up to 2 years) and benefits eligible.

The Community Development divisionis 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 hiring and supporting a diverse workforce that reflects the communities we serve and 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, inclusive, and empowers employees of color

The C ommunity D evelopment r esearch department d evelops, d isseminates , 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 Data Systems Analysts (DSA 3) will join a collaborative, interdisciplinary team of 20 data scientists, economists, ecologists, qualitative and climate researchers. The DSA 3s will develop and interpret business needs and requirements, documenting the functional design of a system and creating system documentation and user training materials. Given the business functions and systems specific to the research department, the best-qualified candidates will also have technical knowledge and skills in database management systems, data modeling, and data integration.

DSA 3 positions directly support the research department's ability to provide the public and agency with accurate, timely, and accessible information and trends about the region. Further, they will advance innovation across the community development division through the design and implementation of a new cloud database management system, modernizing the key data infrastructure that underlies the department's public-facing interactive tools, such as Community Profiles.

This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin.

What you would do in this job

Develop new data infrastructure

+ Design conceptual, logical, and physical data models in a new enterprise-wide Microsoft Azure Databricks open lakehouse hub-and-spoke environment to support internal and external applications

+ Collaborate with subject matter experts within the research department to facilitate the migration of legacy data pipelines; develop and document roadmaps

+ Coordinate with enterprise architects in the Information Services division to establish naming, versioning, and change management conventions

+ Implement automated data-quality tests, lineage capture, and metadata publishing

Project management and coordination

+ Learn about the research department's business functional areas to understand system requirements and to coordinate data and analysis needs

+ Assist in defining project scope, objectives, project deliverables, and critical target dates

+ Facilitate project team meetings, direct and coordinate the activities of other staff involved in systems, maintain and communicate project schedules risk logs and status reports

+ Work with Information Services staff in the analysis, design, configuration, testing and maintenance of systems

+ Monitor various databases and datasets used in the department for data validity; resolve data and application issues and improve data quality in collaboration with subject matter experts

Knowledge transfer

+ Apply analytical methods to develop or update the information needed to evaluate current operations such as work distribution charts, flow charts, and process mapping

+ Produce technical documentation and train research staff in use, customization, and integration of Databricks with other data platforms and assets

+ Support technology governance through participation in committees and working groups

What education and experience are required for this job (minimum qualifications)

Any of the following combinations of education (in Computer Science, M anagement Information Systems (MIS) , Computer Engineering, Database Systems , Data Science , or related) and experience in data engineering or architecture , data systems management , BI or software application development, or applied data modeling , or related analytical experience:

+ Master's degree and 2 years of experience

+ Bachelor's degree and 4 years of experience

+ Associate's degree and 6 years of experience

What additional skills and experience would be helpful in this job (desired qualifications):

+ Experience with or accreditations/certifications in Microsoft Azure Databricks or Azure Data Lake Storage

+ Experience with or certifications in Tableau (Architect or Data Analyst)

+ Expert or proficient SQL

+ Knowledge of R and/or Python

+ Knowledge of geospatial analytics (Spatial SQL, ESRI ArcGIS)

+ Knowledge of data catalog and governance frameworks

+ Experience promoting an equitable, positive, and respectful work environment that values cultural diversity among all employees

Knowledge, skills, and abilities necessary for this position:

+ Depth of knowledge in data modeling and database design; sound understanding across all phases of data modeling, from conceptualization to database optimization and integration concepts

+ Knowledge of business objects and an understanding of data modeling principles (data vault and dimensional modeling) and methods to drive technology optimization and architecture recommendations

+ Knowledge of the application development process and use of programming and scripting languages, including proficient SQL, R, and Python

+ Advanced computer skills in word processing, complex spreadsheets, and database management

+ Strong written and verbal communications skills, including the ability to write reports, business correspondence, and procedures for non-technical audiences and to instruct users with a range of skill levels in the use of databases and applications

+ Ability to interpret and apply mathematics and statistical methods and procedures

+ 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! (http://metrocouncil.org/Employment/Making-A-Difference.aspx)

Additional information

Union/Grade: AFSCME Grade H

FLSA Status: Exempt

Safety Sensitive: No

What your work environment would be:

Work is performed in a standard office setting.

What steps the recruitment process involves:

+ We review your minimum qualifications

+ We rate your education and experience

+ We conduct a structured panel interview virtually

+ We conduct a selection interview in-person at our Robert Street office*

*Travel expenses may be covered for out-of-state travel.

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 [email protected].

We believe our employees are a key to our agency's success! In order to attract and retain high quality employees, the Council provides a highly competitive benefits package both in choice and coverage levels. Some highlights about our benefits are listed below:

+ Guaranteed monthly retirement income through Minnesota State Retirement System pension fund

+ Opportunity to save additional funds for retirement on a tax-deferred basis through a voluntary deferred compensation (457) plan

+ Two or more medical plans from which to choose, with employer contribution towards premiums over 80%

+ Dental insurance, life insurance and vision insurance

The following benefits are provided to all employees as part of working for the Council. You will have access to free:

+ Well@Work clinic

+ bus/rail pass valued at over $1200 per year

+ parking at many job locations

+ fitness centers at many job locations

+ Employee Assistance Program

+ extensive health and wellness programs and resources

01

Applicant Instructions: It is important thatyour application shows all relevant education and experienceyou possess. The supplemental questions listed below are to further evaluate your education and experience and to determine your eligibility for this position. Answer each question completely, and please do not type "see resume" otherwise your application will be considered incomplete, and you will not receive further consideration for this position. The experience you indicate in your responses should also be consistent with the Work History section of this application. If you attach a resume and/or cover letter to your application, it will be reviewed at the education and experience review step. I have read and understand the above instructions regarding my application and supplemental questions.

+ Yes

+ No

02

How did youfirsthear about this job opening?

+ CareerForce Center

+ Community Event/Organization

+ Employee Referral

+ Facebook

+ Glassdoor

+ Indeed

+ Job Fair

+ LinkedIn

+ Metro Transit Bus Advertisement

+ Twitter

+ Website: governmentjobs.com

+ Website: metrocouncil.org

+ Website: metrotransit.org

+ Website: minnesotajobnetwork.com

+ Other

03

If you selected 'Other', please describe where you first heard about this job. if you selected 'Employee Referral' please enter the employee's first and last name, ID number (if known), and job title. Type N/A if not applicable.

04

Please select the option that most closely describes your completed level of education and experience.

+ Master's degree in Computer Science, Management Information Systems (MIS), Computer Engineering, Database Systems, Data Science, or related AND at least 2 years of relevant experience in data engineering or architecture, data systems management, BI or software application development, applied data modeling, or related

+ Bachelor's degree in Computer Science, Management Information Systems (MIS), Computer Engineering, Database Systems, Data Science, or related AND at least 4 years of relevant experience in data engineering or architecture, data systems management, BI or software application development, applied data modeling, or related

+ Associate's degree in Computer Science, Management Information Systems (MIS), Computer Engineering, Database Systems, Data Science, or related AND at least 6 years of relevant experience in data engineering or architecture, data systems management, BI or software application development, applied data modeling, or related

+ Some education/training in Computer Science, Management Information Systems (MIS), Computer Engineering, Database Systems, Data Science, or related AND some relevant experience, but not enough to meet any of the above options

+ None of the above

05

Please select the areas below in which you have work experience (select all that apply).

+ Managing and/or optimizing cloud database management systems

+ Data integration and/or data modeling

+ Managing complex technology projects

+ Writing and interpreting various coding languages and SQL

+ Working with non-technical collaborators and stakeholders

+ Microsoft Azure Databricks or Azure Data Lake Storage

+ Tableau

+ R and/or Python

+ Geospatial analytics (Spatial SQL, ESRI ArcGIS)

+ Data catalog and governance frameworks

+ None of the above

06

Please describe your experience with database management systems (or warehouses) in an enterprise setting, including the specific systems/applications and at least one use case for the system/application. Your specific role(s) and tasks performed and where this experience took place and for how long should be clear in your answer. If this does not apply, type "N/A."

07

Please describe your approach to understanding a current system or application or with planning new systems/applications, including the specific steps you have used to understand or gather requirements, identify opportunities for improvement or innovation, and how you have communicated this information to others overall. A specific example, including your specific role(s) and tasks performed, where this experience took place and for how long should be included in your answer. If this does not apply, type "N/A."

08

Please describe the coding languages you have used to manage, maintain, or add value to specific systems/applications or perform data modeling and integration, particularly your experience with SQL, R, or Python. Please include your level of proficiency along with specific examples of how you have used coding language(s) to add value to systems/applications or data. If this does not apply, type “N/A.”

09

Please describe a technology project in which you served as a project manager or in a leadership role, including the objectives of the project, the steps you took to fulfill the objectives over the course of the project, and the outcome of the project. If this does not apply, type "N/A."

10

Define what racial equity means to you. Include at least one example of how you have advanced racial equity in a professional setting, during coursework, or in your personal life. If this does not apply, type "N/A."

Required Question

Employer

Metropolitan Council

Address

390 Robert St. N.St. Paul, Minnesota, 55101

Website

https://metrocouncil.org

Apply

Please verify your email addressVerify Email