Data Warehouse Analyst Sr
Carnival Global Brand
Miami, FL
Apply
JOB DETAILS
SKILLS
Analysis Skills, Big Data, Business Intelligence, Business Intelligence Software, Business Solutions, Computer Certifications, Computer Science, Construction, Customer Relationship Management (CRM), Data Analysis, Data Mart, Data Modeling, Data Warehousing, Database Extract Transform and Load (ETL), Debugging Tools, Dimensional Modeling, Documentation Models, Enterprise Applications, Hyperion, Identify Issues, Informatica, Microsoft Exchange Server, Microsoft Product Family, Oracle, Oracle 11i, Oracle PL-SQL, Performance Analysis, Quest Software TOAD, Reporting Dashboards, SQL Navigator, Snowflake Schema, Software Development, Star Schema, Statistical Analysis System (SAS), Stock Purchase Plans, Sustainability, Systems Administration/Management, Tableau, Test Data, Test Plan/Schedule, Time Management, Vehicle Fleets, Warehousing
LOCATION
Miami, FL
POSTED
30+ days ago
Job Description
We are seeking a Senior Data Warehouse Analyst!
This individual is responsible for the design, development, and maintenance of the Operational Data Store (ODS), Enterprise Warehouse (EDW), Data Mart, CRM/Guest Loyalty and Big Data integrations and reporting business solutions with minimal guidance from the Supervisor, Data Warehouse Supervisor or Information/Data Warehouse Architect.
Essential Functions:
- Design, develop, and document complex code integrating warehouse and transactional business applications using current knowledge of enterprise application technologies and development techniques
- Design, develop, and test dimensional data model extensions using Star & Snow Flake schema methodologies under the Kimball and Inmon methodologies.
- Lead troubleshooting and debugging of software integration and performance problems. Conduct performance analysis, and suggest potential solutions for highly complex integrations and reporting needs.
- Partner with the Business Intelligence teams in defining the end state reporting goals and/or dashboard requirements. Design and develop data based solutions that meet either a 'publish or 'subscribe' data requirement.
- Construct and maintain the necessary support Run-Book, scheduling, and Embarcadero data model documentation and artifacts in accordance with Carnival’s System Development Methodology (SDM).
- Assist in developing and then meet agreed-upon deadlines and perform other project duties as assigned.
- Communicate technical and non-technical information clearly, concisely, and effectively both orally and in writing. Present findings, recommendations, and specifications in formal reports and/or oral presentations.
Qualifications:
- Bachelor’s degree in Computer Science Certification in Informatica a plus
- Experience in analysis, design, and construction of high volume data warehouse integrations using the following set of technologies (Oracle, Informatica)
- Expert understanding of PL/SQL developer, functions, procedures, packages and triggers.
- Expert understanding of SQL Navigator and/or Toad. Recent experience developing on Oracle 11G/10G.
- Expert understanding of the concept of code objects re-use and business rules standardization.
- Expert understanding of PL/SQL developer, functions, procedures, packages and triggers.
- Expert experience with Informatica Power Center version 9.x. including Workflow Manager, Workflow Monitor, Repository Manager, Designer, Server Manager, Power Exchange and ETL.
- Knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and Microsoft.
About Us
Carnival Cruise Line is the most popular cruise brand in North America and operates a fleet of ships designed to foster exceptionally safe, fun and memorable vacation experiences at an outstanding value. Our employees have a responsibility to be accountable for all actions. We consider the environment in all aspects of our business and have a responsibility to put safety and sustainability first. We live and share a positive attitude which is based on fostering an environment of inclusion, trust, a willingness to listen, openness and integrity. Doing this helps us to achieve our ultimate goal, which is to include FUN in everything we do! Speaking of fun, we are officially certified as a Great Place to Work aboard our ships as well as in our global corporate headquarters!
Carnival Corporation & plc and Carnival Cruise Line is an equal employment opportunity/affirmative action employer. In this regard, it does not discriminate against any qualified individual on the basis of sex, race, color, national origin, religion, sexual orientation, age, marital status, mental, physical or sensory disability, or any other classification protected by applicable local, state, federal, and/or international law.
To view a copy of Carnival’s FMLA, EEO and EPPA posters please visit: (click or copy and paste link into your browser)
Benefits as a member of Carnival's Team:
- A comprehensive benefit program which includes medical, dental and vision plans
- Additional programs include company paid term life insurance and disability coverage and a 401(k) plan that includes a company match
- Tuition Reimbursement
- Employee Stock Purchase plan
- Paid vacation and sick time
- Cruise benefits
- An on-site fully accredited preschool educational program located at our Doral campus
- An on-site Wellness Center and Health clinic at our Doral campus
#CCL#
About the Company
C