Data Warehouse Lead/developer

Cloudscouts Software Solutions
  • Irvine, California
  • $60 Per Hour
  • Autofill and Review
26 days ago

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.

Numbers & Facts

LocationIrvine, California

Skills

  • Automationunmatched
  • Best Practicesunmatched
  • Business Intelligenceunmatched
  • Cloud Computingunmatched
  • Computer Scienceunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Data Managementunmatched
  • Data Martunmatched
  • Data Migrationunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • DevOpsunmatched
  • Dimensional Modelingunmatched
  • Environmental Monitoringunmatched
  • Informaticaunmatched
  • Information Technology & Information Systemsunmatched
  • Leadershipunmatched
  • Mentoringunmatched
  • Performance Metricsunmatched
  • Power BIunmatched
  • Python Programming/Scripting Languageunmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • SQL (Structured Query Language)unmatched
  • Security Complianceunmatched
  • Service Level Agreement (SLA)unmatched
  • Snowflake Schemaunmatched
  • Software Engineeringunmatched
  • Star Schemaunmatched
  • Tableauunmatched
  • Technical Leadershipunmatched
  • Warehousingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder