Engineer Sr., Data Warehouse

Carnival Corporation•Miami, FL

1d•Remote

About The Position

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.

Requirements

Strong knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and Microsoft technologies.
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 (e.g., 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 (e.g., 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 (i.e. email, reports, presentations) to be consumed by non-technical individuals.
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. (i.e. PCI, SOX, PII, etc.).
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)

Nice To Haves

Understanding of casino player related data is a plus.

Responsibilities

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 (i.e. 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 (e.g., 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.

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
401(k) plan that includes a company match
Employee Stock Purchase plan
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.
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