Senior Data Engineer - AWS Data Platform (Redshift, Glue, and Airflow)
Backend Developer
Senior
3d Design Tools
Amazon Web Services
Apache Airflow
AWS
Aws Glue
Azure Data Factory
Cloud
Cloud Computing
Cloud Data Warehouse
Cloud Native
Cloud Operations
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Factory Azure
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
Engineer
ETL
Google Cloud
Informatica
IT Services
Microsoft Azure
Redshift
Rendering Engines
Reporting and Analytics
Software Engineering
SQL
Job Description
Versant Media is hiring a Senior Data Engineer to design and deliver data pipelines and warehousing capabilities for analytics use cases.
Responsibilities
- Design and implement data warehouse and data mart architectures to support presentation layers for elastic cubes, reporting, and analytics
- Perform hands-on ETL/ELT development and share responsibility for monitoring data warehouse and data mart workloads
- Develop and support data pipelines using Airflow and AWS Glue, with additional pipeline work in Azure Data Factory, Python, and Golang
- Build and maintain schemas and structures that support analytical requirements
- Deliver hands-on database work including T-SQL or PL/SQL development, query tuning, table development, stored procedures, and functions
- Create and manage indexes to improve performance for operational workloads
- Troubleshoot and resolve production data issues
- Coordinate with business users and project managers to identify business problems and implement solutions
- Apply technical knowledge to propose improvements for existing systems and new requirements
- Work with other IT departments on systems communication processes
- Participate in meetings with multiple IT groups, including other business unit IT teams and technical operations (Server Group and infrastructure groups), to address issues and concerns
- Mentor other Data Engineers
- Identify software solutions needed for new projects
- Provide weekly reporting to management on project status and issues
- Support on-call production requirements
Requirements
- 7+ years of data warehousing / OLAP experience
- 7+ years of multidimensional database architecture and design experience
- 5+ years of SQL experience
- 3+ years of Python experience
- 2+ years of Redshift experience
- 2+ years of NoSQL experience
- Experience with team and vendor partner management
- Clear understanding of principles and techniques of web development
- Experience with AWS Glue and Airflow
- Experience with API
- Dimensional database architecture experience
- Formal systems life cycle methodology experience
Technologies
- tsql, psql
- Airflow, AWS Glue
- Azure Data factory
- Python, Golang
- Azure, AWS, GCP
- Redshift
Desired Qualifications
- Cloud Data Warehouse operations experience
- Tableau, SSRS, big data, and Realtime BI experience
- Experience with data streaming
Location and Work Mode
- Orlando, FL (remote)
- Fully remote: expected to contribute from a non-Versant worksite, most commonly an employee’s residence