Apply on Employer Site

DataSync · 3 months ago

Senior Technical Reporting Manager, ETL Reporting Engineer-AWS Data Platform/Tableau

Henderson, Nevada

Full-time

Onsite

Mid, Senior Level

$120K/yr - $130K/yr

5+ years exp

DataSync is a company specializing in data solutions, and they are seeking a Senior Technical Reporting Manager to design and maintain enterprise-scale data pipelines using AWS cloud services. The role involves building ETL workflows, developing serverless data processing, and creating data feeds for reporting platforms like Tableau.

Information TechnologySaaSSoftware

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Build and orchestrate ETL/ELT workflows using Apache Airflow for complex data pipeline management

Develop serverless data processing with AWS Lambda and EventBridge for real-time transformations

Create scalable ETL jobs using AWS Glue with automated schema discovery and catalog management

Execute database migrations and continuous replication using AWS DMS

Design and optimize Amazon Redshift data warehouses and Amazon Athena federated queries

Implement streaming data pipelines with Apache Kafka for real-time ingestion

Manage schema changes in data feeds with automated detection and pipeline adaptation

Create data feeds for Tableau and BusinessObjects reporting platforms

Qualification

AWS data platformETL/ELT workflowsApache AirflowAWS LambdaAWS GlueAWS DMSAmazon RedshiftApache KafkaSQLTableauData modelingData qualityData visualizationCollaborationProblem-solvingCommunication

Required

Build and orchestrate ETL/ELT workflows using Apache Airflow for complex data pipeline management

Develop serverless data processing with AWS Lambda and EventBridge for real-time transformations

Create scalable ETL jobs using AWS Glue with automated schema discovery and catalog management

Execute database migrations and continuous replication using AWS DMS

Design and optimize Amazon Redshift data warehouses and Amazon Athena federated queries

Implement streaming data pipelines with Apache Kafka for real-time ingestion

Manage schema changes in data feeds with automated detection and pipeline adaptation

Create data feeds for Tableau and BusinessObjects reporting platforms

Airflow: DAG development, custom operators, workflow orchestration, production deployment

Lambda: Serverless functions, event triggers, performance optimization

EventBridge: Event-driven architecture, rule configuration, cross-service integration

Glue: ETL job development, crawlers, Data Catalog, schema management

DMS: Database migrations, continuous replication, heterogeneous database integration

Redshift: Cluster management, query optimization, workload management

Athena: Serverless analytics, partitioning strategies, federated queries

Tableau (Expert Level): Develop and maintain data analogs, data cubes, queries, data visualization and reports

Assist in testing code, governance, data quality, and documentation effort

Reported data and visualizations and reports

Collaborate with data stewards to test, clean, and standardize

Evaluate patterns and meaningful insights from data through qualitative and quantitative analysis

Apache Kafka: Stream processing, topic design, producer/consumer development

SQL: Advanced querying across multiple database platforms (PostgreSQL, MySQL, Oracle)

Python/Scala: Data processing, automation, custom pipeline development

Schema Management: Automated detection, evolution strategies, backward compatibility

Tableau: data modeling

Tableau: Data source optimization, extract management, connection configuration

BusinessObjects: Universe design, report development, data feed creation

Tableau: Design and Code rewrite

5+ years AWS data platform development

3+ years production Airflow experience with complex workflow orchestration

Proven experience managing high-volume data feeds (TB+ daily) with schema evolution

Database migration expertise using DMS for enterprise-scale projects

BI integration experience with Tableau and BusinessObjects platforms

Tableau: 2 plus year

Design fault-tolerant data pipelines with automated error handling and recovery

Handle schema changes in real-time and batch data feeds without pipeline disruption

Optimize performance across streaming and batch processing architectures

Implement data quality validation and monitoring frameworks

Coordinate cross-platform data synchronization and lineage tracking

Preferred

AWS Data Analytics Specialty or Solutions Architect Professional certification

Experience with Infrastructure as Code (Terraform, CloudFormation)

Knowledge of DataOps practices and CI/CD for data pipelines

Containerization experience (Docker, ECS, EKS) for data workloads

Company

DataSync

DataSync is an information technology company that offers SaaS-based portal for enterprise services.

Founded in 2005

Sioux Falls, South Dakota, USA

11-50 employees

http://datasyncsolutions.com/

H1B Sponsorship

DataSync has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (14)

2024 (12)

2023 (15)

2022 (21)

2021 (12)

2020 (30)

Funding

Current Stage

Early Stage

Total Funding

$2.66M

Key Investors

Bird Dog Equity Partners

2016-02-03Series Unknown· $0.2M

2015-04-13Series Unknown· $1.05M

2009-12-11Series Unknown· $0.91M

Recent News

PRNewswire

Introducing Terminal49 DataSync: Revolutionizing Container Tracking and Milestone Syncing for Streamlined Operations

2023-07-06

TECHCOMMUNITY.MICROSOFT.COM

Lesson Learned #363: Incorrect syntax near the keyword 'NOT' using DataSync

2023-06-07

Amazon Web Services

Move data in and out of AWS GovCloud (US) with AWS DataSync

2022-06-03

Company data provided by crunchbase