Job Description

Please ensure you attach the Cover Sheet (attached), valid Right to Represent with hybrid work schedule acknowledged and confirmed by candidate, and the candidate’s resume with full legal first name, and last name ONLY. (Refer to Bid Submission Requirements). We request that resumes are kept to 4-5 pages, and your candidate may be rejected if this criteria is not met. Withdrawn candidates will not be permitted to be replaced. If you would like to use a sub vendor, only 1 level deep, please use dotStaff Forms link: https://forms.dotstaff.com/en-US/public/SOMI/forms/df22aa32-ddd7-4035-91ac-2a10092614e3

Additional Requirements

-Please include 2 professional references attached as a SEPERATE document. Must include their name, company they worked together at, title, phone number, and email

-Please note, travel outside of the weekly commute is required for this role: Occasionally traveling to Ann Arbor for in-person meetings. Nothing you need to attach to the submission for this, just make sure your candidates are aware and ok with this before submitting.

The State of Michigan is looking for a Data Warehouse Architect 3

Max Bill Rate: $106.00/hour

Sub Vendors Allowed: Yes

-Vendor submissions will close on 11/19 at 10 AM ET. Late submissions will not be accepted.

-Interview Process: Virtual and In-Person. 1st round is virtual, 2nd round is in-person. For the virtual round, Candidates should join from a laptop and be prepared to share their screen if requested. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of virtual interview to validate candidate

-Assignment duration: Projected to go until 11/2027. Ultimate duration and possibility of extension will be dependent on business need.

-Hybrid Work Schedule: Wednesday and Thursday are REQUIRED in-office days. This is NON-NEGOTIABLE and there is NO remote only option.

-Local candidates vs non-local: Open to candidates local to the Lansing Michigan area and those willing to relocate. Candidates that relocate must relocate before day one and be ready to be on-site from day one at their own expense (non-negotiable)

Top Skills & Years of Experience

• Clear and concise written and verbal communication is crucial to success and productivity in this role

Required Education: Bachelors Degree

Required Skills

1. Minimum 4 years of hand-on experience is required in hydrating the enterprise Data Lake on a Cloud Service Provider (AWS, Azure, or Google) from relational, semi-structured and unstructured data sources by building Extract and Load Data Pipelines.
2. Minimum of 4 years hands-on experience is required in Transforming the datasets in a Data Lake on a Cloud Service Provider to deliver Data Products with traceability of their attributes / features to the Critical Data Elements in the systems of record.
3. Minimum of 2 years experience is required in enforcing Data Sharing Policies to Data Products to ensure that User get to see only the version of the Data Product the User is entitled to get access to at the time of subscription.

Preferred Skills

O Proficiency desirable in DevOps tools including Github/Jenkins/Terraform/YAML/DAGs/Docker/Databricks/SageMaker etc. for building Data/ML pipelines to extract/store data from multiple sources to parquet destinations.

O Experience desirable in promoting Data Engineering Standards and Best Practices among the community of developers to influence the enterprise towards building scalable and supportable Data/ML Products delivery and their usage by the community of data, analytics, and ML product users.

O Experience desirable in implementing Data Governance and Data Security tools available on a CSP to automate the enforcement of Data Sharing Policies at the point of subscription of a Data Product by a subscriber.

Full job description attached as a seperate file as well

Job Description: Data Engineer Lead/Data Warehouse Architect (Level 3)

Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile DevOps framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including Spark, Kafka, Kubernetes, SageMaker, DBT, Juniper Notebooks, Docker, SQL, and visualization tools such as Power BI/Tableau with the following track record:

Roles and Responsibilities

Data Engineering Lead excels in data modeling, Lakehouse, and ML products delivery using an agile DevOps framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including DataBricks, Sagemaker, Spark, Kafka, Kubernetes, SQL, NoSQL DBs, Graph DBs, and visualization tools such as Power BI/Tableau.

The Data Engineer Lead serves as the primary State of Michigan technology lead engaging with the UoM proof of concept team to support best practice adoption within the state hosting environment and provides training to DAV data engineers. This role’s responsibilities include:

• Oversee the design, development, and maintenance of data pipelines that move, transform, and prepare data for analytics and operational systems.
• Architect and optimize data infrastructure, including storage solutions, orchestration frameworks, and ETL/ELT processes.
• Ensure data quality, reliability, and security by establishing standards, monitoring systems, and implementing validation and governance practices.
• Lead and mentor data engineering staff, providing technical guidance, reviewing designs/code, and supporting professional growth.
• Collaborate with cross functional partners, such as data scientists, analysts, product teams, and business stakeholders, to ensure data solutions meet organizational needs and strategic goals.

Other Desired Skills

o Must have a BS in Computer Science / Data Science / Information Systems with an overall 4+ years of experience in designing and implementing data, analytics, and AI solutions for large enterprises by building data pipelines using the available data platform tools of any Cloud Service Provider (CSP) such as AWS/Microsoft/Google.

o Experience of minimum 4 years in modeling and leveraging Relational data services with demonstrated proficiency in Python/Pysparks/SQL programming and tuning SQL queries to extract data from multiple sources ( relational DB, flat files, CSV, HTML, JSON, etc) sources into Lakehouse Medallion architecture in parquet formats

