Data Warehouse ArchitectCRM Analytics Migration

The Data Warehouse Architect will lead the design development and implementation of a comprehensive data warehouse solution as part of the CRM and Analytics platform migration project for LADWPs Customer Service Organization (CSO). This role will have expertise in Oracle Siebel CRM Oracle Analytics Server (OAS) Informatica and DAC.

This role is responsible for ensuring seamless data migration integration and optimization of data analytics capabilities while aligning with utility industry best practices. The architect will work closely with LADWPs Information Technology Services (ITS) business stakeholders and system integrators to ensure data integrity scalability and accessibility of key reports dashboards and analytical tools. This role is critical to the success of LADWPs CRM/Analytics migration by delivering a scalable highperforming and datadriven solution.

WORKSITE: L.A. Department of Water & Power facility (Hybrid)

WORK SCHEDULE: MondayFriday standard business hours

ANTICIPATED START DATE: Pending RFP award midyear

PAY RATE: $90hour to $100/hour

WHAT WE OFFER:

• Paid sick leave based on state regulations after 90 days of employment

• Medical dental and vision are offered after a waiting period 60 paid by Fortuna)

• Free TeleMedicine and Mental Health for all employees and their families

• Additional volunteer options such as Group Life Insurance Accidental Insurance Critical Care Short Term Disability

WHAT YOULL DO:

Data Warehouse Architecture & Development

• Design and develop a new CRM/Analytics data warehouse that supports enhanced reporting dashboards KPIs and customer insights.

• Ensure the migration of data from Oracle Siebel CRM (version 23 Oracle Analytics Server (OAS 5.9 Informatica and DAC 11g) to the new CRM/Analytics platform.

• Develop data models and architectures that align with industry best practices for utilities ensuring seamless data integration across multiple business systems.

• Implement data governance policies including integrity security and compliance requirements.

System Integration & Data Migration

• Develop data migration strategies ensuring a smooth transition from legacy systems to the new CRM/Analytics platform.

• Design and configure data integration solutions to connect CRM/Analytics with other LADWP applications including Customer Care & Billing (CCB) Customer Contact Center Platform Outage Management Systems and Workforce Management Information System.

• Implement realtime and batch processing for seamless data flow between CRM and external systems.

Data Analytics & Reporting

• Build and optimize analytical dashboards reports and visualization tools to enhance LADWPs customer experience and operational efficiency.

• Work with business teams to develop predictive models and AIdriven analytics that support proactive customer engagement and operational decisionmaking.

• Incorporate geospatial data visualization capabilities to improve customer service and operational analytics.

Performance Optimization & Troubleshooting

• Perform data performance tuning to optimize ETL (Extract Transform Load) processes and ensure system efficiency.

• Develop tools and procedures for data validation troubleshooting and performance monitoring of the CRM/Analytics platform.

• Ensure high availability and reliability of the data warehouse providing ongoing support and maintenance.

Documentation Training & Knowledge Transfer

• Develop comprehensive technical documentation on data models workflows integration points and system configurations.

• Provide training and knowledge transfer to LADWP staff ensuring longterm sustainability of the CRM/Analytics platform.

• Work collaboratively with project managers to track deliverables risks and milestones related to data migration and integration.

WHAT YOULL BRING:

• Bachelors or masters degree in computer science Data Science Information Systems or a related field.

• 10 years of experience in data warehousing data architecture and business intelligence preferably within the utilities industry.

• Expertise in Oracle Siebel CRM Oracle Analytics Server (OAS) Informatica and DAC.

• Handson experience with ETL tools data integration frameworks and cloud/onpremises data solutions.

• Strong knowledge of data governance security and compliance best practices.

• Experience working with AIdriven analytics predictive modeling and geospatial data visualization.

• Excellent problemsolving stakeholder management and communication skills.

• Experience in largescale CRM/Analytics migrations within a government or utility organization.

• Proficiency in AI/ML algorithms for predictive modeling and customer segmentation.

• Knowledge of customer engagement analytics campaign management and profile management systems.

Top of Form

Fortuna operates as a staffing agency that sources screens and presents potential candidates for employment opportunities on behalf of our clients.

Fortuna was founded in 2012 by practicing professionals with more than 50 combined years of experience. Our headquarters is in McClellan California with offices in Los Angeles and New York and satellite offices in the Philippines and Israel. Fortuna is an active member of multiple California service agreements including the CMAS ITMSA (Tier 2 and CalPERS SpringFed Pool as well as multiple municipalities and large corporation vendor pools

Career Site: .