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 on our website.
We are committed to supporting a diverse workforce that reflects the communities we serve.
About the Metropolitan Council's Environmental Services Division:
We are an award-winning wastewater industry leader in protecting our environment! Metropolitan Council Environmental Services (MCES). MCES operates and maintains the wastewater collection and treatment system for the Minneapolis-St. Paul seven-county metropolitan area, which includes approximately 600 miles of regional sanitary sewers and eight regional wastewater treatment plants. MCES treats an average of 250 million gallons of wastewater daily, providing cost-effective service to more than 2.6 million people in 109 customer communities. MCES treatment plants consistently earn state and national awards for complete compliance with their environmental permits. MCES also is nationally recognized for its work monitoring air and water quality and planning for a long-range water supply to meet future demand.
To find out how the Metropolitan Council and the Environmental Services division serve the Twin Cities region, please click on the links for more information: https://metrocouncil.org/About-Us/The-Council-Who-We-Are.aspx and https://metrocouncil.org/Wastewater-Water.aspx.
This is a REPOST. If you have previously applied, you do not need to reapply. This posting may close without further notice on Monday, April 10, 2023, at 11:59 pm.
How your work would contribute to our organization and the Twin Cities region: The Senior Analytics Architect will provide highly technical expertise and leadership in the design, development, implementation, and maintenance of scalable data pipelines, data marts, and warehouses, API integrations for business analytics solutions. Responsible for the full data analytics development life cycle and maintenance of new/existing data marts, operational data stores, API integrations, data pipelines, and data warehouses that support the Environment Services business analytics solutions. The individual must possess a combination of DBA, database, and data mart developer skills and be the subject matter expert on data warehousing and analytics architecture, methodologies, ETL, ELT, REST API toolsets, data pipelines, data modeling, data cleansing, data quality, data design, and delivery to support large data volumes and complexity.
This position is eligible for a hybrid (both remote and onsite) telework arrangement. The candidate's permanent residence must be in Minnesota or Wisconsin.
Bachelor's Degree in computer science, software engineering, or related field AND
Five (5) years of designing, developing, and supporting data warehouses, datamarts, all performance indicators (APIs) in a business analytics environment, JavaScript, Python, or Java development experience.
OR
Associate's Degree in computer science, software engineering, or related field AND
Seven (7) years of designing, developing, and supporting data warehouses, datamarts, all performance indicators (APIs) in a business analytics environment, JavaScript, Python, or Java development experience.
What additional skills and experience would be helpful in this job (desired qualifications):
What knowledge, skills, and abilities you should have within the first six months on the job:
More about why you should join us!
Union/Grade: AFSCME/ I
FLSA Status: Exempt
Safety Sensitive: No
Full Salary Range: $40.56-$61.20 Hourly/$84,365- $127,296 annually
Work Environment:
Hybrid/flexible hours to ensure systems uptime, data, and ETL's are always up and always available for service and support).
Work is regularly performed in a normal office environment but requires occasional local in-state travel by car to do fieldwork.
Physical Requirements:
Position may be required to sit, stand, and walk for long periods. The position is required to speak, hear, read, and write. Must have adequate close vision, distance vision, and color vision. Must possess manual dexterity to operate a computer and computer equipment. Position uses hands and fingers to handle or feel and may occasionally reach with hands and arms, turn, twist, bend at the waist, and stoop, kneel, crouch, or crawl. Must be able occasionally to lift/carry/push/pull up to 50 pounds.
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 accommodations 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:
1. We rate your education and experience.
2. We conduct a structured panel interview.
3. 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 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 an 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:
The following benefits are provided to all employees as part of working for the Council. You will have access to free: