Senior Data Engineer ( GCP & BI) at Horizontal Talent in Cleveland, Ohio

Job Description:

3.20 Update: Team we have a NEW PENDING 100% REMOTE opportunity. The team has provided the top 3 skills they will be reviewing when scanning a resume. The rate for this position is lower, so while this role is PENDING, they are going to see if adjustments can be made to the rate. In the meantime, I wanted to provide the

Role Overview: Looking for a Senior Data Engineer ( GCP & BI Development) to support a 6+ month project. The top 3 skills this team is looking for on resumes are:

• 
  Familiarity with Google (GCP) Tools and Architecture
  
• 
  Visualization Expert (Tableau preferred)
  
• 
  Seasoned resource - This will be a lead role and need experience, good communication and creative ideas
  

Bill Rate/Salary - $59.81 ( The team is going to


Submittal Information

• NO C2C
• MMDD
• Right to Represent - "I_________ (Candidate Name), give __________ (Supplier Name), the right to represent me for the position of ___________ (Job Title and Job #) at Key Bank.
• SSN ( last 3 only)
• No Logo Resume - Pease include write up bullet points ONLY at the top of the resume underneath the name of your candidate.
• Required: Has this candidate applied with Key Bank in the last 12 months for a position?
• Required: Has this candidate ever worked with Key Bank before?
• Required: Please provide date of birth (MM/DD) and SSN ( last 3 digits only)

Write Up :

• Confirm years of experience
• Confirm they have experience with GCP tools and architecture
• Confirmed - visualization expert ( Tableau preferred)
• List any banking and financial experience
• List any lead experience in previous roles

Key Bank - REMOTE

Senior Data Engineer - GCP & BI Development
6+
Months

*Candidates must complete a background check & drug screen upon offer*

Job Description:
This role will help fulfill an important vision that the KeyBank Marketing Line of Business has in organizing various data streams (third party and internal data sources) into a single, scalable data warehouse in which several critical reports will be built from. We are seeking a Senior Data Engineer with expertise in Google Cloud Platform (GCP) to design and build data pipelines, database architectures, and robust reporting solutions. The ideal candidate has strong SQL skills, experience with GCP data services and tools while being able to visualize results through extensive Tableau development to transform raw data into meaningful insights.

Key Responsibilities: Data Pipeline Development

• Design, develop, and maintain ETL/ELT pipelines using Cloud Composer (Apache Airflow), Dataflow, Python and/or BigQuery.
• Optimize data ingestion, transformation, and storage for efficiency and scalability.
• Familiarity with setting up monitoring and/or alerting for data pipelines using Cloud Logging and Monitoring or other methodologies

Database Architecture & Data Modeling

• Assist with Marketing's "Clean Well of Data" project by creating, organizing and maintaining a data warehouse architecture in BigQuery, ensuring best practices in schema design, partitioning, and clustering.
• Ability to take general direction on where to pull date from and using SQL, discover how best to query and leverage them independently.
• Implement data governance and performance optimization techniques.
• Establish data cataloging and metadata management for structured documentation.

SQL Development & Performance Tuning

• Write and optimize complex SQL queries for business logic, aggregations, and transformations
• Implement stored procedures, views, tables, common table expressions (CTEs), and materialized views for efficient querying.
• Troubleshoot query performance issues.

Business Intelligence & Reporting (Tableau)

• Design and develop interactive dashboards and reports in Tableau.
• Integrate BigQuery with Tableau for real-time analysis through efficient data source setup.
• Work with stakeholders to understand business requirements and translate them into visual analytics solutions.

Horizontal facilitates valuable and productive conversations between you and potential employers. We can assist you in growing your career by partnering you with employers that offer challenging assignments. For those that join the team, we offer competitive compensation and benefits including medical, dental, vision, and retirement. Check out all we have to offer and how you can become part of the Horizontal Talent Team. The pay range for this role is $17 - $42 per hour. This is not a guarantee of compensation, as final offer amount may vary based on factors including but not limited to experience and geographic location. Apply Now