Pivotal Solutions Logo

Pivotal Solutions

Data Architect

Reposted 23 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

2 Days Ago
Remote
United States
Expert/Leader
Expert/Leader
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Lead complex data analyses, develop statistical models, write advanced SQL, build data models and dashboards, and establish technical standards for analytics. Mentor analysts, troubleshoot data quality and modeling challenges, partner with data engineering, translate ambiguous business questions into rigorous analyses, and communicate findings to senior stakeholders. Own the analytics function’s technical roadmap while ensuring data privacy and security practices.
Top Skills: A/B TestingCcpaData ModelingData WarehousingDatabricksETLGdprLookerPower BIRegression AnalysisSnowflakeSQLTableau
15 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
An Hour Ago
In-Office or Remote
United States
150K-180K Annually
Senior level
150K-180K Annually
Senior level
Aerospace • Information Technology • Cybersecurity • Defense
Lead data architecture for NAVSUP OIS, including database design, data modeling, warehouse strategy, ETL/ELT pipelines, migration, security, retention, backup, recovery, and performance optimization. Coordinate cloud and containerized environments, guide data engineers and DBAs, and support modernization from Oracle to cloud and analytical platforms. The role also provides technical leadership, architecture planning, integration, risk assessment, and policy development for mission-critical systems.
Top Skills: Amazon AuroraAmazon S3AWSAzureBigQueryClickhouseEtl/EltKafkaKubernetesMySQLOraclePl/SqlPostgresRedshiftSnowflakeSQL

What you need to know about the Austin Tech Scene

Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.

Key Facts About Austin Tech

  • Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
  • Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
  • Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
  • Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account