Database Analyst Job Description
Database Analyst Duties & Responsibilities
To write an effective database analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included database analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Database Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Analyst
List any licenses or certifications required by the position: MCSA, MCSE, SQL, OCP, ITIL, II, IAT, MCTS, SAS, DBA
Education for Database Analyst
Typically a job would require a certain level of education.
Employers hiring for the database analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Technical, Business, Engineering, Information Systems, Management, Mathematics, Administration, Information Technology
Skills for Database Analyst
Desired skills for database analyst include:
Desired experience for database analyst includes:
Database Analyst Examples
Database Analyst Job Description
- Experience working with email service providers
- Hands on experience with large customer data sets
- Experience working with a global center of excellence is a plus
- Strong ability to analyze and interpret numbers, and explain information to stakeholders
- Gain thorough understanding of data requirements and business/client needs
- Proactively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues
- Manage escalated issues as appropriate
- Champion consistency across databases by identifying data inconsistencies and working with environment owner(s) to enable data completeness
- Designing, developing, modifying, and troubleshooting software programs to include desktop applications and computer based Information Technology IT systems
- Designing, development and modifications for databases and programs
- Excellent computer skills, Excel & PowerPoint a must
- Multilingual is a must
- BI desired - Beginner/Intermediate skills/experience in at least one BI tool like Business Objects, OBIEE, Tableau
- Information Technology related degree or equivalent hands on development work experience (5+years)
- Expertise in understanding various tool, writing and maintaining codes to manage the jobs, testing and troubleshooting codes in case of any errors reported or during change management
- Experience in Coding or in Testing Various platforms
Database Analyst Job Description
- Knowledge of Oracle, OLAP, and SSAS design a plus
- Strong inter-personal and team member skills
- Ability to work with equal level of effectiveness at all management levels in company
- Develop and maintain databases and modeling activities for all business efforts
- Collaborate with end-users to create apps and reports to sit on top of the data warehouse, including but not limited to an enterprise-wide suite of daily reports, user-defined report “favorites” based on specific job functions, a browser-based reporting portal
- Configure systems and databases according to standards and best industry practice
- Produce technical documentation necessary for the administration of database environments, while maintaining a high standard regarding quality of service
- Support the SOW process
- Maintains database for various projects
- Integrates data from various sources
- Familiarity with different coding structures and adaptability to new coding requirements
- Must have proven ability to communicate technical concepts to clients having varying levels of technical expertise the ability to work effectively with data managers, subject matter experts and both internal and external high-profile clients
- Bachelor’s degree in quantitative fields, Statistics, Math, Operations Research and Economic
- Java programming and Long-term care or Home Health care industry experience an asset
- Knowledge of object-oriented database concepts is essential
- Intuition, experience and desire to work with web applications or computer software independently
Database Analyst Job Description
- Supervise the activities of the data entry team
- Provide the initial QC of data entered into CITP databases by the data entry team
- Train and mentor Db Entry Analysts and establish data entry procedures for new data types
- Collect and manage field test data
- Work directly with Cat engineering teams to identify exact field test requirements
- Manage the implementation of field test requests from the engineering team on test engines in the field
- Modify and upgrade the SuperComm 2 diagnostic database, on the average of four times per month based on field test data and test requests
- The Analyst will validate the accuracy of ECM diagnostics through data quality checks on the average of four per month
- The Analyst will facilitate resolution of any issues with data received from field test sites and correct issues within the database programming structure
- Analyst will consult with engineers to identify their data collection requirements for the data base
- Desire to work in a team setting and engage in collaborative activities with staff and faculty
- Attention to detail, ability to work independently with a team
- Knowledge and understanding of Business Objects (Super User)
- A Bachelor's Degree, preferably in computer science or a related field is required
- Additional education, particularly in database management, Business Objects, programming or IT infrastructure, is beneficial
- Maintain current industry knowledge of relevant concepts
Database Analyst Job Description
- Develop daily / weekly / monthly reports using SAS, SQL, Tableau, Excel, and other tools
- Help maintain architecture and process flow diagrams for data systems
- 3-5 years of on-the-job DBA experience
- Moderate exposure to “big data” or data warehouse technology highly desired
- Foundational understanding of data warehouse technologies and data partitioning
- Collaborate with subject matter experts to analyze data requirements, determine gaps and develop process to source data where needed
- Troubleshoot and optimize system and reporting performance
- Partner with Product Management to assist with financial modeling and forecasting
- Microsoft SharePoint a plus
- Effectively and simply presents results and translate statistical and business terminology to senior members of management
- DoD Secret Clearance (We can process a successful candidate for the clearance and candidates may start with an interim secret clearance.)
- Bachelor degree in Information Technology or completion of a college program in computer science or equivalent experience
- Minimum of 7 years’ general experience in Information Technology
- Expert logical and objective analytical skills and ability to use sound judgement when evaluating potential solutions, while respecting fixed deadlines and adjusting to priority changes and corporate objectives
- Demonstrated experience in the technical aspect of projects (performance, security, robustness, ) and in the resolution of complex problems with various stakeholders
- Great ability to work in a team or autonomously
Database Analyst Job Description
- Demonstrates proficiency in SQL to perform data loads, data extracts and conversions
- Ability to develop SQL code independently for intermediate to moderately complex procedures in both Oracle and MSSQL Server environments
- Assists in the development, maintenance, and support of the OEAS Knowledgebase data warehouse and corresponding BI applications, including data design and integration, database architecture/metadata and repository creation
- Evaluate and recommends available database management system (DBMS) products
- Develops methodology for the ongoing assessment of database performance
- Works collaboratively with users and team members to gather requirements
- Identifies and troubleshoots errors and/or problems with applications
- Monitors database performance, identifies potential areas for improvement, makes modifications as appropriate
- Support Asset Management processes by assisting with tagging, shipping, data entry, audit, as needed
- Analyzes data requirements, application and processing architectures
- Ability to multi-task, work efficiently under pressure and in crisis situations
- Ability to influence and sell ideas to his/her colleagues, supervisor and management
- Knowledge of IT processes (ITIL) and quality management processes is a plus
- Experience with installing applications on Windows Server
- Must be able to react quickly in a fast-paced retail environment
- Ability and willingness to continue to expand knowledge and experience