Engineer Sr., Data Warehouse

The Senior Engineer, Data Warehouse is responsible for designing, developing, testing, and maintaining software applications and systems to meet user needs and business objectives. This role involves collaborating with cross-functional teams, including product managers, designers, and other engineers, to create high-quality, scalable, and efficient software solutions.

The focus for this role is building software applications, writing code, and implementing functionality to meet user needs or business goals.

The Senior Engineer, Data Warehouse leverages business and technical experience to deliver high quality products. This role provides technical leadership and guidance to technical teams. This position is responsible for design, development, deployment, maintenance, and in some cases support of multi-tiered applications. This position collaborates with architects while managing the technical implementation, integration, and optimization of the product. This role partners with the IT leaders and business leaders to deliver the technical implementation of the business requirements while adhering to architectural guidelines, best practices, and compliance requirements.

This position is responsible for a complex application portfolio.

Essential Functions:

• Software Development: Collaborate with team members and stakeholders to understand project goals, provide technical input, and ensure successful delivery. Participate in architectural design decisions to ensure scalability, performance, and reliability.

• Collaborate with Business Analyst and Software Architects to analyze user requirements and application design to create software while ensuring separate elements of the application works well in the larger program. Write, debug, and optimize code to implement software solutions based on technical and business requirements. Leverage best practices and industry standards to ensure quality code is developed according to specs and user requirements. Ensure solutions can be easily expanded with new feature sets and functionality on frameworks that are easily extendible. Create frameworks which promote ease of adoption, sharing, re-use, and interfacing with other application platforms. Develop unit tests, perform code reviews, and ensure the software meets quality standards. Provide ROM to development leads for planning purposes. Collaborates with Quality Engineer during all phases of testing to ensure defects /deficiencies are addressed. Collaborate with Project Manager/ Scrum Master on issues, risks, and status.

• Documentation: Create and maintain technical documentation for software functionality, processes, and best practices. Document each aspect of a system or application as a reference for future upgrades and maintenance.

• Quality: Identify and resolve issues that arise during the testing and maintenance processes. Ensure applications are stable and meet established KPI/ SLAs. Ensures that software complies with security requirements (. PCI, SOX, PII).

• Operations/Support: Respond to production issues. Quickly analyze and resolve bugs or errors in production without affecting system stability. Deploy updates, features, or patches to production environment. Validate post-deployment functionality and ensure no regressions occur. Address performance bottlenecks (., slow database queries, unoptimized code). Optimize system resources like CPU, memory, or network usage. Leverage tools to watch for anomalies. Investigate issues reported by monitoring tools, users, or customer support teams. Set up alerts and dashboards to proactively address issues. Identify the underlying causes of incidents and prevent recurrence.

Knowledge & Skills:

• Strong knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and Microsoft technologies.

• Understanding of casino player related data is a plus.

• Strong knowledge of Performance Management and Data Privacy and Protection.

• Strong knowledge of Informatica Dynamic Data Masking (DDM), Data Privacy Manager (DPM), Data Archive (IDA), Enterprise Data Catalogue (IDA), and Data Governance (IDG), Informatica Data Management Cloud (IDMC)

• Business domain expertise and associated systems used within the specific portfolio.

• Strong knowledge of professional software engineering and best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.

• Strong attention to detail and organization to work on numerous parts of a system or application at the same time.

• Strong knowledge of networking concepts such as IP addresses, DNS, firewalls, load balancers, and how these affect application availability and performance.

• Strong knowledge of resource allocation, scaling strategies, downtime planning, and disaster recovery.

• Strong knowledge of databases (., SQL, Oracle).

• Strong knowledge of Firewalls, VPNs, and Secure Sockets Layer (SSL)/Transport Layer Security (TLS).

• Strong knowledge of encryption for data at rest and in transit.

• Strong knowledge of operating systems (., Linux, Windows) and basic troubleshooting.

• Ability to think critically, problem solve creatively and perform root cause analysis.

• Flexibility to adjust to changing priorities and deadlines.

• Good analytical skills and attention to detail with a strong business sense.

• Ability to manage tight deadlines, prioritize workload, and achieve effective results.

• Ability to create PowerPoint presentations that are informative and engaging and deliver them to various audiences including management.

• Very good communication, team building, conflict management, and organizational skills.

