Centurion is looking for a Senior Data Analyst for an onsite position in Woodlawn, MD.
Key Required Skills:
ETL, PL/SQL, Tableau, Data Modeling, Data Analytics.
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
Skills Requirements:
- 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.
- 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.
Education:
- Bachelor's degree with 7+ years of experience
- Must be able to obtain and maintain a Public Trust. Contract requirement.