Data Warehouse Architect

3 weeks ago

Coral Springs, United States Cruise Planners Full time
Job DescriptionJob DescriptionSalary:

Cruise Planners is the largest franchisor of home-based travel agencies across the country that independently book cruises, tour, and land vacations. Cruise Planners has achieved Top Producer status with virtually every cruise line, tour, and resort company. Cruise Planners has been named the No.1 Cruise Tour / Travel Agency by Entrepreneur Magazine for the past 10 years and recently featured in Entrepreneur as one of the top 30 franchise innovators in technology. Cruise Planners positions franchise owners for success by providing them with innovative marketing, booking and lead-generating tools as well as professional development and hands-on training with the industry’s top executives. Cruise Planners Home Office was won awards such as Coolest Offices and Top Places to Work in South Florida by Sun Sentinel and South Florida Business Journal.


 

Role Title: Data Warehouse Architect


Job Summary: We are seeking a skilled and experienced Data Warehouse Architect to join our team. The ideal candidate will be responsible for designing, building, and managing an AWS-based data warehouse, as well as preparing data for ETL processes that will be utilized by Power BI and Excel. This position offers a fully remote working arrangement, available to candidates based in the United States (excluding California).


Responsibilities:

  • Design and Architecture: Design, implement, and manage scalable data warehouse solutions on AWS, ensuring efficient storage, retrieval, and processing of data.
  • Data Modeling: Develop and optimize logical and physical data models to meet business requirements and support BI tools like Power BI and Excel.
  • ETL Pipelines: Build and maintain ETL pipelines to extract, transform, and load data from various sources into the data warehouse, ensuring data quality and integrity.
  • Data Preparation: Prepare datasets to be consumed by end-users, primarily for analysis and reporting through Power BI and Excel, optimizing for performance and usability.
  • Cloud Infrastructure Management: Manage AWS resources, including Redshift, S3, Glue, Lambda, and other data-related services, ensuring efficient performance, cost management, and security.
  • Collaboration: Work closely with developers, Business Intelligence Specialist, and other stakeholders to understand their data requirements and ensure that data is structured and accessible for reporting.
  • Performance Optimization: Monitor and improve the performance of the data warehouse, tuning queries, and optimizing storage and retrieval strategies.
  • Documentation: Create and maintain detailed documentation of the data architecture, ETL processes, and data models.


The items listed above are intended to provide an overview of the essential functions of the job.

This is not an exhaustive list of all functions and responsibilities that the position may be required to perform.


 

Competencies:

  • Minimum 3 to 5 years of experience working as a Data Warehouse Architect, Data Engineer, or similar role, with hands-on experience in AWS data warehouse technologies.
  • Expertise in designing and managing data warehouses on AWS (Redshift, S3, Glue, etc.).
  • Strong experience with ETL tools and processes, particularly in preparing data for use in Power BI and Excel.
  • Proficiency in SQL and scripting languages (e.g., Python) for data processing and automation.
  • Familiarity with BI tools, particularly Power BI and Excel, including how to structure data for optimal performance in these tools.
  • Experience in data modeling, query optimization, and database performance tuning.
  • Strong knowledge of data warehousing best practices and cloud architecture principles.
  • Excellent problem-solving and analytical skills.
  • Effective communication and documentation skills.
  • Experience with MySQL is required


 

Cruise Planners provides equal employment opportunities (EEO) to all team members and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, or status as a covered veteran in accordance with applicable federal, state and local laws. Cruise Planners complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities or team members. This policy applies to all terms and conditions of employment.


remote work

  • Enterprise Data Architect

    2 months ago

    Colorado Springs, United States Ent Credit Union Full time

    Job DescriptionJob DescriptionCompany DescriptionEnt Credit Union exists to improve the financial quality of life of the people we serve. This mission drives us every day, but we are more than our mission. We're also individuals using our unique abilities to make our organization, and the communities we serve, better than they were yesterday. We're a...

  • Lead Data Architect

    1 month ago

    Sandy Springs, United States Insight Global Full time

    An Insight Global client is looking for an Azure Data Architect to join their team in the Sandy Springs, GA area. This Architect will be 60% hands on with architecture, design, and data modeling while 40% of the time will be dedicated to providing assistance to others in the data + development organization. We need someone with a strong background in data...

  • Lead Data Architect

    1 month ago

    Sandy Springs, United States Insight Global Full time

    An Insight Global client is looking for an Azure Data Architect to join their team in the Sandy Springs, GA area. This Architect will be 60% hands on with architecture, design, and data modeling while 40% of the time will be dedicated to providing assistance to others in the data + development organization. We need someone with a strong background in data...

  • Data Analyst

    3 months ago

    Coral Springs, United States Vimergy Full time

    ROLE: We’re a fast-growing VMS brand in the ecommerce space and we're looking for a top-notch Data Analyst to join our team. As a key member of our IT team, you'll play a crucial role in understanding our data and driving growth. You'll have the opportunity to work on several high growth initiatives and collaborate with a talented team to help bring our...

  • Data Analyst

    1 week ago

    coral springs, United States Vimergy Full time

    ROLE: We’re a fast-growing VMS brand in the ecommerce space and we're looking for a top-notch Data Analyst to join our team. As a key member of our IT team, you'll play a crucial role in understanding our data and driving growth. You'll have the opportunity to work on several high growth initiatives and collaborate with a talented team to help bring our...

  • Data Analyst

    3 months ago

    Coral Springs, United States Vimergy Full time

    ROLE: We’re a fast-growing VMS brand in the ecommerce space and we're looking for a top-notch Data Analyst to join our team. As a key member of our IT team, you'll play a crucial role in understanding our data and driving growth. You'll have the opportunity to work on several high growth initiatives and collaborate with a talented team to help bring our...

  • Warehouse Operation Supervisor

    3 months ago

    Bonita Springs, United States Florida's Decorators Warehouse Full time

    Job DescriptionJob DescriptionFloridas Decorators Warehousing & Delivery was founded in 1997 to receive, inspect, store, and deliver furniture on behalf of nationally renowned interior designers. Additionally, we provide full-service warehousing for contractors, manufacturers, schools, hotels, restaurants and more. We have grown exponentially over our...

  • Warehouse Operation Supervisor

    3 months ago

    Bonita Springs, United States Florida's Decorators Warehouse Full time

    Job DescriptionJob DescriptionFlorida’s Decorators Warehousing & Delivery was founded in 1997 to receive, inspect, store, and deliver furniture on behalf of nationally renowned interior designers. Additionally, we provide full-service warehousing for contractors, manufacturers, schools, hotels, restaurants and more. We have grown exponentially over our...

  • Big Data Solutions Architect

    3 weeks ago

    Colorado Springs, CO, United States DISH Full time

    Company SummaryDISH, an EchoStar company, has been reimagining the future of connectivity for more than 40 years. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products and now we are building Americas First Smart Network.Today, our brands include EchoStar,...

  • Senior Data Scientist

    5 days ago

    Coral Springs, United States Vimergy Full time

    ROLE: We’re a fast-growing VMS brand in the ecommerce space and we're looking for a top-notch Senior Data Scientist to join our team. As a key member of our Finance team, you'll play a crucial role in understanding our data and driving growth. You'll have the opportunity to work on several high growth initiatives and collaborate with a talented team to...

  • IT Data Analyst, Consultant

    1 week ago

    Shingle Springs, United States Blue Shield of CA Full time

    Your Role The Data Analyst team is responsible for performing detailed data analysis, source to target designs, data profiling, and metadata management in support of new development, implementation or enhancement of existing data assets. The Data Analyst, Consultant will report to the Manager of Data Solutions and Asset Management. In this role you will...

  • Data Engineer

    6 days ago

    Coral Springs, Florida, United States SYMVOS CORP Full time

    About SYMVOS CORPSYMOVSCORP is a leading provider of business transformation services, dedicated to driving innovation today to create a better tomorrow. Using cutting-edge digital technologies, we offer business solutions that assist our clients in solving problems and creating possibilities.Job Role: Data EngineerAs a Data Engineer at SYMOVSCORP, you will...

  • Data-Driven Innovation Leader

    6 days ago

    Colorado Springs, Colorado, United States DISH Full time

    About DISHDISH, an EchoStar company, has been revolutionizing the future of connectivity for over 40 years. Our business scope encompasses satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and the development of America's First Smart NetworkTM.Our portfolio includes EchoStar,...

  • Cloud Solutions Architect

    1 week ago

    Coral Hills, Maryland, United States NavitsPartners Full time

    Job OverviewPosition: Cloud Solutions ArchitectKey Responsibilities:Design, construct, implement, and oversee essential infrastructure within AWS/Azure/GCP cloud environments at the enterprise level.Collaborate with business stakeholders and product managers to comprehend solution requirements and pinpoint architectural frameworks.Recommend strategies for...

  • Database Architect

    4 days ago

    Colorado Springs, Colorado, United States ActioNet Full time

    Job SummaryActioNet is seeking a highly skilled Database Architect to join our team. As a Database Architect, you will be responsible for designing, implementing, and maintaining our database systems.Key ResponsibilitiesDesign and implement database systems to meet business requirementsDevelop and maintain database schema and data modelsEnsure data security...

  • Sr Project Architect

    3 weeks ago

    Coral Gables, Florida, United States HOK Group, Inc Full time

    We are currently seeking a Sr Project Architect to join our team. As a Sr Project Architect, you, in partnership with the Sr Project Manager and Sr Project Designer, are accountable for project financial performance and team communication. Responsible for the issuance and content of deliverables, technical content of HOK documents and coordination of...

  • Sr Project Architect

    3 weeks ago

    Coral Gables, United States HOK Group, Inc Full time

    We are currently seeking a Sr Project Architect to join our team.  As a Sr Project Architect, you, in partnership with the Sr Project Manager and Sr Project Designer, are accountable for project financial performance and team communication.  Responsible for the issuance and content of deliverables, technical content of HOK documents and coordination of...

  • Senior Systems Architect

    2 weeks ago

    Colorado Springs, Colorado, United States ManTech Full time

    Elevate Your Career with ManTechAre you ready to contribute to a forward-thinking organization that values excellence and innovation? At ManTech International Corporation, we foster a collaborative atmosphere where your expertise can thrive. We are seeking a Senior Solution Architect to join our team.Key Responsibilities:Design and architect advanced...

  • Senior Systems Architect

    2 weeks ago

    Colorado Springs, Colorado, United States ManTech Full time

    Elevate Your Career with ManTechAre you ready to contribute to a forward-thinking organization that champions innovation and excellence? ManTech International Corporation is seeking a Senior Solution Architect to enhance our team.Key Responsibilities:Design and architect advanced systems solutionsOffer technical leadership and specialized knowledgeEngage...

  • Senior Systems Architect

    2 weeks ago

    Colorado Springs, Colorado, United States ManTech Full time

    Become a Key Player in Innovative SolutionsAre you ready to contribute to a forward-thinking organization that values creativity and excellence? At ManTech International Corporation, we are dedicated to fostering a collaborative atmosphere where your expertise can thrive. We are seeking a Senior Solution Architect to enhance our teams.Key...