• Proven track record of working collaboratively with cross functional teams to achieve common goals and drive results.

• Proficiency in MS Office.

• Ability to quickly learn new technologies and concepts.

• Ability to write comprehensive and concise technical communications (. email, reports, presentations) to be consumed by non-technical individuals.

Qualifications:

• Bachelor’s degree/Master’s degree preferred in Information Technology, Computer Science, or related field or equivalent work experience

• 5+ years Experience as a Software Engineer (Developer) required

• 5+ years Experience serving as technical resource throughout the full software development lifecycle, from conception, architecture definition, detailed design, scoping, planning, implementation, testing to documentation, delivery, and maintenance required

• 5+ years Experience in production support, troubleshooting complex issues, developing RCAs, and meeting SLAs required

• 5+ years Experience with compliance and security principles and developing secure applications that meet legal and organizational requirements. (. PCI, SOX, PII, .

• 5+ years Experience with monitoring and logging tools to report on application and infrastructure health required

• 5+ years Experience with DevOps and CI/CD required

• 5+ years Experience developing with role-based access control (RBAC), IAM (Identity and Access Management).

• 5+ years Experience developing and implementing of third-party APIs and library integrations.

• 5+ years Experience with cloud platforms (AWS, Azure, or Google Cloud) and containerization.

• 5+ years Experience with PL/SQL developer, functions, procedures, packages, and triggers.

• 5+ years Experience with SQL Navigator or Toad.

• 5+ years Experience developing on Oracle and SQL Databases.

• 5+ years Experience with the concept of code re-use and business rules standardization

• 5+ years Experience in Informatica including Workflow Manager, Workflow Monitor, Repository Manager, Designer, Server Manager, Power Exchange and ETL.

• 5+ years Experience performing project activities including design and development of various, data warehouse, casino and customer relationship management project.

• 5+ years Experience in Informatica Data Management Cloud (IDMC)

• 5+ years Experience in analysis, design, construction, documentation, and the support of very high-volume/performance data warehouse integrations using the following set of technologies (Oracle, Informatica, UNIX).

• 5+ years Experience in handling/analyzing customer related data (CRM)

• Ability to create PowerPoint presentations that are informative and engaging and deliver them to various audiences including management.

• Very good communication, team building, conflict management, and organizational skills.

• Proven track record of working collaboratively with cross functional teams to achieve common goals and drive results.

• Proficiency in MS Office.

• Ability to quickly learn new technologies and concepts.

Physical Demands: Must be able to remain in a stationary position at a desk and/or computer for extended periods of time.

Travel: No travel

Work Conditions: Work beyond normal business hours or on weekends may be required occasionally to support business needs, projects, or operations.

This position is classified as “remote.” As a remote role, it allows employees to work full-time from their home. It may also require regular travel to Carnival headquarters in Miami, FL for in-office collaboration. Sourcing of candidates is primarily done in Carnival’s remote hubs of Orlando, Tampa, Atlanta, Houston, and Dallas. If the search is extended past those areas, candidates must be located in one of the following . states: FL, GA, TX and NC

Offers to selected candidates will be made on a fair and equitable basis, taking into account specific job-related skills and experience.

At Carnival, your total rewards package is much more than your base salary. All non-sales roles participate in an annual cash bonus program, while sales roles have an incentive plan. Director and above roles may also be eligible to participate in Carnival’s discretionary equity incentive plan. Plus, Carnival provides comprehensive and innovative benefits to meet your needs, including:

• Health Benefits: Cost-effective medical, dental and vision plans Employee Assistance Program and other mental health resources Additional programs include company paid term life insurance and disability coverage
• Financial Benefits: 401(k) plan that includes a company match Employee Stock Purchase plan
• Paid Time Off Holidays – All full-time and part-time with benefits employees receive days off for 8 company-wide holidays, plus 2 additional floating holidays to be taken at the employee’s discretion. Vacation Time – All full-time employees at the manager and below level start with 14 days/year; director and above level start with 19 days/year. Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 84 hours/year. All employees gain additional vacation time with further tenure. Sick Time – All full-time employees receive 80 hours of sick time each year. Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 60 hours each year.
• Other Benefits Complementary stand-by cruises, employee discounts on confirmed cruises, plus special rates for family and friends Personal and professional learning and development resources including tuition reimbursement

#CCL

#LI-Remote

#LI-SH1