"Alerted.org

SDLC Alteryx SQL Server Python SAS Data Warehousing Architect

(Jobs in Madison,

Requirement id 154450

Job title Architect

Job location in Madison, WI

Skills required SDLC, Data Management, ETL Tools, Alteryx SQL Server Python SAS Data Wareh

Open Date 28-Jul-2025

Close Date

Job type Contract

Duration 11 Months

Compensation DOE

Status requirement ---

Job interview type ---

Email Recruiter:coolsoft

Job Description Architect: SDLC, Data Management, ETL Tools, Alteryx SQL Server Python SAS Data Wareh

Start Date :8/11/2025

End Date :06/30/2026

Submission Deadline :7/30/2025 at 4:00 PM CST.

Client Info : ETF

Note :

* Interview Process: Microsoft Teams

* Duration: 6/30/2026, likely to extend

* Onsite or Remote: Candidates must be CURRENT WI residents. No relocation allowed. Can work 100% remote from within the state of WI.

Job Description:

We have an immediate opening at the Department of Employee Trust Funds (ETF) for an Enterprise Architect & Data Management Technical Lead. ETF is a state agency that is recognized as a leader in providing public employee benefit systems. This positions primary focus is to provide technical leadership in the development of a data warehouse, data management techniques, tool implementation, and reporting and analytical capabilities. Additionally, this position will provide technical leadership in other data management functions such as MDM, data quality, and metadata management.

Responsibilities, Knowledge, Skills & Abilities:

• Experience providing technical leadership and mentoring team members on technologies and tools to ensure consistent and effective implementation.

• Experience in the role of project manager leading Bl and data management projects.

• Experience gathering, understanding & documenting user requirements, creating specifications, designing solutions, development, testing, and implementing solutions that ensure requirements are achieved through high quality deliverables.

• Familiarity with dashboard design, full life cycle management and the application of best practices including use of visual design principles.

• Ability to establish design and use patterns for technologies.

• Experience developing technical reference models and ensuring effective implementation of defined architecture.

• Experience with ETL tools and processes including Alteryx and 5515.

• Experience with SQL Server and related tools including SSRS, SSAS, and 5515.

• Experience with source code management tools such as SVN or git.

• Experience with both relational and dimensional data modeling.

• Experience using complex SQL.

• Experience with analytical tools such as R, Python, and SAS.

• Experience with quality assurance and developing standards to certify reports/dashboards/analytics for production use.

• Experience providing leadership and coordination for operational activities for production support and software upgrades.

• Involvement in MDM programs and experience implementing MDM solutions.

• Involvement in governance including data usage, metadata, data management, data quality, and security.

• Familiarity working with technology including metadata management/data cataloging, automated regression testing, containerization, and advanced analytics.

• Familiarity with Tableau Server Infrastructure, specifically publishing and back-end administration, effective organization of data sources and dashboards, optimization, tuning, and ensuring the security of data.

• Familiarity with Tableau development (10.5+) and dashboard usability.

• Familiarity with agile development practices, particularly Scrum.

• Familiarity with data mining and machine learning techniques.

• Familiarity with cloud platforms for data warehousing and analytics.

• Demonstrated interpersonal and communication skills, ability to influence others and to interact with individuals at all levels.

• Ability to work productively with cross-functional working groups and across organizational layers with consideration for agency priorities.

• Strong interpersonal skills including mentoring, coaching, collaborating, and team building.

• Ability to develop and deliver presentations to both technical and non-technical audiences.

• Strong knowledge a

Call502-379-4456 Ext 100for more details. Please provide Requirement id: 154450 while calling.

Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets