Sr. Data Analyst with ETL and Tableau

Primary 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.

FOUNDATION FOR SUCCESS (Basic Qualifications):

• 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.
• Must be able to obtain and maintain a Public Trust. Contract requirement. The ability to obtain/maintain a Public Trust.

FACTORS TO HELP YOU SHINE (Required Skills):

These skills will help you succeed in this position:

• Overall 10+ years' experience in Data Analysis, ETL Development and Business Intelligence.
• 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.
• 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, and PostgreSQL.
• 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.
• 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. Active Public Trust or higher

Education:

• Bachelor's degree with 7+ years of experience
• Must be able to obtain and maintain a Public Trust. Contract requirement