Unify Technologies - ETL Developer (Ability to obtain Public Trust)

Developer is needed in Catonsville, United States.

Client: Unify Technologies

Location: Catonsville, MD

Contract: Contract

Job Description

We are seeking a Senior ETL Developer with strong expertise in data warehousing, ETL pipeline development, and business intelligence reporting. The ideal candidate will design and develop scalable ETL solutions, manage large-scale data integrations, and build Tableau dashboards that support enterprise analytics and reporting initiatives. This role requires hands-on experience with Linux environments, ETL tools, large data warehouses, and complex SQL development.

Key Responsibilities

ETL Development & Data Integration

• Design and develop ETL processes supporting enterprise MI/BI initiatives.
• Build scalable ETL pipelines and develop automation scripts using Bash and Python.
• Integrate and load data from multiple source systems into Greenplum MPP databases.
• Implement data distribution, partitioning, and compression strategies.
• Design, develop, test, and optimize ETL processes for large-scale data processing.
• Develop and maintain migration processes across development, test, and production environments.

Data Analysis & SQL Development

• Perform source-to-target mapping and data analysis across multiple data sources.
• Develop and maintain complex SQL queries in enterprise data warehouse environments.
• Work with multiple database platforms including DB2, Oracle, Greenplum, PostgreSQL, SQL Server, and Flat Files.

Business Intelligence & Visualization

• Design and develop Tableau dashboards and visualizations for enterprise reporting.
• Connect Tableau to enterprise data sources and warehouses.
• Develop calculated fields, parameters, scorecards, and interactive dashboards.
• Publish and manage workbooks on Tableau Server.

Collaboration & Documentation

• Translate business requirements into technical specifications.
• Collaborate with Business Analysts, Data Architects, ETL Architects, and Enterprise Architects.
• Maintain technical documentation and knowledge transfer materials.
• Participate in design reviews, architecture discussions, and troubleshooting sessions.

DevOps & Version Control

• Manage source code using Bitbucket / Git.
• Deploy ETL components following SSA change management standards.
• Ensure compliance with security, privacy, and enterprise data governance policies.

Team Support

• Mentor junior developers on ETL best practices and performance optimization.
• Promote reusable ETL components to reduce technical debt.

Requirements

Minimum Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 10+ years of ETL development experience (additional experience may substitute for degree).

Required Technical Skills
Operating Systems

• Linux / UNIX administration
• Bash shell scripting

ETL Tools

• Informatica
• Ab Initio
• Syncsort / Precisely

Databases

• Strong SQL development experience
• Experience working with:
• DB2
• Oracle
• PostgreSQL
• Greenplum
• SQL Server
• Flat files

Programming & Scripting

• Python scripting for ETL automation
• PL/pgSQL (PostgreSQL / Greenplum)
• PL/SQL (Oracle)

Data Engineering Concepts

• SQL optimization
• Data granularity
• Cardinality
• Normalized vs denormalized models
• Data warehouse architecture

Data Transfer

• FTP / SFTP integration

Visualization

• Tableau dashboard development
• Tableau Server publishing

Other Requirements

• Excellent analytical and troubleshooting skills
• Strong communication and documentation abilities
• Ability to obtain and maintain Public Trust Clearance

Preferred Qualifications

• Active Public Trust clearance or higher
• Experience supporting Federal Government clients (SSA preferred)
• Strong database architecture knowledge
• Experience with Agile / Scrum development methodologies
• Familiarity with DevSecOps practices
• Experience using Jira and Confluence
• Knowledge of FISMA compliance and ATO framework

Certifications (Preferred)

• Tableau Desktop Specialist
• Tableau Certified Data Analyst
• Informatica AXON Certification
• Ab Initio Certification

Job Details

Job Type: Contract

Pay: $60.00 - $65.00 per hour

Expected hours: 40 per week

Work Location: In person