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, .
- 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.
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