Upvote
Downvote
Analytics Architect (Senior)
Share Job
- Suggest Revision
- 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.
- 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.
- 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.
- 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.
- 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.
Active Job
Updated 4 days agoSimilar Job
Relevance
Active