Pivotal Solutions Logo

Pivotal Solutions

Data Architect

Reposted 21 Days Ago
Remote
Hiring Remotely in USA
Senior level
Remote
Hiring Remotely in USA
Senior level
Design and architect robust ETL/data pipelines on cloud platforms. Build and automate data ingestion and preprocessing using Spark/Databricks, AWS Glue, Airflow. Implement warehousing architectures (EDW, DM, ODS, MOLAP/ROLAP), ensure SQL-based data quality, use version control, and deliver tested production pipelines while communicating with stakeholders.
The summary above was generated by AI

This is a remote position.

Roles & Responsibilities


  • Strong verbal/written communication & facilitation skills. Ability to take a requirement document, work through any ambiguity and follow through to implementation independently
  • Strong analytical and problem-solving abilities
  • Strong work ethic, sense of ownership and a team player
  • Architect and design robust ETL processes using tools like Spark, Airflow, AWS Glue etc. to desired client specifications
  • Ability to analyze the data to identify the necessary pre-processing steps for the automated ETL processes
  • Solid understanding of SQL using databases like MS SQL Server, Redshift, etc.
  • Experience in Cloud Infrastructure (AWS, Azure, GCP)
  • Delivering the data pipeline with Quality and automated testing


Required Skills


  • Bachelor’s degree in computer science, information technology, or a related field.
  • Extensive knowledge of coding languages used to build data pipelines, such as Java, Scala, and/or Python
  • Experience with Databricks or Spark
  • Hands on experience building data pipelines in AWS using AWS Glue, Redshift, S3 buckets and other relevant technologies.
  • Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW.
  • Proven work experience as an ETL developer.
  • Experience using Source Code and Version Control systems like Git etc.
  • Strong project management skills.
  • Ability to analyze a company’s big-picture data needs.
  • Clear communication skills.
  • Ability to troubleshoot and solve complex technical problems.
  • Desire to continually keep up with advancements in data best practices


Similar Jobs

13 Days Ago
Remote or Hybrid
US
128K-193K Annually
Senior level
128K-193K Annually
Senior level
Information Technology
Designs and delivers Microsoft Fabric, Azure AI, Power BI, and generative AI architectures for enterprise clients. Leads solution design, prototyping, implementation readiness, governance, quality assurance, and client enablement across complex engagements. Develops AI solution patterns including RAG, vector search, embeddings, semantic search, and prompt orchestration. Leads project and client teams, supports business cases and proposals, reviews technical deliverables, manages risks, and serves as a trusted technical advisor.
Top Skills: AzureAzure AiAzure Ai SearchAzure OpenaiCi/CdCopilotEltEmbeddingsGenerative AiMicrosoft FabricOnelakePower BIPrompt EngineeringPysparkPythonRbacRetrieval-Augmented GenerationSemantic SearchSparkSQLVector Search
5 Days Ago
In-Office or Remote
113K-193K Annually
Senior level
113K-193K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads technical delivery of Master Data Management solutions using Informatica MDM and PowerCenter. Designs and implements ETL mappings, workflows, transformations, data quality processes, governance practices, SQL data marts, and Python automation. Oversees MDM specialists, monitors production jobs, troubleshoots operational issues, supports testing and validation, tunes performance, documents technical solutions, and collaborates with state agencies, QA, business teams, and project leadership.
Top Skills: APIsAzureAzure Data FactoryData LakeDatabricksEdiFhirHl7Informatica MdmInformatica PowercenterJSONPythonSnowflakeSQLTeradataX12XML
Yesterday
Remote
United States
Expert/Leader
Expert/Leader
Artificial Intelligence • Cloud • Information Technology • Cybersecurity
Leads enterprise API and data architecture for a secure federal and DoD-aligned environment. Designs REST and GraphQL interfaces, microservices boundaries, data contracts, integration patterns, governance standards, and Zero Trust security controls. Partners with engineering, cybersecurity, cloud, product, and mission teams on scalable API ecosystems, observability, performance, modernization, and technical governance. Requires an active Secret clearance, bachelor’s degree, 10+ years of relevant experience, and CompTIA Security+ certification.
Top Skills: Api GatewaysAws GovcloudComptia Security+Developer PortalsDevsecopsEvent StreamingEvent-Driven ArchitectureGraphQLJSONJwtMessage BrokersMicroservicesOauth2RestSAMLService MeshesZero Trust

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account