AWS Data Engineer

AWS Data Engineer/Analytics Architect

Seattle, WA (Hourly W2; Hybrid)

Applicants must be currently authorized to work in the United States on a full‑time basis. The employer will not sponsor applicants for work visas. The employer may not have resources available to support STEM OPT training requirements. No C2C – Pivotal does not accept unsolicited applications or resumes from third‑party recruiters/agencies.

We are a technology management consulting firm helping Fortune 500 companies improve their performance – we specialize in making People, Process, and Technology work together! Our clients count on us to deliver excellence and seek our guidance on business and technology strategy, technology modernization, and cloud transformation initiatives. Simply put; by listening to our clients closely and focusing on delivering quality, we bring them peace of mind.

After guiding and helping numerous clients from global enterprises to mid‑market firms to non‑profit organizations, we are now experiencing breakthrough growth!

Pivotal Consulting is seeking a senior‑level AWS Data Engineer / Analytics Architect to design, build, and operationalize scalable cloud‑based data platforms, pipelines, and analytics solutions for a major government/public sector data modernization initiative. The consultant will own end‑to‑end data architecture and engineering on AWS, enabling secure, reliable, and high‑quality data delivery and analytics across multiple projects and domains.

You will collaborate closely with engineers, product managers, data analysts, BI developers, data scientists, and business stakeholders to translate ambiguous business needs into production‑ready data assets, models, and visualizations.

• Conceptualize, design, and own scalable data architectures supporting multiple initiatives and products.
• Define data models, schemas, and standards for analytics, reporting, and operational use (dimensional, relational, semantic).
• Evaluate architectural tradeoffs balancing performance, scalability, security, governance, and cost.
• Influence product and engineering decisions through data‑driven architectural guidance.

• Design, develop, and maintain production‑ready ETL/ELT pipelines for structured and unstructured data using AWS Glue, Lambda, Step Functions, and S3.
• Implement and manage large‑scale data lake and data warehouse environments leveraging AWS services such as S3, Redshift, Athena, and related technologies.
• Develop and optimize data ingestion frameworks, transformations, and orchestration patterns, including serverless data workflows.
• Develop and maintain infrastructure‑as‑code (IaC) using Terraform or AWS Cloud Formation for data platform components.
• Build dashboards and analytical visualizations using tools such as Tableau, Power BI, or Quick Sight.

• Implement data security models aligned with privacy, compliance, and governance requirements, including government and regulated environment standards.
• Establish and evolve data quality, validation, and monitoring frameworks; identify and remediate data quality issues across pipelines and source systems.
• Ensure adherence to governance, metadata, cataloging, and lineage standards.

• Continuously optimize data pipelines, queries, and systems for performance, maintainability, scalability, and cost efficiency.
• Provide recommendations for cost‑efficient cloud architecture and resource utilization on AWS.
• Document architecture, processes, and code to ensure operational readiness and maintainability.
• Support knowledge transfer and enablement for client teams.

• Partner with engineering, product, analytics, and business teams to identify high‑impact data opportunities.
• Provide technical guidance and architectural leadership across cross‑functional teams.
• Communicate progress, risks, and issues clearly with both technical and non‑technical stakeholders.

• Data architecture designs and diagrams.
• Logical and…