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 HR-OCCHealth@metc.state.mn.us.
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
