GCP Data Engineer - Aptask : Job Details

Rate: $50-$60/Hr Job Description:

• Senior Data Engineer to help modernize and scale our Business Intelligence data infrastructure.
• This role will be critical in transitioning our existing on-prem SQL Server-based dimensional data mart and SSIS pipelines into a cloud-native solution on Google Cloud Platform (GCP) using tools like DBT, BigQuery, and other GCP-native services.
• This is a hands-on engineering role focused on building robust, scalable data pipelines and enabling performant data models that power Tableau dashboards used throughout the organization.

Responsibilities:

• Lead the migration of the existing SSIS-based ETL workflows to cloud-native pipelines using DBT and/or GCP tools such as Dataflow, Dataform, or Cloud Composer (Airflow).
• Design and implement scalable, efficient data models in BigQuery, following best practices for dimensional modeling.
• Optimize and maintain existing SQL transformations, ensuring correctness and performance in the cloud.
• Collaborate with BI developers and analysts to ensure data marts align with Tableau reporting needs.
• Ensure data integrity, security, and lineage through testing, documentation, and observability practices.
• Work with on-prem teams to phase out legacy systems and design transitional architectures where needed.
• Establish best practices and mentor junior engineers on cloud-Client engineering patterns.

Qualifications:

• 5+ years of experience in data engineering with strong SQL and ETL skills.
• Experience with SSIS and legacy SQL Server-based data marts.
• Proficiency in Google BigQuery and/or similar cloud data warehouses.
• Hands-on experience with DBT or modern transformation frameworks.
• Strong knowledge of dimensional modeling and data warehousing principles.
• Experience migrating on-prem pipelines to cloud platforms.
• Familiarity with GCP-native services such as Cloud Storage, Pub/Sub, Dataflow, Composer, and IAM.
• Strong knowledge of Healthcare Information Systems.

Preferred:

• Experience supporting or integrating with Tableau-based BI solutions.
• Exposure to infrastructure-as-code tools like Terraform for GCP.
• Knowledge of data observability tools and practices.
• Comfortable with Git-based CI/CD for data pipeline deployments.

Nice to Have:

• Familiarity with GCP networking and cost optimization strategies.
• Experience with data validation or automated testing frameworks for pipelines.
• Knowledge of metadata management or cataloging tools (e.g., Data Catalog, DataPlex).

What You'll Bring:

• A builder's mindset with a bias for simplification and automation.
• A collaborative approach to working with BI and application teams.
• The ability to balance long-term platform scalability with short-term deliverables.
• A passion for cloud innovation and data platform modernization.

About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment. Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview. Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment. If you have any concerns or queries about your personal information, please feel free to contact our compliance team at [email protected] . Applicant Consent: By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy , and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-###-#### or [email protected]. Message frequency may vary. Msg & data rates may apply.