Data Warehouse Lead/developer
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Schedule
Full-time
Career level
Director
Remote
On-site
Compensation
$60+/hour
Benefits
Career Development
Job Description
Job Duties – Data Warehouse LeadLead the design, development, and implementation of enterprise data warehouse solutions supporting analytics and reporting initiativesArchitect and manage ETL/ELT pipelines using Informatica PowerCenter and IDMC to integrate data from multiple source systemsDefine and enforce data architecture standards, data models, and best practices for scalability and performanceOversee development of data marts, dimensional models (star/snowflake schemas), and optimized warehouse structuresCollaborate with business stakeholders to translate requirements into data solutions, dashboards, and reporting frameworksDrive development of BI dashboards and reporting solutions using Tableau, Power BI, and MicroStrategyEnsure data quality, governance, and security compliance, including data validation, lineage, and audit processesLead and mentor a team of data engineers, ETL developers, and analysts; provide technical guidance and code reviewsOptimize query performance, ETL workflows, and database tuning for large-scale datasetsImplement automation and data processing solutions using Python to improve efficiency and reduce manual effortManage data migration, integration, and modernization initiatives, including cloud-based data platformsCoordinate with DevOps and infrastructure teams for deployment, CI/CD, and environment managementEstablish and monitor KPIs, SLAs, and data pipeline health metricsProvide leadership in data strategy, governance, and roadmap planning aligned with organizational goalsCommunicate technical solutions and insights effectively to both technical and non-technical stakeholdersNice Add-ons (if needed for JD completeness)Minimum Qualifications:Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field8+ years of experience in data warehousing, ETL, and BI solutionsStrong expertise in Informatica (PowerCenter, IDMC), SQL, and data modelingHands-on experience with Tableau, Power BI, or MicroStrategyProficiency in Python for data engineering and automation
Compensation: $60.00 per hour
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
FAQs About Data Warehouse Lead/developer Jobs at Cloudscouts Software Solutions
What is the work location for this position at Cloudscouts Software Solutions?
This job at Cloudscouts Software Solutions is located in Irvine, California, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Cloudscouts Software Solutions?
Candidates can expect a pay range of $60 (per hour).
What employment applies to this position at Cloudscouts Software Solutions?
Cloudscouts Software Solutions lists this role as a Full-time position.
What experience level is required for this role at Cloudscouts Software Solutions?
Cloudscouts Software Solutions is looking for a candidate with "Director" experience level.
What benefits are offered by Cloudscouts Software Solutions for this role?
Cloudscouts Software Solutions offers Career Development for this position. Actual benefits may vary depending on the employer's policies and employment terms.
What is the process to apply for this position at Cloudscouts Software Solutions?
You can apply for this role at Cloudscouts Software Solutions either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.