Sign upLog in

Data Warehouse Architect in Lansing MI Hybrid

Syntricate Technologies Inc

Lansing, MI

Apply
JOB DETAILS
SKILLS
Administrative Skills, Amazon Web Services (AWS), Analysis Skills, Auditing, Business Intelligence Software, Business Operations, Business Support, Change Management, Cloud Computing, Communication Skills, Cross-Functional, Data Administration, Data Description Language (DDL), Data Management, Data Processing, Data Profiling, Data Quality, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Disaster Recovery, Enterprise Architecture, Enterprise Data Integration, GCP (Good Clinical Practices), Government, Identify Issues, Information/Data Security (InfoSec), Linux Administration, Linux Operating System, Maintain Compliance, Mentoring, Microsoft Windows Azure, NCR Teradata, Operational Support, Performance Analysis, Performance Management, Presentation/Verbal Skills, Problem Solving Skills, Quality Management, Regulatory Compliance, Schedule Development, Security Architecture, Security Auditing, Security Monitoring, Software Patches, Systems Administration/Management, Technical Recruiting, Technical Support, Technical Training, Technical Writing, Writing Skills
LOCATION
Lansing, MI
POSTED
4 days ago
We are looking for Data Warehouse Architect in Lansing MI Hybrid. Please read the job description below and let me know if you are interested.
 
Position: Data Warehouse Architect (Teradata)
Location: Lansing, MI (Hybrid – Local Candidates Only)
Duration: Long Term Contract
Interview Process: Virtual
Req ID: 163606
 
Job Description 
We are seeking an experienced Data Warehouse Architect 5 to support the Michigan Department. The ideal candidate will have extensive experience with Teradata, Linux, ETL, and enterprise data warehouse environments. This role is responsible for managing data warehouse architecture, security, batch processing, code deployments, ETL workflows, troubleshooting, and ensuring the availability, reliability, and quality of enterprise data supporting critical business operations.

Key Responsibilities

  • Design, maintain, and support enterprise Data Warehouse architecture and infrastructure.
  • Manage Common Batch Framework and Common Scheduler to ensure reliable data availability.
  • Support ETL processes and data loading from multiple source systems.
  • Administer Data Warehouse change management, code promotions, and DDL deployments.
  • Manage Teradata security, user access, and Linux security structures.
  • Provide advanced troubleshooting and technical support for Data Warehouse production issues.
  • Conduct data architecture reviews and ensure compliance with enterprise standards.
  • Develop and maintain technical documentation for architecture, processes, and solutions.
  • Monitor system performance and recommend improvements for scalability and reliability.
  • Perform data profiling, validation, cleansing, and quality management activities.
  • Support disaster recovery planning, backup strategies, system upgrades, and patch management.
  • Collaborate with developers, business stakeholders, vendors, and technical teams.
  • Conduct security audits, elevated access reviews, and remediate audit findings.
  • Provide technical mentoring, training, and guidance to development teams.

Required Qualifications

  • 8+ years of hands-on experience with Teradata (Required).
  • Experience supporting data loading from multiple source systems.
  • Strong experience with ETL processes and enterprise data integration.
  • Minimum 5 years of Linux administration/support experience.
  • Experience troubleshooting batch processing and enterprise data warehouse environments.
  • Strong understanding of data architecture, security, and change management.
  • Excellent analytical, problem-solving, and decision-making skills.
  • Ability to work independently as well as collaboratively within cross-functional teams.
  • Strong verbal and written communication skills.

Preferred Qualifications

  • Previous State of Michigan or government experience.
  • Experience with cloud-based BI tools.
  • Experience with cloud platforms such as AWS, Azure, or GCP.
  • Experience supporting enterprise-scale data warehouse modernization initiatives.

Best Regards,
Salman Alam
IT Recruiter||Syntricate Technologies Inc.
Direct: 781-236-6328
Email:

salman.a@syntricatetechnologies.com


 

About the Company

S

Syntricate Technologies Inc