Pivotal Solutions Logo

Pivotal Solutions

Data Architect

Reposted 2 Months 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
120K-140K Annually
Senior level
120K-140K Annually
Senior level
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Define and lead the architecture of NBCUniversal’s greenfield Microsoft Fabric enterprise data platform. Establish lakehouse, warehouse, integration, real-time streaming, data modeling, governance, security, DevOps, and observability standards. Translate architecture and business objectives into delivery roadmaps, epics, stories, and implementation plans while guiding multidisciplinary engineering teams. Design scalable solutions combining operational, historical, master, and reference data to support reporting, analytics, automation, AI, and reusable data products.
Top Skills: Amazon KinesisAPIsAzure DevopsAzure Event HubsBicepChange Data CaptureCi/CdData FactoryDelta LakeEventhouseEventstreamGithub ActionsKafkaLakehouseAzureMicrosoft FabricNotebooksOnelakePower BIPysparkPythonReal-Time IntelligenceSemantic ModelsSQLTerraformWarehouse
Yesterday
Remote
US
Senior level
Senior level
Information Technology • Internet of Things
Design and implement enterprise data architectures supporting batch and real-time analytics, ETL/ELT, data warehouses, streaming pipelines, CDC, and cloud data platforms. Build AI-ready data infrastructure for RAG, vector search, and Generative AI applications. The role requires production experience with Treasure Data/CDP, Kafka, Snowflake or Databricks, cloud services, and modern AI data engineering technologies.
Top Skills: Ai AgentsApache KafkaAWSAws BedrockAzureAzure OpenaiCdcData LakehouseDatabricksDebeziumEltEnterprise Data WarehousingETLEvent-Driven ArchitectureGCPGenerative AiLangchainLanggraphPythonRagReal-Time AnalyticsSemantic SearchSnowflakeSQLStreaming Data PipelinesTreasure DataTreasure Data CdpVector Databases
4 Days Ago
Remote
USA
210K-270K Annually
Senior level
210K-270K Annually
Senior level
Artificial Intelligence • Insurance • Software • Automation
Own the architecture and standards for a trustworthy BI analytics platform. Design data models, ingestion and transformation patterns, lineage, PII controls, reliability SLAs, observability, schema governance, and cost management. Partner with engineers, analysts, business leaders, Security, Legal, and Compliance; enforce testing, CI/CD, infrastructure as code, and data quality practices. Mentor data professionals and document architectural decisions.
Top Skills: AirflowAlationAtlanCi/CdCollibraDagsterDatahubDbtGitPythonSnowflakeSQLTerraform

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account