Do you want to work in a fast-paced and exciting environment, where no two days are the same? We're looking for a Senior Data Analyst who enjoys both a buzz and a challenge?
Senior Data Analyst
Full-time, (home)based in the US
We're BCD Travel, one of the world's leading corporate travel management companies with offices around the globe. We help our clients travel smart and achieve more. People join our company because we provide a dynamic work environment, where no two days are the same. And our people stay with us because we care about their work-life balance. But don't just take our word for it: we've been voted top place to work and recognized by Investors In People, Flexjobs and Forbes.
In this role you will be responsible for the ongoing technical data support, including support for data development and testing activities of travel reporting data. You will be working closely with manager, regional resources and stakeholders to provide on-going support and communicate any delays impacting the customer SLAs. Additionally, the position will support the manager on other key initiatives and department projects.
A snapshot of this opportunity
Responsible for the 2nd level functional data support across the Travel data reporting platform. Encompassing Data and ETL processes
Monitor data audits and take action to resolve anomalies and discrepancies
Participate in data analysis efforts and data quality scoring related to data development and data integration initiatives
Formulate test plans in accordance with the functional requirements and lead testing efforts
Responsible for all data augmentation processes, including: Process documentation around Implementation, Changes, De-Implementation. Review and approve data augmentation requests
Create, interpret, and run medium to high complexity SQL scripts to aid in the research and problem solving
Responsible for the development and maintenance of custom extracts, data queries and Ad-Hoc requests, to support customer and company deliverables
Support the JAMS scheduling tool and ensures standards for setting up the recurring jobs
Keep abreast of technologies and industry trends and manager abreast of any process or workload challenges that may impact SLAs
Escalate issues relating to data development, data research, data deliver and/or quality issues
Works closely with managers within the department and stakeholders to communicate impacts related to the development deliverables, data processing for reporting and customer SLA risks
Provide status updates on tasks and projects, outlining accomplishments, progress, challenges
Collaborates with stakeholders to develop and implement business facing data and quality reporting
Works with Manager to develop SOP standards from an implementation, support, data collection, data development and data management perspective
Follow proper human resources and company processes and policies
How you can set yourself apart
College degree, preferably in the computer related field, or equivalent technical work experience
Able to work extended and or off-hours as needed or required
Occasional overnight travel may be necessary
Extensive experience working in a technical role, supporting all aspects of the data lifecycle and reporting systems
Strong technical background, including knowledge of database systems, data life cycle, data quality processes and standards & ETL processing
Competency with SQL and query tools and ability to effectively write, interpret queries and results
Able to write medium/high complexity SQL code
Solid knowledge of the global data environment and data capabilities
Competency collecting and writing functional requirements and test plans
Strong knowledge of data integration and data development processes
Able to write medium to high complexity data extracts
Knowledge working with JAMS scheduler - Building and managing jobs and schedules.
Proven ability to manage documentation processes and standards across functional groups
What we offer you
At BCD Travel, we work with highly motivated and passionate people. We value open communication, collaboration, and a flexible work-life balance. We offer unique, often global, experiences that empower you to develop and grow within the organization. Sustainability and helping others is also high on our list. We make a difference through charitable activities in our communities across the globe.
About us
BCD Travel helps companies make the most of what they spend on travel. We give travelers innovative tools that keep them safe and productive and help them make good choices on the road. We partner with travel and procurement leaders to simplify the complexities of business travel, drive savings and satisfaction, and move whole companies toward their goals. In short, we help our clients travel smart and achieve more. We make this happen in 109 countries with a global client retention rate of 98%, the highest in the industry. For more information, visit www.bcdtravel.com .
Interested?
Create your profile and upload your resume/cover letter via our website. Feel free to reach out to us with any questions via careers@bcdtravel.com. Note: send your application via the website only.
Stay informed about new career opportunities at BCD Travel
Use the 'notify me' button in our careers center to be one of the first to hear about interesting opportunities in the future. On the left-hand side of the screen, you can select filters to see updates on all vacancies that match your interest.
*Note: We'll give preference to internal and/or furloughed employees.
BCD Travel is committed to creating a diverse work environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, national origin, disability, age and veteran status. BCD Travel complies with applicable laws in the countries in which we operate. We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at careers@bcdtravel.com.
