Sr. Data Analyst with ETL and Tableau

• This is 100% On-Site Position.
  
• Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week.
  
  

• 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 in computer science, Mathematics, Engineering, or a related field
  
• Bachelor's degree with 7+ years of experience
  
• 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.
  

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