WHO WE ARE
This position is eligible for a hybrid (both remote and onsite) telework arrangement. Candidate's permanent residence must be in Minnesota or Wisconsin.
Our long term temporary (up to 2 years) positions - are fully benefits eligible.
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.
We are committed to supporting a diverse workforce that reflects the communities we serve.
Information Services is the central IT department supporting all divisions of the Metropolitan Council. Our 140 team members provide technology, practices, and innovative solutions that enable the core services of the Council.
How your work would contribute to our organization and the Twin Cities region:
The Data Architect will collaborate and work across multiple divisions within the Metropolitan Council: Regional Administration, Metro Transit, Metropolitan Transportation Services, Environmental Services and Community Development.
This Individual will work to expand the company's use of data as a strategic enabler of corporate goals and objectives. They will create data solutions that make appropriate data accessible and available to data consumers, including data scientists, data and business analysts, citizen integrators and line-of-business users.
The Data Architect will achieve this by strategically designing, developing, and implementing data models for enterprise-level applications and systems. This includes conceptual, logical and physical data models and may include business and application modeling. This individual will act as the primary advocate of data modeling methodologies and data processing best practices.
The Data Architect will be a practitioner of data architecture, an information technology discipline concerned with designing, creating, deploying, and managing an organization's data architecture. They will define how data is stored, consumed, integrated, and managed by different data entities and IT systems, as well as any applications using or processing that data in some way.
This individual will collaborate across and support business and information services, designing, building, managing, and operationalizing datasets and data pipelines in support of key data and analytics use cases. This individual will also integrate analytics and data science outputs into existing business processes and applications.
The Data Architect will comply with data governance and data security requirements. They will work with domain experts, data scientists and analysts in framing the business problem and provisioning integrated data quickly across multiple environments to help solve the business need.
Best qualified candidates will demonstrate an inherent drive to collaborate and be a self-starter. They will have the ability to be strategic and innovative, and present well thought out solutions.
What you would do in this job
- Determine stakeholder requirements for data development.
- Design and develop efficient data solutions and databases.
- Build solutions for data analysis, data warehousing, reporting, and analytics.
- Provide data architecture and technical leadership to IS and business teams.
- Define how data will be stored, consumed, integrated, and managed.
- Perform data modeling and database normalization/denormalization.
- Develop and enforce data integrity and referential integrity.
- Help design and build data flows, data integrations, ETL, and data pipelines.
- May interact with application integrations such as APIs and Web Services.
- Conduct capacity planning, feasibility studies, and analyze requirements.
- Troubleshoot database connectivity issues, network, and application problems.
- Develop and maintain data standards and documentation.
- Create best practices and procedures for managing data.
- Help design database security, including secure production and non-production environments.
- Innovate and leverage emerging technology and participate in strategic planning.
- Provide consulting services to business units within the Council.
- May help build reports and dashboards.
What education and experience are required for this job (minimum qualifications)
High school diploma or GED AND ten (10) years of experience in the following areas:
- Working with stakeholders to understand data needs and gather business requirements
- Hands on experience developing and implementing data architecture and complex data models
- Logical and physical data modeling
- Creating high performing databases
- Designing and building data stores, data lakes, data warehouses, and data marts
- In-depth knowledge of data integrations, data pipelines, and ETL concepts, approaches, and tools
- Working with SQL Server, Oracle and/or other similar database technologies
- Experience writing complex, high-performing queries
- Technical leadership experience
- Developing data standards, best practices, and procedures
- In-depth knowledge of application development life cycle
- Data security, including oversite responsibilities for data marts and data warehouses
- Capacity planning
Note: Highest completed degree in the following majors: Computer Science, Information Systems, or a related field will count towards the minimum ten (10) years of required work experience.
- Associates degree counts as two years of experience
- Bachelor's degree or higher counts as four years of experience
What additional skills and experience would be helpful in this job (desired qualifications):
- Experience with PeopleSoft
- Experience developing data solutions for the cloud
- Experience with application integrations, APIs, web services, and Integration Platform as a Service
- Designing and building reports, data visualizations and dashboards
- BI tools administration experience (i.e. report tools, data integrations)
What knowledge, skills and abilities you should have:
- Ability to retrieve, analyze, and communicate relational and non-relational data
- Knowledge of Windows, Linux and/or Unix OS and related software
- Skills working with XML, JSON, or other semi-structured formats
- General systems management and networking skills
- Strong written and verbal communication skills
- Self-starter with the ability to work both independently and with a team
What you can expect from us:
- The opportunity to make a difference and positively influence the Twin Cities metropolitan area.
- Encouragement to develop skills through on-site training and tuition reimbursement.
- We provide a competitive salary, excellent benefits and a good work/life balance.
FLSA Status: Exempt
Safety Sensitive: No
What your work environment would be:
You would perform your work in a standard office setting. Work may sometimes require travel between your primary work site and other sites.
What steps the recruitment process involves:
1. We review your minimum qualifications.
2. We rate your education and experience.
3. We conduct a structured panel interview.
4. We conduct a selection interview and assessment.
Once you have successfully completed the steps above, then:
If you are new to the Metropolitan Council, you must pass a drug test (safety sensitive positions only), and 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 drug test (if moving from a non-safety sensitive position to a safety sensitive position) and 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 .