This role is remote, with one required visit to your designated home office per quarter.

Remote option is available for employees located in the following states; AZ, CO, CT, FL, GA, IA, IL, IN, LA, MA, MD, MI, MS, MT, NC, NJ, NV, NY, OH, OR, PA, SC, TX, TN, WA, WV, and Washington D.C. (States subject to change at any time)

Home Office: Jersey City, NJ

With William Hill now a part of Caesars Entertainment, we plan to lead the pack by delivering products our customers love to use! As Caesars/William Hill, we operate sports betting in 18 U.S. jurisdictions and have partnerships with the biggest leagues and media companies in the country including, the NFL, MLB, NBA, NHL, ESPN, and CBS Sports. Marking a major milestone in American sports history, we opened the first-ever sports betting venue within a professional United States sports facility, the Caesars Sportsbook at the Capital One Arena in Washington D.C. Partnerships like this are positioning our business to skyrocket as sports betting continues to expand across the country and our customers get a taste of the action.

On the Technology side, we’ve built an entire sports betting and iGaming platform from the ground up in less than 3 years. Through continuous improvement and data-informed product development, we are adding features so that our customers have the best product experience in the market. Our Product Technology team is comprised of the brightest minds in Tech, and our culture of autonomy and decisiveness gives the team the freedom to deliver without constantly seeking permission to take action. We chart our own path and innovate as we create the next generation of products. We’re looking for like-minded superstars that want to work with the best of the best and join the biggest name in sports betting and iGaming as we take over the U.S. market!

What You Will Do:

• Lead the collection, analyzing and testing of data for our data warehouse
• Be an expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts and communicating relevant insights to the team
• Love to collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needs
• Experience with both traditional and big data streaming
• Create and maintain complex SQL queries such as; type 2 triggers, various joins, aggregations, groupings and more
• Execute ETL jobs using orchestration tools (airflow/scheduler/SQL agent)
• Have a working knowledge and testing experience of ETL
• Be proactive with leadership abilities with a strong “can do attitude”
• Possesses heavy experience with automation testing for ETL
• Highly detailed oriented
• Strong willingness & comfort taking on and challenging development approaches
• Conduct and facilitate UAT
• Previously worked in agile and scrum

 What You Will Need:

• Solid understanding of test Automation architecture, framework, and Automation script creation using programming language Python, Bash Scripts etc. and Orchestration tools like Apache Airflow, Luigi
• Strong knowledge of creating SQL queries for source to target database validation and Data warehouse testing
• Hands-on experience interpreting and understanding data models and ER diagrams
• Experienced in traditional SQL DB (mysql, postgres, sql server) and cloud native data warehouses Snowflake or Redshift
• Experienced in ETL tools Informatica, ab initio, Talend, and reporting tools - Tableau and PowerBI
• Create and execute strategies and test cases for applications that use ETL components
• CI/CD implementation through Jenkins/GitLab/Maven
• Experienced with HP ALM, Jira, rally any agile test management tools
• Implement the orchestration of business flows on given problem statements for the automation of complex scenarios
• Review technical requirements with data warehouse and business intelligence terminology to produce test strategies, test scenarios, and test cases for the data warehouse team
• Create the test plan for the software release, defining resources, and test suites required for each test cycle, dependencies, risks, and the overall strategy for testing complex systems and applications
• Experienced in using frontend (UI) to generate test scenarios and validate data in the backend
• Write Python test using unit test framework
• Experience with Kafka messaging is desired
• Rest APIs
• Docker and Kubernetes experience is a nice to have
• Sports Betting and Gambling domain knowledge is a plus

William Hill provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, national origin, ancestry, sex, age, physical or mental disability, pregnancy, veteran or military status, genetic information, sexual orientation, gender identity or expression, marital status, civil union/domestic partnership status, familial status, domestic violence victim status, or any other legally recognized protected basis under federal, state or local laws.  William Hill complies with applicable federal, state and local laws governing nondiscrimination in employment in every location in which the company has facilities.  This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training

#LI-OG1