Own your opportunity to work alongside federal civilian agencies. Make an impact by providing services that help the government ensure the well being of U.S. citizens.
Job DescriptionGDIT is looking for a Database Analyst who thrives in a dynamic work environment. This role involves working across the entire Business Information (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 sets 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 and 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. Basic shell scripting in RedHat Linux. 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 and 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). Must be familiar working with enterprise level financial data. At least four (4) years of professional database development (SQL Server, Oracle, Snowflake) and ETL experience in an OLAP environment. Experience with Agile (SCRUM/Kanban) software development methodologies. Automated testing and deployment implementation a plus. Collaboration with Business Analysts in requirements gathering, prototyping and validation.
Experience, Education
A BA/BS degree in computer science or a related field and 10 years of experience, or a MA/MS degree in computer science or a related field and eight (8) years of experience.