Senior Engineer, Data Warehouse

• 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

• 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)
• 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

Understanding of casino player related data is a plus

• 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