Vacancy expired!
Data AnalystWashington,
DC20544Posted: 11/23/20202020-11-23
2020-12-23Employment Type:
ContractIndustry: ITJob Number: 233623Job DescriptionData Analyst Remote then Onsite in DC 2+ year Contract Database Analyst Job Description:Database Analyst 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 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 DutiesDesign, 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
CompetenciesWriting 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 SkillsProficiency 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, EducationAt 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.
Analytical and dimensional modeling experience
