Apps Dev Analyst-Cloud Data Engineer

The Smart
Tallahassee, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Tallahassee, United States of America

Tech stack

Agile Methodologies
Amazon Web Services (AWS)
Azure
Batch Processing
C Sharp (Programming Language)
Unix
Cloud Database
Information Systems
Computer Programming
Continuous Integration
Data Architecture
Information Engineering
Data Integration
ETL
Data Transformation
Data Mining
Data Synchronization
Data Warehousing
DevOps
Document-Oriented Databases
Systems Analysis
JSON
Job Scheduling
Python
Operational Databases
Oracle Applications
Scrum
Release Management
Cloud Services
SQL Stored Procedures
SQL Databases
Tableau
XML
Scripting (Bash/Python/Go/Ruby)
Cloud Platform System
Data Ingestion
GitHub Copilot
Delivery Pipeline
Snowflake
Generative AI
Information Technology
Data Analytics
Integration Frameworks
Kafka
Data Pipelines
Alteryx
Programming Languages

Job description

The Data Engineer / ETL Developer is responsible for designing, developing, and supporting enterprise data integration, ETL/ELT pipelines, and modern data warehousing solutions. This role works across cloud and on-premises environments to build scalable, reliable data pipelines and reporting systems. The position partners with cross-functional teams to implement data-driven solutions, support production systems, and contribute to modernization initiatives using cloud and advanced analytics technologies., ETL/ELT Development & Data Engineering

  • Design, develop, and maintain ETL and ELT pipelines for data extraction, transformation, and loading
  • Build and support data integration solutions across enterprise systems
  • Develop SQL scripts, stored procedures, and custom data transformation logic
  • Support batch processing and data ingestion workflows

Cloud Data Platforms & Warehousing

  • Develop and maintain data warehouse solutions using Snowflake and cloud platforms
  • Work with modern cloud data architectures in AWS or Azure environments
  • Support data warehouse implementation, optimization, and modernization initiatives
  • Apply best practices for data modeling, storage, and performance

Data Integration & Pipeline Automation

  • Design and implement data pipelines using tools such as Kafka, Oracle GoldenGate, or Striim
  • Automate workflows and data pipelines across cloud and on-premise systems
  • Manage change data capture (CDC) processes and data synchronization
  • Ensure data pipelines meet performance and SLA requirements

Reporting & Analytics Support

  • Develop dashboards and reports using Tableau Desktop
  • Support Tableau infrastructure including security, release management, and troubleshooting
  • Translate business intelligence requirements into data and reporting solutions

Production Support & Issue Resolution

  • Provide support for data warehouse operations, including troubleshooting data load and transformation issues
  • Perform root cause analysis and coordinate resolution of production incidents
  • Monitor data jobs, dependencies, and batch schedules

Architecture, Standards & Best Practices

  • Provide design recommendations aligned with long-term IT strategy
  • Develop and maintain data engineering standards, reusable code frameworks, and best practices
  • Contribute to enterprise architecture discussions and solution design activities

Collaboration & Delivery

  • Work closely with Scrum teams including architects, developers, QA, and DevOps
  • Participate in Agile development processes and cross-functional collaboration
  • Act as a technical mentor and subject matter expert for data engineering practices

Documentation & Quality Assurance

  • Document data pipelines, processes, and implementation details
  • Ensure testing, validation, and quality assurance practices are followed
  • Maintain clear and accessible technical documentation for knowledge transfer

Requirements

Do you have experience in XML?, Mid-Senior Level (3 or more years of relevant experience), * Bachelor's degree in Computer Science, Engineering, Information Systems, or related field, or equivalent work experience

  • 2 or more years of experience in programming or systems analysis
  • Experience with ETL/ELT development and data warehousing concepts
  • Experience working with Snowflake and Snowflake SQL
  • Proficiency in SQL development including scripting and stored procedures
  • Experience with data pipeline and integration tools such as Kafka or Oracle GoldenGate
  • Experience with modern programming languages such as Python, C#, or Scala
  • Experience with Tableau for reporting and dashboard development
  • Experience working in cloud environments such as AWS or Azure
  • Experience with batch job scheduling and data job dependency management
  • Strong understanding of data formats such as CSV, XML, and JSON
  • Experience supporting production data environments and troubleshooting issues
  • Strong communication and documentation skills

Preferred Qualifications

  • Experience with Alteryx for ETL/ELT development
  • Experience with advanced data modeling and data warehouse architecture
  • Familiarity with Unix scripting and automation
  • Experience with CI/CD and DevOps tools
  • Experience with Generative AI tools and developer productivity platforms such as GitHub Copilot

Core Skills & Attributes

  • Strong analytical and data problem-solving skills
  • Ability to design scalable and reliable data pipelines
  • Strong attention to detail and data quality
  • Ability to troubleshoot complex production issues
  • Effective collaboration across technical and business teams
  • Ability to manage multiple priorities in a fast-paced environment
  • Self-motivated with strong ownership and accountability
  • Strong written and verbal communication skills

Benefits & conditions

  • Competitive salary

Apply for this position