Apply Now

Data Warehouse Architect

Lansing, MI, US • Posted 1 hour ago • Updated 1 hour ago

Contract Independent

Contract W2

1 Year

On-site

Depends on Experience

OP Consulting Group LLC

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

DATA WAREHOUSE ARCHITECT
DATA WAREHOUSE
ARCHITECTURE
TERADATA
LINUX
AWS
GCP
AZURE

Summary

Job Title- Data Warehouse Architect 5
Location: Lansing,MI
Onsite

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

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 Client 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 to both technical and non-technical stakeholders

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91138017
Position Id: 26-00779
Posted 1 hour ago

Company Info

About OP Consulting Group LLC

OP Consulting Group was formed by an IT Consultant who was frustrated with the current practices in the staffing industry. With a determination to bring change in the staffing practices, we came up with some bold business practices. We also offer complimenting services of Training and Consulting.

We are not just a middleman but are your partner to help turn your goals into reality. We do not see a job opportunity as a single transaction but the beginning of a long-term relationship.

OP Consulting Group’s promises to you are:
• Upfront and transparent pay rate
• We keep low margins
• Frequent and proactive communication of submission status
• We only work with direct clients or prime vendors
• On-time payment

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Warehouse Architect

Lansing, Michigan

•

30+d ago

The client maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however, this list is not exhaustive. 8+ years required for the following:Teradata databaseUpgrades, provisioning, software maintenance, scripting BASH, Perl, Python, GlinkTeradata ecosystem health monitoringTeradata node managementTeradata Viewpoint administrationTeradata Tools and Utilities (TTU)PSIM (Platform Service Intelligent Monitoring) administrationTeradata vendor upgradesTe

Easy Apply

Contract

Depends on Experience

Technical Architecture Specialist

Hybrid in Harrisburg, Pennsylvania

•

7d ago

Role: Technical Architecture Specialist Location: Harrisburg, PA ResponsibilitiesDevelop new SSRS reports and database objects against complex enterprise databases (SQL Server and Oracle); modify and enhance existing reports and objects. Create and maintain .NET Core MVC applications. Design relational and multidimensional databases; perform performance tuning for SSRS reports. Conduct thorough testing of reports and database objects prior to user testing. Apply Agile development principles and

Easy Apply

Contract

Depends on Experience

Data Warehouse Developer

Richmond, Virginia

•

28d ago

Join our team as a Data Warehouse Developer where you will have the opportunity to work on-site in the vibrant city of Richmond. This role is perfect for those who are passionate about data engineering and enjoy collaborating with various stakeholders to develop analytics-ready data solutions. Key Responsibilities:Data profiling: Analyze and understand source systems to determine data availability, quality, and extraction logic.Data modeling: Design dimensional models and star schemas to support

Easy Apply

Contract

$55 - $62

Search all similar jobs

More jobs at OP Consulting Group LLC in Lansing, MI