Data Solutions Engineer
Data Solutions Engineer
Company: Travel/Tourism
Location: Miramar, FL / In-Office
Type: Full-time
Applicants must be authorized to work in the US without visa sponsorship.
About the Company
This Global Travel & Tourism client of Focus GTS takes travel to the next level by specializing in providing luxury, premium, and adventure travel experiences through their fleet of cruise ships, offering vacations to destinations worldwide.
Role Overview
We are seeking a Data Solutions Engineer on behalf of this Company who thrives on innovation, collaboration, and delivering exceptional solutions. The position sits on the Data Analytics and AI Team reporting to the Sr. Manager, Data Solutions Engineering. The Data Solutions Engineer is responsible for building, managing, and optimizing reusable enterprise data pipelines effectively and in a timely manner through the development lifecycle to be used by internal consumers, such as business/data analysts and data scientists. The engineer would use both technical and analytical skills to understand and solve business problems using available resources and current technology stack, while ensuring data governance and data security compliance.
Key Responsibilities:
- Create, build, and maintain data pipelines from disparate sources that meet functional / non-functional business requirement
- Create, maintain and reuse existing ETL processes, employing a variety of data integration and data preparation tools
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing pipelines for greater scalability, etc.
- Work with stakeholders including Product, Data and Business teams to assist with data-related technical issues and support their data needs
- Create datasets for operational reports, key performance indicators/metrics, or other insights into current organizational activities
- Create datasets for analytics and data science to provide the ability to uncover the answers to major questions that help organizations make objective decisions and/or gain a competitive edge
- Write, debug and implement moderately complex queries involving multiple tables or databases across platform(s)
- Create and maintain technical design documentation
- Participate in requirements gathering
- Collaborate with the Enterprise Architecture team to ensure alignment on data standards and processes
- Highly analytical and interested in data visualization
- Work with data and analytics experts to strive for greater functionality in data systems
- The position requires on-call and off-hours support
Qualifications:
- Experience:
- Bachelor of Science in Computer Science, Information Technology or equivalent
- 3+ years of experience in a data/cloud engineering role
- 3+ years of experience working and creating datasets for a data warehouse
- Clear understanding of data modeling patterns (relational and dimensional)
- 3+ years of experience with ETL development tools, Informatica or Azure Data Factory (ADF) preferred
- 3+ years of cloud experience, Azure preferred
- Working knowledge and experience in using best practices in designing, building, and managing data pipelines that require data transformations as well as metadata and workload management
- Working knowledge and experience in working with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional and new data integration technologies (such as ETL, ELT, data replication, change data captures, message-oriented data movement, API design, stream data integration and data virtualization)
- Working knowledge and experience in performing root cause analysis on internal and external data and processes to identify issues and opportunities for improvement
- Skills:
- Ability to read and write SQL, PL/SQL, and/or T-SQL
- Hands on experience with scripting languages, such as Python, R, Java, Scala, etc.
- Knowledge of data storage concepts, such as databases, data warehouses, and data lakes
- Relational SQL databases, such as Oracle and SQL Server
- NoSQL databases are a plus
- Proven ability to collaborate with technical peers
- Capable of working independently and as part of a team
- Experience with and understanding of continuous integration and continuous deployment practices
- Agile
- Working knowledge of PySpark
- Soft Skills:
- Excellent communication and problem-solving skills
- Ability to work quickly and independently
- Experience supporting and working with cross-functional teams in a dynamic environment
- Demonstrate a certain degree of creativity with analytical and problem-solving skills
- Display curiosity in understanding the data for the specific area of responsibility
Why This Opportunity?
- Impact: Play a pivotal role in a company that thrives on innovation, collaboration, and delivering exceptional solutions
- Professional Growth: This is a HIGH STAKES role for a global client, ability to create a name for yourself!
- Culture: This client brings together employees spanning the global and is on the forefront of advanced digital engineering, technology solutions, and data-driven digital experiences, they create exceptional and efficient experiences for travelers.
Note: This position will work on-site in Miramar with travel to Miami office.