Data Warehouse Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and maintain data pipelines, integrations, and automation for hotel operations and corporate systems reporting.

• Write clean, well-documented Python code and efficient SQL queries.

• Create Snowflake solutions using Notebooks, Snowpark, tasks, and stored procedures.

• Ingest data from APIs, flat files, and third-party PMS, revenue, and financial platforms into Snowflake and the broader data warehouse.

• Collaborate with the Data Management & Analysis team on tools, integrations, and automation for Atrium’s AI infrastructure.

• Convert business requirements into technical solutions.

• Test, document, and support delivered solutions, including User Acceptance Testing (UAT) with end users.

• Resolve production issues as they arise.

• Participate in code review sessions.

• Adhere to secure Software Development Life Cycle (SDLC) practices.

⛳️ Requirements

• 3–5 years of professional software development experience.

• Entry-level candidates with strong internship or project experience will be considered.

• Proficient in Python programming.

• Strong SQL skills, including the ability to write and troubleshoot relational database queries.

• Practical experience with Snowflake, including SQL development, Notebooks, Snowpark, tasks, and stored procedures.

• Experience integrating APIs, files, and third-party systems into a cloud data warehouse.

• Proficient in Git and experienced in working within a shared codebase.

• Excellent communication and problem-solving abilities.

• Capability to explain technical concepts to non-technical stakeholders.

• Ability to troubleshoot production issues and manage multiple priorities effectively.

• Experience in cloud platforms, hospitality systems, or Business Intelligence (BI) preferred.

• Familiarity with Azure or AWS preferred.

• Experience with REST APIs, PMS/CRS/revenue platforms, and Tableau or Power BI preferred.

🏝️ Benefits

• Career Growth & Learning opportunities.

• 401(k) plan with company match.

• Options for medical, dental, and vision insurance.

• Paid time off and vacation benefits.

• Atrium Traveler and brand discount programs.

• DailyPay options.

• Wellness programs available.

• Tuition reimbursement for continued education.

• Exclusive discounts on brands and services.

• Opportunities for community service and volunteer programs.

• Continuous learning and development support.

• Access to coaching, development, and mentoring.