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.
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
- 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
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
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
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 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
