Talent.com
Sr. Data Analyst with ETL and Tableau

Sr. Data Analyst with ETL and Tableau

Omm It SolutionsWindsor Mill, Maryland, United States
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Please Note :

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

Position Description :

  • 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
  • Key Required Skills :

    ETL, PL / SQL, Tableau, Data Modeling, Data Analytics.

    Requirements

    Basic Qualifications

  • 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.
  • 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.
  • serp_jobs.job_alerts.create_a_job

    Sr Data Analyst • Windsor Mill, Maryland, United States