Analytics Architect (Senior)

Print


Analytics Architect (Senior)

Salary

See Position Description

Location

Metro Plant - 2400 Childs Rd. St. Paul MN 55106, MN

Job Type

Full-Time

Job Number

2023-00093

Division

Environmental Services

Department

Performance Excellence & Analy

Opening Date

03/23/2023

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 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.
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):
  • 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 
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:
 

  • 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: 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 attached 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 supplemental questions.
  • Yes
  • No
02
How did you first hear 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
Which of the following best describes your education?
  • Master's Degree or higher in computer science, computer engineering, software engineering, or related field.
  • Bachelor's degree in computer science, computer engineering, software engineering, or related field.
  • Associate's degree in computer science, computer engineering, software engineering, or related field.
  • High School Diploma and/or GED.
  • None of the above.
05
Please indicate how many years of full-time experience you have as a Sr. Computer Systems Specialist (Analytics Architect)
  • Less than three (3) years of experience in designing, developing, and supporting data warehouses, data marts and APIs in a business analytics environment, JavaScript, Python or Java development experience.
  • Three (3) years but less than five (5) years of experience designing, developing, and supporting data warehouses, data marts and APIs in a business analytics environment, JavaScript, Python or Java development experience.
  • Five (5) years but less than seven (7) years of experience designing, developing, and supporting data warehouses, data marts and APIs in a business analytics environment, JavaScript, Python or Java development experience.
  • supporting data warehouses, data marts and APIs in a business analytics environment, JavaScript, Python or Java development experience.
  • None of the above.
06
If you checked "Yes" in the previous question, briefly describe your experience. Include in your details the names and dates of your employment and high-level project details.
07
Have you worked in a professional capacity providing technical expertise and leadership in the design, development, implementation, and maintenance of scalable pipelines, data marts and warehouses?
  • Yes
  • No
08
Do you have experience integrating data from other heterogeneous source systems using ETL, ELT, API, data pipelines to populate modeled data structures?
  • Yes
  • No
09
Please check all that you have experience in:
  • Mango DB, No-SQL, Hadoop, Big Data Analytics and/or similar data management tools
  • DataOps, internet of Things (loT), data
  • Data and AI cloud solutions, Azure data factory, data lakes, databricks, synapse and cloud-based data repositories etc.
  • None of the above
10
If you checked any experience in the previous question, please describe the capacity that you utilized the IT tool(s)/technologies. If this does not apply, type N/A.
11
Do you have knowledge and/or experience in the following: 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?
  • Yes
  • No
12
Do you have experience with semi-structured (i.e., JSON, XML, FHIR), unstructured and structured data sets?
  • Yes
  • No
13
Please indicate any of the following analytic data platforms and data pipeline tools you have experience in:
  • Databricks
  • Azure Data Factory
  • Fivetran
  • HVR
  • None of the above
14
Have you worked with any of the following Business Intelligence tools? Please check all that may apply.
  • Business Objects
  • Cognos/SAS
  • MS PowerBI
  • Other
15
Do you have experience with cloud-based data repositories such as Snowflake, AWS Redshift, AWS S3, Azure Data Lake, and Azure Synapse?
  • Yes
  • No
16
If you answered "Yes" in the previous question, please describe your proficiency in each repository you have listed. If this does not apply, type N/A.
17
The Metropolitan Council values a workplace that is as diverse as the people we serve. Please describe your experience working and collaborating in a diverse, multicultural, and inclusive environment. If you do not have this experience, indicate "N/A."

Required Question

Agency
Metropolitan Council
Address
390 Robert St. N.

St. Paul, Minnesota, 55101