Data Warehouse Architect 5
Aroha Technologies
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- Python
- XML
- Root Cause Analysis
- Data Transformation
- Data Analytics
- SQL
- Data Migration
- Kubernetes
- Scrum
- Shell Scripting
- Data Governance
- Openshift
- Data Integration
- Version Control
- troubleshooting
- Data Validation
- Unix Scripting
- Data Lineage
- Agile methodology
- Data Testing
- CI/CD pipelines
- Data Quality Management
- Metadata Management
- Sprint Planning
- ETL Development
- Linux Scripting
- data extraction
- IBM Knowledge Catalog
- IBM Manta
- IBM DataStage
- Master Data Management (MDM)
- Automation scripting
- Data Modernization
- Enterprise Data Architecture
- IBM Cloud Pak for Data (CP4D)
- Job Sequencing
- ETL Automation
- Data Loading
- Enterprise Data Warehousing
- Cloud-Native Platforms
- Teradata 20
- ETL Pipeline Design
- ETL Pipeline Optimization
- Legacy Workload Migration
- DataStage Parallel Jobs
- DataStage Server Jobs
- ETL Performance Tuning
- Advanced SQL
- SQL Performance Optimization
- BTEQ
- Teradata SQL
- Large-Scale Data Processing
Summary
Data Warehouse Architect 5
Interview Process- In-person and Virtual
- 1 2 rounds
- Projected 1-year+ contract, dependent on business need
- Hybrid (Non-Negotiable)
- Wednesdays and Thursdays are the required onsite days each week.
- Candidates MUST be able to work onsite on these days from the beginning.
- No remote-only option.
- Open to candidates local to the Lansing, Michigan area.
- Candidates willing to relocate may also be considered.
- Candidates must relocate before Day 1 at their own expense.
- Candidates MUST meet all requirements from the beginning.
- 1+ years of hands-on experience with IBM Cloud Pak for Data (CP4D).
- 3+ years of strong experience with Teradata 20, including SQL/BTEQ, performance optimization, and working with large enterprise datasets.
- 5+ years of Unix/Linux scripting and system operations.
- 3+ years of Advanced SQL for analysis and ETL support.
- Public health, Health Industry, or State Government experience.
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
The Analytics and Visualization Division is seeking a Senior ETL Developer with extensive experience in IBM DataStage, IBM Cloud Pak for Data (CP4D), and Teradata 20.
The resource will support enterprise data modernization efforts, including migration of legacy workloads to CP4D, development of robust ETL pipelines, and technical leadership for data quality, governance, and integration initiatives.
This role requires strong analytical capabilities, advanced ETL engineering skills, and the ability to work effectively across complex enterprise environments.
Key Responsibilities- Design, build, enhance, and optimize ETL pipelines using IBM DataStage, including parallel/server jobs, performance tuning, and job sequencing.
- Support migration of DataStage workloads from on-premise environments to IBM Cloud Pak for Data (CP4D), including refactoring, modernization, testing, and validation.
- Develop and optimize complex SQL and BTEQ scripts for Teradata 20, supporting large-scale data integrations and analytics workloads.
- Create automation scripts using Python, Shell scripting, and XML for ETL workflows and data processing.
- Apply Master Data Management (MDM) and data governance principles to ensure consistency, quality, and reliability across systems.
- Work collaboratively with data architects, DBAs, analysts, business owners, and technical teams to align deliverables with program objectives.
- Conduct troubleshooting, root-cause analysis, and remediation activities for ETL pipeline issues.
- Support Agile delivery, including sprint participation, documentation, testing, and continuous improvement activities.
- 1+ years of hands-on experience with IBM Cloud Pak for Data (CP4D).
- 3+ years of strong experience with Teradata 20, including SQL/BTEQ, performance optimization, and working with large enterprise datasets.
- 5+ years of Unix/Linux scripting and system operations.
- 3+ years of Advanced SQL for analysis and ETL support.
- Public health, Health Industry, or State Government experience.
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
- 5+ years of experience developing ETL solutions using IBM DataStage.
- Proficiency in Python for automation.
- Experience with MDM, data quality, and data governance methodologies.
- Proven ability to translate business and technical requirements into scalable ETL and data integration solutions.
- Experience working in large, complex enterprise data environments with multiple data sources.
- Prior experience supporting public-sector environments.
- Knowledge of IBM Knowledge Catalog, including metadata, lineage, and governance.
- Exposure to IBM Manta for lineage and impact analysis.
- Familiarity with cloud-native platforms such as OpenShift or Kubernetes.
- Experience with CI/CD pipelines, version control, and Agile methodologies.
- Dice Id: 10515154
- Position Id: 2026-7055
- Posted 3 hours ago
Company Info
About Aroha Technologies
Michael Arrington, founder and co-editor of Tech Crunch once famously said that ‘The best startups generally come from somebody needing to scratch an itch’.
Quite true to the thought, Aroha Technologies Inc was launched in 2008 in Florida. While we began our journey with a powerful Staffing Specialist & Software Development, Today our procedure has amplified into a more robust and simplified solution for Marketers looking for consistent and long term.
In our quest to do better, we resolve to simplify user acquisition, retention, engagement and large Business without blinking an eyelid! A semi-remote team spread across the globe, we are here to help you one step at a time.
Unmatchable growing excellence When AROHA was formed, we interviewed many potential clients and business colleagues and asked what a single important question seemed: “If you could design a firm to meet your needs, what would it look like?” The answers to that question have guided our thinking and planning on an ongoing basis, and form the core of our thinking about how we treat our clients and our employees, whom we call associates.
At a most basic level, we have stated our mission in a promise to our clients and our associates: “Unmatchable growing excellence.” This alignment governs superior service to our customers and supports our associates who perform that work, which cannot be matched by our competitors.
In short, we believe that care of our associates, disciplined financial management, and constant attention to the fundamentals of good delivery adds up to a successful, scalable business.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs