Sign upLog in

Data Warehouse Architect

Sunrise Systems Inc

Lansing, MI

Apply
JOB DETAILS
SKILLS
Amazon Web Services (AWS), Analysis Skills, Build Management, Business Intelligence Software, Business Processes, Change Management, Child Protection/Welfare, Child Support, Cloud Computing, Communication Skills, Data Description Language (DDL), Data Management, Data Migration, Data Profiling, Data Quality, Data Recovery, Data Warehousing, Database Backup, Database Extract Transform and Load (ETL), Disaster Recovery, Documentation, GCP (Good Clinical Practices), Healthcare, Identify Issues, Information/Data Security (InfoSec), Leadership, Linux Operating System, Maintain Compliance, Microsoft Windows Azure, Multiplatform/Cross-Platform, NCR Teradata, Performance Analysis, Performance Management, Problem Solving Skills, Resource Leveling, Schedule Development, Software Patches, State Government, Systems Administration/Management, Systems Maintenance, Team Player, Technical Leadership, Training/Teaching
LOCATION
Lansing, MI
POSTED
1 day ago
Job Title: Data Warehouse Architect 5
Job ID: 26-03516
Location: Lansing, MI, 48933
Duration: 6 Months of conract

Top Skills & Years of Experience:
  • 8+ years Teradata experience – top requirement
  • 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 5 years of Linux experience
  • Proven ability to work both independently and collaboratively within a team environment
  • Strong decision-making skills with the ability to determine appropriate solutions while adhering to SoM and MDHHS/DTMB policies

Job Responsibilities:
  • Responsible for complex Common Batch Framework and Common Scheduler to ensure current and reliable data is available for critical business processes and decisionmaking.
  • Responsible for Data Warehouse change management infrastructure and all promotionsof 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

Required Qualifications:
  • 8+ years Teradata experience – top requirement
  • 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 5 years of Linux experience
  • Proven ability to work both independently and collaboratively within a team environment
  • Strong decision-making skills with the ability to determine appropriate solutions while adhering to SoM and MDHHS/DTMB policies
  • Strong problem-solving and analytical thinking skills, particularly in troubleshooting
complex data and system issues
  • Strong communication skills with the ability to translate complex technical concepts toboth technical and non-technical stakeholders

Preferred Qualifications:
  • Previous government experience or State of Michigan experience
  • Experience with cloud-based BI tools
  • Experience with cloud-native platforms ( AWS, GCP, or Azure ) preferred.

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 a senior-level resource who can step in and contribute immediately.
  • Work: Most work comes through one of the MDHHS Data Warehouse developmenteams. 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 ofChild Support, Child Welfare, Eligibility, and Health Services programs

Contact:
Vinay Kumar: Vinay.c@sunrisesys.com Direct: (732) 837-0448 | URL: Sunrise Systems Inc.

About the Company

S

Sunrise Systems Inc

Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.

We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.

Our collective business experience spans over two and a half decades and ranges from:

  • Business, management, and technical fields
  • Information technology consulting and software solutions.
  • Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
  • Motivating technology staff and establishing partnerships with Fortune 500 companies

Sunrise Systems has a vast range of competence in:

  • Design, development, and support of cloud-based solutions from simple to highly complexed
  • Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
  • Data processing and data migration
  • Application re-engineering and platform migration
  • Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.
COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1990
WEBSITE
http://www.sunrisesys.com/

Resume Resources

Free Resume TemplatesFree Resume Builder