Job Title- Data Warehouse Architect<\/p>\n
Pay Range: $85-$95\/hr.<\/p>\n
Location: Hybrid in Lansing – 2 days a week on site<\/p>\n
<\/p>\n
Job Responsibilities:<\/p>\n
\u2022 Responsible for complex Common Batch Framework and Common Scheduler to ensure<\/p>\n
current and reliable data is available for critical business processes and decision<\/p>\n
making.<\/p>\n
\u2022 Responsible for Data Warehouse change management infrastructure and all promotions<\/p>\n
of code and ddl; performing build engineer tasks for both manual and automated<\/p>\n
promotion processes.<\/p>\n
\u2022 Responsibility for complex Linux security model on DW ETL servers. (Servers are<\/p>\n
administered by another group, but our team is responsible for the security structure and<\/p>\n
authorizes user access to the groups and sudos)<\/p>\n
\u2022 Responsibility for Teradata security and access.<\/p>\n
\u2022 Conduct data architecture reviews and audits to ensure alignment with enterprise<\/p>\n
standards<\/p>\n
\u2022 Create and maintain comprehensive documentation of data architecture, processes, and<\/p>\n
solutions<\/p>\n
\u2022 Responsible for providing support for escalated Data Warehouse issue troubleshooting<\/p>\n
and resolution.<\/p>\n
\u2022 Evaluate and recommend new data technologies and tools to improve performance and<\/p>\n
scalability<\/p>\n
\u2022 Ensure data quality, accuracy, and effective use of enterprise data assets<\/p>\n
\u2022 Manage and support data integration processes, including ETL workflows across multiple<\/p>\n
systems<\/p>\n
\u2022 Collaborate with external vendors and third-party service providers as needed<\/p>\n
\u2022 Support patch management, system upgrades, and ongoing system maintenance<\/p>\n
\u2022 Monitor system performance and troubleshoot technical issues across data platforms<\/p>\n
\u2022 Perform data profiling and implement data quality rules for assessment and validation<\/p>\n
\u2022 Execute data cleansing and standardization using both built-in and custom data rules<\/p>\n
\u2022 Develop and maintain disaster recovery and backup strategies for data systems<\/p>\n
\u2022 Lead efforts to migrate data warehouse processes to standardized\/common frameworks<\/p>\n
\u2022 Conduct elevated access reviews and user audits to ensure compliance<\/p>\n
\u2022 Identify and remediate audit findings related to data systems and security<\/p>\n
<\/p>\n
Required Qualifications:<\/p>\n
\u2022 8+ years Teradata experience \u2013 top requirement<\/p>\n
\u2022 Experience supporting the loading of data from multiple source systems<\/p>\n
\u2022 Ability to provide targeted training and technical guidance to development teams for<\/p>\n
troubleshooting and batch support<\/p>\n
\u2022 Minimum of 5 years of Linux experience<\/p>\n
\u2022 Proven ability to work both independently and collaboratively within a team environment<\/p>\n
\u2022 Strong decision-making skills with the ability to determine appropriate solutions while<\/p>\n
adhering to SoM and MDHHS\/DTMB policies<\/p>\n
\u2022 Strong problem-solving and analytical thinking skills, particularly in troubleshooting<\/p>\n
complex data and system issues<\/p>\n
\u2022 Strong communication skills with the ability to translate complex technical concepts to<\/p>\n
both technical and non-technical stakeholders<\/p>\n
<\/p>\n
Preferred Qualifications:<\/p>\n
\u2022 Previous government experience or State of Michigan experience<\/p>\n
\u2022 Experience with cloud-based BI tools<\/p>\n
\u2022 Experience with cloud-native platforms ( AWS, GCP, or Azure ) preferred.<\/p>\n
<\/p>\n
Additional Notes:<\/p>\n
\u2022 Team Environment: The team currently consists of 2 State employees and 6 long-term<\/p>\n
contractors. It\u2019s a collaborative and well-established group that is looking for a senior-<\/p>\n
level resource who can step in and contribute immediately.<\/p>\n
\u2022 Work: Most work comes through one of the MDHHS Data Warehouse development<\/p>\n
teams. This role will work closely with developers, leadership, stakeholders, and various<\/p>\n
SOM and vendor staff on a day-to-day basis.<\/p>\n
\u2022 Project Scope: The scope is the MDHHS Data Warehouse project, which consists of<\/p>\n
Child Support, Child Welfare, Eligibility, and Health Services programs.<\/p>\n
<\/p>\n
#LI-PK1<\/p>\n","protected":false},"author":0,"featured_media":82,"template":"","meta":{"inline_featured_image":false,"_promoted":"","_job_location":"Lansing, Michigan","_application":"applications@staffingfuture.com","_company_name":"Brooksource","_company_website":"","_company_tagline":"","_company_twitter":"","_company_video":"","_filled":0,"_featured":0,"_remote_position":0,"_job_salary":"","_job_salary_currency":"","_job_salary_unit":""},"job-types":[8],"class_list":["post-8416","job_listing","type-job_listing","status-publish","has-post-thumbnail","hentry","job-type-contract"],"yoast_head":"\n