Business Intelligence Engineer

Job Description

The Business Intelligence Engineer is responsible for designing and maintaining scalable data pipelines, transforming raw data into analytics-ready datasets, and developing robust reporting solutions that support strategic decision-making across Westgate.

• Backend ETL Development (≈ 65%): Designs, builds, and maintains automated data pipelines using SQL, Alteryx, Python, Snowflake, and Oracle. Gathers and documents business requirements and operational logic from stakeholders across the org. Translates nuanced business rules from Yield, Inventory, Operations, Dialer, and Loyalty into accurate and scalable ETL processes. Cleans, transforms, reconciles, and validates large datasets from LMS, TSW, Oracle, and other systems. Optimizes pipeline performance, reliability, and data freshness. Partners with IT on schema alignment, integration issues, and resolving data flow inconsistencies. Maintains documentation for data models, transformation logic, and pipeline dependencies.
• Reporting Development & Dashboarding (≈ 35%): Develop, enhance, and maintain Tableau dashboards used across Inventory, Operations, Marketing, Call Center/Dialer, Loyalty/Owner Engagement, and executive teams. Build reporting assets that support forecasting, budgeting, operational oversight, and yield optimization. Conduct unit testing and validate output logic to ensure accuracy and consistency. Improve report design, automation, usability, and performance for business stakeholders.

Qualifications

• Experience: 3-5 years of relevant experience developing ETL workflows in Alteryx, Python, and/or comparable tools.
• Education & Certifications: Associate’s degree in Computer Science, Data Science, Statistics, Applied Mathematics, or related field. Bachelor’s degree preferred.
• Skills/Knowledge: Familiarity with Snowflake, Oracle, LMS, TSW, and enterprise data ecosystems. Proficiency with Tableau or similar data visualization tools. Advanced Excel proficiency (pivot tables, formulas, modeling). Ability to manage large datasets and perform detailed reconciliation. Ability to understand complex operational processes and translate them into technical requirements. Strong quantitative skills, with the ability to interpret trends and identify business impacts. Understanding of sales forecasting, yield concepts, call center metrics, and operational KPIs. Ability to learn and adapt quickly to new processes and technologies. Ability to communicate technical concepts clearly to non-technical stakeholders. Strong verbal and written communication skills. Comfortable facilitating requirement sessions and documenting business rules. Ability to present insights and findings clearly and professionally. Highly organized with the ability to manage multiple projects simultaneously. Strong attention to detail and a commitment to accuracy. Ability to work independently and cross-functionally. Demonstrated initiative, follow-through, and problem-solving ability. Ability to independently analyze complex situations, identify patterns and trends, and evaluate multiple options for solving complex or ambiguous problems. Ability to adapt to changing circumstances.