BI Developer

Job Location
Dallas, Texas
Department
Engineering
Job Introduction
ID90 Travel is looking for a passionate Business Intelligence (BI) Developer to create and manage BI and analytics solutions that turn data into knowledge. The successful BI Developer will be able to combine the ability to design and build in multiple BI solutions with the ability to identify trends to discuss with business leaders. In this role, you should have a background in data and business analysis. You should be analytical and possess excellent communication skills. If you also have a business acumen and problem-solving aptitude, we’d love to meet you.

Ultimately, you will enhance our business intelligence system to help us make better and more timely with decisions.
Position Responsibilities
  • Design, build, and deploy BI solutions (e.g. Birst, Pentaho, and/or Periscope)
  • Craft and execute queries upon request for data
  • Present information through reports and visualization
  • Translate business needs to technical specifications
  • Create tools to store data (e.g. OLAP cubes)
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing BI systems
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
  • Work across all business units to evaluate BI needs
Required Qualifications
  • Proven experience as a BI Developer or Data Scientist
  • Travel Industry experience is preferred
  • Background in data warehouse design (e.g. dimensional modeling) and data mining
  • In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework
  • Familiarity with BI technologies (e.g. Birst, Periscope)
  • Performance Tuning: Query Optimization, Schema Optimizations, and MySQL Server Variables
  • Ability to code complex SQL queries
  • Experience with Pentaho
  • Experience with programming languages
  • Excellence in troubleshooting of database issues
  • Strong interpersonal, communication, and project management skills
  • Proven abilities to take initiative and be innovative
  • Analytical mind with a problem-solving aptitude