Sr. ETL Developer

Job Description Centurion is hiring a Sr. ETL Developer for a long term federal government contract. This is onsite in Woodlawn, MD 5 days per week.

Open to Green card holders or US Citizens only. 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 Required Skills: 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. ** Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week.

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.

Desired Skills: 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. Education: Bachelor's degree with 7+ years of experience Must be able to obtain and maintain a Public Trust. Contract requirement.