Explore Our Career Opportunities Today!
At Fortuna, we are committed to fostering a diverse and inclusive workplace where every employee, including veterans, can thrive. Become part of a team where your talents are valued and your achievements are celebrated.
Take the next step in your professional journey with us!
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 LADWP's 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 LADWP's 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 LADWP's CRM/Analytics migration by delivering a scalable, high-performing, and data-driven solution.
WORKSITE: L.A. Department of Water & Power facility (Hybrid)
WORK SCHEDULE: Monday-Friday, standard business hours
ANTICIPATED START DATE: Pending RFP award, mid-year
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 YOU'LL 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 real-time 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 LADWP's customer experience and operational efficiency.
Work with business teams to develop predictive models and AI-driven analytics that support proactive customer engagement and operational decision-making.
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 long-term sustainability of the CRM/Analytics platform.
Work collaboratively with project managers to track deliverables, risks, and milestones related to data migration and integration.
WHAT YOU'LL BRING:
Bachelor's or master's 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.
Hands-on experience with ETL tools, data integration frameworks, and cloud/on-premises data solutions.
Strong knowledge of data governance, security, and compliance best practices.
Experience working with AI-driven analytics, predictive modeling, and geospatial data visualization.
Excellent problem-solving, stakeholder management, and communication skills.
Experience in large-scale 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.
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: www.gofortuna.com.
Why Choose Us?
- Collaborate with local community organizations, job placement agencies, and educational institutions to reach a broader pool of candidates.
- Actively participate in career fairs and job expos to connect with potential employees from diverse backgrounds.
- Establish a wide range of job positions across various departments to accommodate individuals from diverse backgrounds, including veterans, civilians, and those with unique skill sets. This approach ensures that everyone has the opportunity to find a role that aligns with their abilities and interests.
- Pair new hires, including veterans and civilians, with experienced mentors who can provide guidance, support, and insights during their transition into the organization. This mentorship fosters a sense of belonging and helps individuals navigate workplace dynamics.
- Identify skill gaps and provide training programs to help you acquire the necessary qualifications for their desired roles.
- Foster a workplace culture that actively recognizes and appreciates the unique experiences and contributions of all employees, including veterans.
Provide competitive salary and benefits packages that cater to the needs of all employees, including veterans. This should encompass:
- Health Insurance: Offer comprehensive health insurance plans that cover medical, dental, and vision care.
- Paid Time Off: Ensure generous paid time off policies that allow employees to recharge and attend to personal commitments.
- Implement a preferential hiring policy for veterans, giving them a competitive advantage during the application process.
- Offer guidance on translating military skills and experience into civilian job qualifications.
- Recognize outstanding veteran employees through awards and appreciation events.
- Highlight veteran success stories within the organization to inspire others.
Maximizing solutions through collaboration and partnerships.
- Certifications
