> Markdown version of [/jobs/ext/2004820-data-warehouse-lead-developer](https://www.wearedevelopers.com/jobs/ext/2004820-data-warehouse-lead-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Warehouse Lead/developer

- **Company:** CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
- **Location:** Irvine, CA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Query Performance, Big Data, Code Review, Information Systems, Continuous Integration, Data Architecture, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Mart, Data Migration, Data Systems, Data Warehousing, DevOps, Python (Programming Language), MicroStrategy, Power BI, SQL Databases, Tableau (Software), Data Processing, Cloud Platform System, Informatica Powercenter, Database Optimization, Data Strategy, Information Technology, Tools for Reporting, Data Pipelines
- **Published:** August 9, 2026
- **Apply:** https://www.wayup.com/i-j-Data-Warehouse-Lead-developer-CLOUDSCOUTS-SOFTWARE-SOLUTIONS-LLC-871411839293631/

## About the Role

Bachelor's or Master's degree in Computer Science, Information Systems, or related field
8+ years of experience in data warehousing, ETL, and BI solutions
Strong expertise in Informatica (PowerCenter, IDMC), SQL, and data modeling
Hands-on experience with Tableau, Power BI, or MicroStrategy
Proficiency in Python for data engineering and automation

## Description

Lead the design, development, and implementation of enterprise data warehouse solutions supporting analytics and reporting initiatives
Architect and manage ETL/ELT pipelines using Informatica PowerCenter and IDMC to integrate data from multiple source systems
Define and enforce data architecture standards, data models, and best practices for scalability and performance
Oversee development of data marts, dimensional models (star/snowflake schemas), and optimized warehouse structures
Collaborate with business stakeholders to translate requirements into data solutions, dashboards, and reporting frameworks
Drive development of BI dashboards and reporting solutions using Tableau, Power BI, and MicroStrategy
Ensure data quality, governance, and security compliance, including data validation, lineage, and audit processes
Lead and mentor a team of data engineers, ETL developers, and analysts; provide technical guidance and code reviews
Optimize query performance, ETL workflows, and database tuning for large-scale datasets
Implement automation and data processing solutions using Python to improve efficiency and reduce manual effort
Manage data migration, integration, and modernization initiatives, including cloud-based data platforms
Coordinate with DevOps and infrastructure teams for deployment, CI/CD, and environment management
Establish and monitor KPIs, SLAs, and data pipeline health metrics
Provide leadership in data strategy, governance, and roadmap planning aligned with organizational goals
Communicate technical solutions and insights effectively to both technical and non-technical stakeholders
Nice Add-ons (if needed for JD completeness)


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)