Tableau Data Engineer

Associates Systems LLC; Town of Guilderland (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

Associates Systems LLC seeks an analytics engineer to design and implement self-service analytics on a cloud data platform with Tableau for a State agency client. You will provision environments, define data models and source-to-target mappings, build data ingestion pipelines, and develop Tableau dashboards with live/extract connections.

You will also contribute to technical design docs and support a scaling roadmap for broader production rollout, using Python or shell scripting for automation

Qualifications

• Experience provisioning and configuring cloud data platform environments (databases, schemas, compute, RBAC).
• Proficiency in SQL for data transformation and quality validation.
• Experience with data loading/ingestion: streaming, micro-batch, bulk.
• Design/implement cloud-native ETL/ELT pipelines (batch, CDC).
• Strong knowledge of layered data architecture (Medallion/LDL Bronze-Silver-Gold).
• Experience with logical/physical data modeling and source-to-target mappings.
• Tableau development incl. workbooks, dashboards, live/extract connections on cloud data sources.
• Familiarity with Tableau row-level security and user-based access controls.
• Knowledge of cloud data services including object storage and replication/migration.
• Produce technical design docs, mapping specs, and functional test artifacts.
• Familiarity with Python or shell scripting for automation.

Responsibilities

• Support design/implementation of self-service analytics on a cloud data platform and Tableau for a State agency client.
• Provision environment, define data models and source-to-target mappings, build ingestion pipelines.
• Develop Tableau dashboards and conduct functional testing.
• Contribute to technical design documentation and scaling roadmap for broader rollout.

Skills

Cloud data platform

SQL data transformation

Data ingestion pipelines

Tableau dashboards

RBAC

ETL/ELT pipelines

Data modeling

Tableau security/RLS

cloud services

Python scripting

Shell scripting

Documentation

Tools

Terraform

GitLab CI/CD

Job description

All qualified resumes responded to in 48hrs or less US Citizen in good standing willing to hold a US Government

Role Description

Support the design and implementation of self-service analytics on a cloud data platform and Tableau for a State agency client. Responsibilities include provisioning the environment, defining data models and source-to-target mappings, building data ingestion pipelines, developing Tableau dashboards, and conducting functional testing. The engineer will also contribute to technical design documentation and support the development of a scaling roadmap for broader production rollout.

Technical Skill Set

• Hands-on experience provisioning and configuring cloud data platform environments including databases, schemas, compute resources, and role-based access control (RBAC)
• Proficiency in SQL for data transformation, stored procedures, and data quality validation
• Experience with data loading and ingestion mechanisms including streaming, micro-batch, and bulk load patterns
• Experience designing and implementing cloud-native ETL/ELT pipelines using batch and CDC-based ingestion patterns
• Strong understanding of layered data architecture concepts (Medallion / Landing - Bronze - Silver - Gold)
• Experience with logical and physical data modeling and producing source-to-target mapping specifications
• Hands-on Tableau development including workbooks, dashboards, and cloud data platform-connected data sources with live and extract connection configurations
• Familiarity with Tableau row-level security (RLS) and user-based access controls
• Working knowledge of cloud data services including object storage and database migration/replication services
• Ability to produce technical design documentation, data mapping specifications, and functional testing artifacts for both technical and business audiences
• Familiarity with Python or shell scripting for pipeline automation and workflow orchestration

Nice to Have

• Experience with IaC tooling such as Terraform or GitLab CI/CD
• Prior experience on State/public sector engagement
• US clearance preferred- secret