Sr. ETL Developer

About the position

Design, develop, deploy and support Tableau dashboards. Participating in Requirements and Design discussions with project stakeholders; Develop and document business requirements, impact assessments, process documentation and other related materials; Translate business requirements into ETL and report specifications. Design, develop and implement interactive analytic reports and dashboards. Attend team meetings with team members to understand and refine business features. Attend regular customer meetings and provide status on assigned tasks. Analyze and troubleshoot the existing data models, PL/SQL and Linux scripts, and code for opportunities to optimize performance and migrate into the Enterprise Data Warehouse.

Responsibilities

• Design, develop, deploy and support Tableau dashboards.
• Participating in Requirements and Design discussions with project stakeholders
• Develop and document business requirements, impact assessments, process documentation and other related materials
• Translate business requirements into ETL and report specifications.
• Design, develop and implement interactive analytic reports and dashboards.
• Attend team meetings with team members to understand and refine business features.
• Attend regular customer meetings and provide status on assigned tasks.
• Analyze and troubleshoot the existing data models, PL/SQL and Linux scripts, and code for opportunities to optimize performance and migrate into the Enterprise Data Warehouse.

Requirements

• Bachelor's degree with 7+ years of experience
• Bachelor's degree in computer science, Mathematics, Engineering, or a related field
• 10+ years of experience as a Senior Data Analyst/ETL Developer or BI Developer.
• 10+ years of experience with data mapping and analysis for supporting ETL efforts for Business Intelligence (BI) projects.
• 8+ years of experience on an Agile development team, preferable Scaled Agile Framework (SAFe)
• Must be able to obtain and maintain a Public Trust. Contract requirement.
• Overall 10+ years' experience in Data Analysis, ETL Development and Business Intelligence.
• Experience in supporting ETL efforts for Business Intelligence (BI) projects.
• Strong experience participating in Requirements and Design discussions with project stakeholders; Develop and document business requirements and translate business requirements into ETL and report specifications.
• Strong understanding of data recovery and job rerun needs in an ETL environment.
• Proficiency writing scripts using Oracle PL/SQL
• Hands-on experience with data warehouse Business Intelligence (BI) / Management Information (MI) reporting environment. Knowledge in both client-server and mainframe-based systems and the connectivity/infrastructure requirements to support, design, develop and implement such systems.
• Comprehensive knowledge of Scrum and/or Kanban Agile development process and ceremonies (scrums, backlog grooming, retrospectives, demonstrations).
• Knowledge of data mapping/analysis.
• Python experience for data extraction and manipulation.
• Strong understanding of data recovery and job rerun needs in an ETL environment.
• Strong experience with SQL, mapping, and integration of databases.
• Proficiency writing scripts using Oracle PL/SQL, and PostgreSQL.

Nice-to-haves

• Experience designing and developing Tableau visualization solutions.
• Experience developing interactive dashboards, charts, pivots, and reports in Tableau Desktop 2021.1 or higher using advanced calculations, parameters, and data blending.
• Familiarity extracting data from multiple data sources such as DB2, Oracle, and flat files.
• Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
• Knowledge of when to use plain SQL vs. PL/SQL.
• Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.
• Hands on experience with data warehouse Business Intelligence (BI) / Management Information (MI) reporting environment. Knowledge in both client-server and mainframe-based systems and the connectivity/infrastructure requirements to support, design, develop and implement such systems.
• Experience working with enterprise data warehouses.