We use cookies. Find out more about it here. By continuing to browse this site you are agreeing to our use of cookies.

Job posting has expired

Back to search results

Analytics Architect (Senior)

Metropolitan Council
$84,364.80 - $127,296.00 Annually
medical insurance, dental insurance, life insurance, vision insurance, retirement plan, pension
United States, Minnesota, St. Paul
Jul 05, 2024


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.

What you would do in this job

  • Gather requirements by understanding business processes and or collaborating with customers to create relational and or dimensional data models and business analytics models so that it becomes an integral part of the overall data warehouse architecture.
  • Design and implement data warehouse architecture and standards, data staging, and schema designs ensuring conformed dimensions, data cleansing, data quality, data standardization, and metadata management.
  • Integrate data from other disparate heterogeneous source systems using ETL, ELT, API, and data pipelines to populate modeled data structures.
  • Design and develop data integrations, data quality frameworks, data platform architecture, analytical processing tools that feed business analytics, increase data accessibility that provides necessary business reporting, and analytical and advanced analytics functionality fostering data-driven decision-making.
  • Monitor and manage data warehouse performance, perform performance tuning, disaster recovery plans, and backup and restore of data repositories.
  • Provide data warehouse project planning, organization, and management, and assemble large, complex data sets that meet business requirements.
  • Coordinate and collaborate project activities with Performance Excellence and Analytics staff, Process Computer Group staff, process engineering, business units, vendors, consultants, stakeholders, and customers to develop a strategy for long-term data platform architecture.
  • Research, evaluate, and recommend data warehousing and business analytics tools and industry best practices, document implementation, and write unit/integration tests.
  • Provide backup support to data and ETL developers for always-up and always-available service.
  • Other related duties as assigned.

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

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.
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):
  • Proficiency in MangoDB, No-SQL, Hadoop, Big Data analytics, and other data modeling and data management tools
  • Experience in DataOps, Internet of Things (IoT), Data and AI cloud solutions, Azure data factory, data lakes, databricks, synapse, and cloud-based data repositories etc.
  • Experience working with diverse populations of internal and external customers.
What knowledge, skills, and abilities you should have within the first six months on the job:
  • Working Knowledge of Microsoft SQL Server including but not limited to server installation, configuration, clustering, replication, SSIS, OLTP/OLAP, T-SQL, stored procedures, functions, triggers, backups/restores, security, and Analysis Services. Visual Studio.Net, ASP.Net.
  • Experience with semi-structured (i.e., JSON, XML, FHIR), unstructured and structured data sets.
  • Experience with analytic data platforms and data pipeline tools such as Databricks, Azure Data Factory, Fivetran & HVR.
  • Experience using and building APIs that support data pipelines.
  • Experience with ETL design and development experience preferably with SSIS or third-party tools such as Data Services, Informatica, etc.
  • Experience with cloud-based data repositories such as Snowflake, AWS Redshift, AWS S3, Azure Data Lake, and Azure Synapse.
  • Strong knowledge of data warehouse concepts such as star schemas, snowflakes, conformed dimensions (Kimball Methodology), etc.
  • Experience in data modeling includes conceptual modeling, logical modeling, physical RDBMS modeling, and dimensional modeling (fact and dimension tables) using data modeling tools such as Power Designer from Sybase, ERWIN, etc.
  • Experience in design, development, load, and support of relational and dimensional data marts and cubes for transactional and analytical solutions.
  • Experience in effective metadata management throughout the data warehousing life cycle.
  • Experience with Business Intelligence tools such as Business Objects and crystal reports, Cognos, Microsoft tools like PowerBI, etc.
  • Experience in the design and development of web services and web pages using .net framework etc.
  • Knowledge of best practices and technology operations in an always-up, always-available service, Agile Software Development methodologies.
  • Excellent analytical, research, communication (both written and verbal), interpersonal, documentation, and mentoring skills.
  • Demonstrated project leadership, communication skills, and initiative with a keen sense of customer service.
  • Excellent organizational, administrative, problem-solving, and troubleshooting skills.
More about why you should join us!

Additional information

Union/Grade: AFSCME/ I
FLSA Status: Exempt
Safety Sensitive: No

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 condu cted 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