Analyst, Database Job Description
Analyst, database
provides database object and statement coding guidance, review and optimization of database objects and statements, and related application programming interfaces.
Analyst, Database Duties & Responsibilities
To write an effective analyst, database job description, begin by listing detailed duties, responsibilities and expectations. We have included analyst, database job description templates that you can modify and use.
Sample responsibilities for this position include:
Assist in the design, testing of data related to the implementation of new and existing Compliance systems and MIS reporting
Design and develop Oracle database objects including tables, views, indexes
Follow-up of the database supplier on delivery of the car specifications of the new cars and options
Run the updates in the lease-operating system and activate the cars in the database
Provide oversight to and execute the Compliance Data Governance Policy
Establish data quality measurements and may review data quality to ensure reports and analyses are meaningful and accurate
Maintain business definitions and Compliance usage for all data used for Compliance
Manage and support tool and application development for General Compliance Leadership and Teamwork
Support team relative to tactical and strategic planning efforts within a dynamic regulatory environment
Manage tasks team members for assigned projects
Analyst, Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Analyst, Database
List any licenses or certifications required by the position: MCSA, MCSE, SQL, OCP, ITIL, II, IAT, MCTS, SAS, DBA
Education for Analyst, Database
Typically a job would require a certain level of education.
Employers hiring for the analyst, database 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 Analyst, Database
Desired skills for analyst, database include:
Administrators
ETL standard practices
Routinely making critical decisions and exercising sound judgment
Staff
Students - Ability to operate with a high level of independence
Tableau
Coding
Design
.NET
At least one object-oriented programming language
Desired experience for analyst, database includes:
Knowledge of relational database technology (Oracle, SQL Server)
SAS CI Studio (highly preferred), Microsoft Office (including Excel and Access), SPSS, Microsoft SQL Language/Server, Relational Database, Adobe Dream Weaver, Adobe Illustrator, HTML, Omniture
4 years of business analysis experience with a focus on secure database application systems * Experience in Oracle or SQL Server database systems preferred * Experience with Sarbanes-Oxley controls and governance * Well organized, detail oriented, ability to multi-task * Excellent time-management, planning and prioritization * Demonstrates excellent communication, organizational and follow up skills
C#, PowerShell
SQL 2005/2008 R2/SQL2012
5+ years of expertise in implementing, administering, and troubleshooting applications and infrastructure
Analyst, Database Examples
1
Analyst, Database Job Description
Job Description Example
Our growing company is looking for an analyst, database. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for analyst, database
- Provide data administration, analysis and support for the Strategic Accounts (SA) department
- Interact directly with management level personnel in other areas of the bank to communicate data insights complete assigned projects
- Develop and deploy all email campaigns by being the audience selection expert and utilize customer selection tool to deliver targeted customer lists to the email service provider
- Lead post-campaign analyses, database mining, ad hoc analysis, and test and learn initiatives to drive and optimize customer loyalty, acquisition, retention, personalization and promotional strategies
- Speak the language of customer data and customer relationship management/marketing and be able to bring both worlds together in order to deliver leading edge customer programs
- Lead the day to day execution of multichannel customer journey initiatives through being a relentless advocate for customer segmentation
- Partner with Global CRM team to ensure consistent strategy and execution
- Drive insights around performance trends and actionable customer insights based on clear understanding of business objectives- utilized to recommend programmatic marketing streams
- Provide customer level analysis through database profiling to help inform strategy and execution efficiency
- Minimum 3 years experience in Customer Relationship Management, direct marketing, database marketing, analytics
Qualifications for analyst, database
- SQL required - Beginner/Intermediate skills/experience developing queries and stored procedures in at least one RDBMS platforms like Oracle, SQL Server
- MS Excel – Advanced skills required
- Must know AIX and specifics of DB2 operations on AIX
- 2+ years of experience with SQL or Access highly sought
- Exposure or understanding of Big data technologies like Cassandra, NoSQL, Hadoop
- Experience with data-driven marketing strategies a must
2
Analyst, Database Job Description
Job Description Example
Our company is growing rapidly and is hiring for an analyst, database. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for analyst, database
- Adapting programs to new requirements to include web hosting of metrics
- Can manipulate Access and Excel using Visual Basic, not the more advanced programming languages
- Compiling databases or programs
- Program training of operators
- Document data definitions and data requirements and review those requirements with the OBIEE team business users
- Coordinate data and tasks between EHS Databases and Engine Reliability/EAM or other programs
- Trains users on database and communicates databases’ capabilities
- Applying knowledge of commonly used concepts, practices and procedures of air regulations to make the decision as to what is needed to keep the database current and operating efficiently
- Have a basic understanding of other requirements, including SPCC, OSHA, SARA, Waste Management, and soil and groundwater remediation to answer questions from either field employees or regulators
- Complete Incident Reports submitted by operations and manages Incident record database
Qualifications for analyst, database
- 1+ Year Experience in Supporting Systems with knowledge on SQL
- Education – Bachelor’s degree in computer science or equivalent education, training, or experience
- Working knowledge of relational databases and SQL programming
- Knowledge of the principles
- 2 years of experience working in or with real estate Multiple Listing Service companies or their data providers
- Must have Expert-level T-SQL and stored procedure skills
3
Analyst, Database Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of analyst, database. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for analyst, database
- Writes the codebook for the database
- Designs database to fit the departmental needs
- Creates and analyzes reports
- Monitors and takes appropriate actions to maintain integrity of the databases, including security and privacy issues
- Lead training on data analysis, development best-practices, data standards, data policies
- Provide 3rd level support for assigned problems
- Play a role in resolving issues that require a cross-business domain solution
- Complete FRA-mandated reporting and data interface
- Identify, understand, and articulate solutions for customer issues by means of ArcGIS knowledge including ArcGIS Desktop, geodatabase, and related technologies
- Performs all the duties of the Db Entry Analyst as necessary
Qualifications for analyst, database
- Being able to identify, fix and elevating issues as necessary during troubleshooting
- Strong ability in monitoring project plans to meet expected timelines
- Basic skills with workflow analysis or process mapping are a plus, but not required
- Advanced Microsoft SQL, knowledge of Javascript
- Familiar with data warehouses and relational database systems
- Campaign management systems (Adobe Campaign/Neolane, Unica or Eloqua) a plus
4
Analyst, Database Job Description
Job Description Example
Our growing company is hiring for an analyst, database. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for analyst, database
- Maintains database dictionaries, monitors overall database standards and procedure, and integrates systems through database design
- Automate and improve data reporting, quality, and governance while providing expertise in effective daily, weekly and monthly reporting, dashboard and metric design
- Analyst will implement data collection activities based upon requests from engineers
- Analyst will create and present monthly progress reports for completed items and status of WIP (work in progress) to Caterpillar management
- Ensure existing and new processes are properly documented including EUC
- Support 13x Access Databases ensuring the code/data integrity are maintained to ensure the solutions are performing as required
- Support various Excel Spreadsheets and VBA Macros
- Support 31x Xceptor Data Hub processes to aid the automation process
- Support 4x SharePoint solutions
- Support with general Excel/Access issues with a focus on helping users gain the best use of Excel or improve the user’s knowledge of Excel
Qualifications for analyst, database
- Must meet DoD 8570.01-M Information Assurance Technical (IAT) Level II requirements prior to start of work, including IA Baseline and CE/OS Certifications
- Associates degree (Bachelor’s degree preferred) in computer science, environmental science, or related training with databases
- 2-5 years working with databases and environmental area
- Excellent working knowledge of database applications
- Ability to work at a computer station
- Dealing with multiple data sources from internal or external databases
5
Analyst, Database Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of analyst, database. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for analyst, database
- Develops solutions to improve the effectiveness of the processes and procedures used by DBA staff
- Monitors and measures application performance
- Develop and deploy reports and extraction, transformation, and loading process packages to support applications data integration and operation needs
- Administer, maintain, develop and implement policies and procedure for ensuring the security and integrity of the database
- Perform database backup and monitor scheduled database jobs at daily basis
- Apply database service patch to ensure database compliance with regulation and polices
- Monitor, administer, and implement performance on database systems database performance optimization, develop/change database indices, redesign database structure and reload data into a database
- Coordinate system backup team to ensure database is fully backup and stored at designated environment
- Work with application developers to implement business intelligence reports to meet organization needs
- Administer and use of current and emerging database tools, strategies and technologies
Qualifications for analyst, database
- Knowledge of SQL Server, SSRS, SSAS, ODS, EDW and/or other data collection and presentment applications
- Proven experience (3+ years) in SQL programming
- SQL Skills(Creating queries, scripts, tables, views )
- Minimum of 5 years as Database Analyst and Database Administrator of either SAP Sybase or Microsoft SQL Server Databases
- Minimum 2 years hands-on working knowledge with Microsoft SQL Server Integration Services
- Strong written and oral communication skills, including technical writing, in both French and English