o Demonstrated experience and expertise of minimum 4 years in programming/scripting languages including Python, R, Spark, etc.

o Experience in designing and delivering Star-schema based operational data store is required to enable visualization of program activities and outcomes in a visualization tool such as Power BI.

Key Programming Languages: SQL, Python, R, Spark, Terraform Scripting, DAGs Scripting, YAML scripting, Docker

Other Technologies, Concepts and Frameworks: Juniper Notebooks, NOSQL DB, Graph DB, Parquet DB, Lakehouse and Medallion Architecture concepts, Kafka, Kubernetes, Glue, Databricks, Power BI, Tableau, Redshift Spectrum, Sagemaker, DBT, Datahub, SageMaker, Machine Learning, GitHub, DevOps

Job Description

Please ensure you attach the Cover Sheet (attached), valid Right to Represent with hybrid work schedule acknowledged and confirmed by candidate, and the candidate’s resume with full legal first name, and last name ONLY. (Refer to Bid Submission Requirements). We request that resumes are kept to 4-5 pages, and your candidate may be rejected if this criteria is not met. Withdrawn candidates will not be permitted to be replaced. If you would like to use a sub vendor, only 1 level deep, please use dotStaff Forms link: https://forms.dotstaff.com/en-US/public/SOMI/forms/df22aa32-ddd7-4035-91ac-2a10092614e3

The State of Michigan is looking for: Data Warehouse Architect 3

Max Bill Rate: 110/hr

-Vendor Submissions close 9/28 at 10 AM EST

-2 professional references are required. Please attach to the posting in a separate document

-Interview process: In-person and virtual interviews. 1st round is virtual, 2nd round is in-person. Candidates should join from a laptop and be prepared to share their screen if requested. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of virtual interview to validate candidate.

–Assignment duration: Projected to be a 1 year+ contract dependent on business need

–Hybrid work schedule (non-negotiable): Position will be hybrid, in office 2 days a week upon start. Wednesdays and Thursdays are required on-site days and cannot be altered

-Open to candidates local to the Lansing, Michigan area or those willing to relocate from DAY ONE at their OWN EXPENSE (non-negotiable). Candidates that relocate MUST still come on-site for the in-person interview.

-Candidates MUST meet all these requirements from the Beginning

Required Skills

-(EXTREMELY IMPORTANT) Strong communication skills in English with the ability to translate complex technical concepts to both technical and non-technical stakeholders. Candidates who cannot communicate effectively in English will not be considered.

-Proven ability to work both independently and collaboratively within a team environment. Must be able to work independently when needed.

-Strong problem-solving and analytical thinking skills, particularly in troubleshooting complex data and system issues

-3+ years Teradata experience

Preferred Skills

-Previous government experience or State of Michigan experience is a plus but not required.

-Experience with cloud-based BI tools

Job Responsibilities

• Responsible for complex Common Batch Framework and Common Scheduler to ensure current and reliable data is available for critical business processes and decision making.
• Responsible for Data Warehouse change management infrastructure and all promotions of code and ddl; performing build engineer tasks for both manual and automated promotion processes.
• Responsibility for complex Linux security model on DW ETL servers. (Servers are administered by another group, but our team is responsible for the security structure and authorizes user access to the groups and sudos)
• Responsibility for Teradata security and access.
• Conduct data architecture reviews and audits to ensure alignment with enterprise standards
• Create and maintain comprehensive documentation of data architecture, processes, and solutions
• Responsible for providing support for escalated Data Warehouse issue troubleshooting and resolution.
• Evaluate and recommend new data technologies and tools to improve performance and scalability
• Ensure data quality, accuracy, and effective use of enterprise data assets
• Manage and support data integration processes, including ETL workflows across multiple systems
• Collaborate with external vendors and third-party service providers as needed
• Support patch management, system upgrades, and ongoing system maintenance
• Monitor system performance and troubleshoot technical issues across data platforms
• Perform data profiling and implement data quality rules for assessment and validation
• Execute data cleansing and standardization using both built-in and custom data rules
• Develop and maintain disaster recovery and backup strategies for data systems
• Lead efforts to migrate data warehouse processes to standardized/common frameworks
• Conduct elevated access reviews and user audits to ensure compliance
• Identify and remediate audit findings related to data systems and security

Other desired Skills

• Experience supporting the loading of data from multiple source systems
• Ability to provide targeted training and technical guidance to development teams for troubleshooting and batch support
• Minimum of 2 years of Linux experience
• Strong decision-making skills with the ability to determine appropriate solutions while adhering to SoM and MDHHS/DTMB policies

Additional Notes

• Team Environment: The team currently consists of 2 State employees and 6 long-term contractors. It’s a collaborative and well-established group that is looking for an additional resource who can step in and contribute immediately.
• Work: Most work comes through one of the MDHHS Data Warehouse development teams. This role will work closely with developers, leadership, stakeholders, and various SOM and vendor staff on a day-to-day basis.
• Project Scope: The scope is the MDHHS Data Warehouse project, which consists of Child Support, Child Welfare, Eligibility, and Health Services programs.