Database Analyst

Clearance Level
None
Category
Database Analysis/Design
Location
Washington, District of Columbia

REQ#: RQ69430

Travel Required: None
Requisition Type: Regular

Database Analyst Job Description:

GDIT is looking for a Database Developer who thrives in a dynamic work environment. This role involves working across the entire BI lifecycle, from source data analysis, Extract Transform Load (ETL) development, through to Analysis and Reporting implementation. This role will design, develop, and implement data structures that support solutions which empower the business with timely, actionable information. The Database Developer needs to be a self-starter and thorough in their work.

Essential Duties

Design, develop, deploy and tune SQL Server an Oracle based ETL processes as required. Implement appropriate processes and procedures for monitoring Perform sub-system design and specification development, application security, testing and debugging. Provide support for ad-hoc data requests Participates in team and client interactions, possibly with more senior team members, to develop BI solutions suited to business needs

Competencies

Writing code and unit tests, developing automation, and conducting peer code reviews. Ensuring security goals are maintained. Analytical Thinking and Problem-Solving Skills – ability to understand complex situations, develop and implement a logical approach to a problem solution. Attention to Detail – ability to ensure the work and information are complete and accurate, by preparing carefully for meetings and presentations, and following up with others to ensure that agreements and commitments have been fulfilled. Communication –ability to understand requirements documentation, functional specifications, high level design documentation and system documentation. Able to successfully listen, understand and verbally communicate with technical and non-technical team members. Flexibility - able to change priorities quickly and have a capacity to handle multiple tasks simultaneously. Application of software engineering concepts and best practices to design solutions that meet operational requirements, such as scalability, maintainability, extensibility, and flexibility. Ability to self-manage projects, due dates and communicate status. Impact Awareness – ability to anticipate the likely effect of actions and events on others and to tailor one’s own behavior to achieve a desired effect on others. Influential Skill – ability to gain others’ support for ideas and solutions, through logical argument. Interpersonal Awareness - ability to notice, interpret, and anticipate others’ concerns and feelings. Productivity - motivated self-starter and quick learner. Ability to work under deadlines with heavy workloads as well as flexibility to work outside of normal business hours to meet testing needs. Results Oriented – ability to keep the desired end-result of one’s own work clearly in mind, by setting goals and focusing on them tenaciously until they are achieved. Technical Acumen - strong understanding of software development concepts, procedures, and technologies utilizing Agile Methodology.

Technical Skills

Proficiency with multiple ETL tools (including Pentaho) and databases management systems (SQL Server mandatory – Oracle and MySQL a plus). Experience with Database tuning in an OLAP Environment Experience with industry development standards and their implementation Proficiency in system analysis and design Analysis and verification technical requirements for completeness, consistency, feasibility, and testability. Identification and Resolution of technical issues through unit testing, debugging & investigation Design and develop appropriate processes and procedures to ensure proactive data quality monitoring Version Control including branching and merging (Visual Studio DevOps preferred) Experience with Reporting tools (Tableau, Pentaho etc. preferred)

Experience, Education

At least 4 years of professional database development (SQL Server, Oracle, Snowflake) and ETL experience in an OLAP environment Bachelor’s or master’s degree in computer science or equivalent preferred Experience with Agile (SCRUM/Kanban) software development methodologies . Automated testing and deployment implementation a plus. Collaboration with the Business Analysts in requirements gathering, prototyping and validation.

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.