ETL Data Analyst

ETL Data Analyst

Job Description :

Leidos is in search of a Business Analyst to join our program team supporting the Federal Administration for Children & Families (ACF) Office of Child Support Services (OCSS) located in Washington, DC. You will play a valuable part in supporting and executing a wide range of projects assisting the OCSS team to provide top shelf products to our customers and their customers . The successful candidate will perform functional and business requirements analysis and IT applications analysis, in addition to IT applications development as assigned.

Primary Responsibilities :

Oversee daily operations and ensure efficiency of ETL applications.

Respond to and resolve operational issues and incidents promptly of ETL applications.

Recognize, diagnose, research, and resolve system and design concerns of ETL applications.

Document root cause analysis and track incidents to identify recurring problems.

Responsible for development and providing development lifecycle support for any code changes or enhancements.

Ensure appropriate Change Management processes / procedures and documentation are followed.cit

Interface with external partners and assist them with testing and resolution of production issues.

Help with system validation once the software has been developed.

Support System testing for any online application changes.

Work closely with the Project Manager, technical architect, and the other development staff.

Basic Qualifications :

Bachelor's degree from an accredited college in a related discipline, or equivalent experience / combined education, with 8 years of professional experience, or 6 years of professional experience with a related Master's degree.

Experience working in the software development lifecycle, with strong experience on ETL based development.

Working experience with development using Amazon Web Services (AWS) and primarily on AWS Glue studio.

Experience working with programming language PySpark / Python

Experience working with relational database like PostgreSQL

Experience working in a fast-paced development environment with drive to completion.

Experience with using version control systems (CodeCommit, CodeBuild, CodePipeline preferred)

Experience with using issue / problem tracking systems (Jira preferred)

Requirements analysis and application analysis and design skills.

Working knowledge of distributed application environments.

Familiarity with standard lifecycle processes and tools and working within a team environment.

Ability to multi-task and work in a dynamic, fast-paced environment.

Preferred Qualifications :

• Knowledge or experience with Software Engineering (IEEE) Capability Maturity Model (CMM) standards.
• Knowledge or experience with Full Development Lifecycle (FDLC) methodologies.
• Familiarity with SQL tools and knowledge of object-oriented programming analysis methods.
• Experience with, or knowledge of, data modeling and modeling tools.
• Experience with building customer relationships to prioritize and analyze system issues.