SQL Analyst Job Description
SQL Analyst Duties & Responsibilities
To write an effective SQL analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
SQL Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Analyst
List any licenses or certifications required by the position: SQL, ITIL, II, IAT, SAS, MCSA, BABOK, US, CHFP, CPA
Education for SQL Analyst
Typically a job would require a certain level of education.
Employers hiring for the SQL 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, Business, Education, Engineering, Technical, Mathematics, Statistics, Finance, Information Technology, Information Systems
Skills for SQL Analyst
Desired skills for SQL analyst include:
Desired experience for SQL analyst includes:
SQL Analyst Examples
SQL Analyst Job Description
- Adapt to new software aids and programming techniques as they are required or adapted by the Information Technology department
- Responsible for working with all levels of the business development team to establish, promote, and enforce architectural guidelines assist in the implementation and problem resolution of existing applications and requests
- Mentor less experienced team members, both formally and informally
- Resolve conflicts/issues and escalates others as appropriate
- Provide secondary on-call support of internal and vendor applications of particularly more complex situations
- Support both internal and vendor systems and applications
- Evaluates business systems to review the alignment with user needs
- Real-world experience of working in commercial software development projects in one of more technologies
- Knowledge of operating systems like Windows NT/2000 and Sun Solaris, is a plus
- Create and maintain dashboard reporting using (Tableau or other web-based platform)
- Experience with month-end close, budgeting, forecasting and analytical projects
- Detail-oriented with fair knowledge of accounting procedures and financial reporting practices
- Demonstrate experience in Database Administration in SQL Server ( 2005 and 2008 )
- Programming (XML, JavaScript, or ETL frameworks) will be additional advantage
- Knowledge on SAP application
- Experience at working both independently and in a team-orientated, collaborative environment
SQL Analyst Job Description
- Implement defined procedures to plan, design, implement, execute, evaluate and report results of testing under minimal supervision for projects of all scopes including pharmacy, medical and eligibility data
- Implement defined procedures designed to avoid the creation of defects (e.g., requirements review) under minimal supervision for projects of all scopes
- Obtain, maintain and document (application) system domain knowledge necessary to perform defined procedures efficiently and effectively
- Work with the application developers to quickly capture the major business functions and technology underpinnings to be able to design and implement tests of system functionality that exercise all critical inter-system integration points
- Coordinate efforts with other members responsible for building and maintaining the application production environment
- Work with Business Partners to provide support and testing knowledge at project level milestones
- Resolve batch job issues and failures in an effective and timely manner
- Write database queries to aggregate and structure data, and build online dashboards
- Determine and implement best practices to gather, model, manipulate and present data while gathering business requirements, conducting analyses and performing data cleansing
- Create and automate reports by established deadlines and on an ad-hoc basis
- Microsoft BI Stack (SSIS, SSRS, SSAS)
- Previous experience with SQL data mining (managing large quantities of data, joining multiple tables)
- Writing & executing Test Cases from Technical requirements
- Identify and follow up on bugs/issues that arise from Test Cases
- Querying the Database (SQL) to verify and pull data
- Opportunity to be trained in Automation
SQL Analyst Job Description
- Download the contents of a non-English clinical trial website into a structured file for further loading into a database
- Query insurance claims and electronic health records databases to profile patients of a certain disease state, ensuring that the technical specifications of the query output is aligned with the business need
- Primary application support for BAE’s (vendor) Enterprise Investigation Management (EIM application) used for case management workflows supporting BSA/AML Operations and Bank Operations functions
- Data analysis, modeling, technical design, code development, validation for data supporting BSA/AML applications and solutions
- Troubleshoot and tuning in order to isolate and identify problems and to optimize system performance
- Provide Ad Hoc data reporting and data pulls for Analytics teams
- Manage routine data exports for clients, partners and SMEs
- Create and manage scheduled tasks and data processing scripts
- Develop enhanced logging and monitoring for all scripts, jobs and processes
- Work closely and diligently with the product development team to resolve bugs and defects relating to our data
- City center based
- Good accounting & tax systems knowledge
- Three plus years of experience in support of operational environments that execute on a daily basis (i.e., daily refresh at minimum)
- Bachelor's degree in Actuarial Science, Math, Economics or similar field required
- 1 to 3 years academic or business experience preferably in the healthcare industry and/ or a technical role
- Actuarial Exam Track (having passed one (1) or more actuarial exams) preferred, but not a must
SQL Analyst Job Description
- Business analyst function, involving working closely with business stakeholders, and the Treasury IT department, including writing/reviewing Business Requirements documentation, reviewing Functional Specifications, writing UAT plans, performing and/or coordinating with end users the User Acceptance Testing, training end users on new system functionality
- Understand end-to-end data flow and functioning logic of our proprietary Liquidity Risk Management tool to help answer functional queries on the critical Liquidity Risk system by analyzing, diagnosing, and then either solving or referring the problem
- Define Business Requirements and document them, including for data sourcing and reporting, and produce functional specifications accordingly for use by technical team
- Perform data analysis to support validation of business requirements and develop prototype of functional solutions
- Create and execute test cases for new systems and develop required test data
- Support test execution and work with development team for resolution of technical issues identified during test phases prior to deployment of newly developed technical specifications
- Provide functional support for the use of new and existing functionality and tools deployed to production environment
- Define customer requirements
- Report creation and visualization
- Support existing Business Intelligence applications
- Knowledge of Citrix for published applications on servers
- Functional knowledge on Trimble Prolog suite of software (Prolog, Prolog Converge and Prolog Manager)
- Excellent interpersonal skills, excellent communication skills, verbal and written
- A minimum of four years technical and systems analysis experience in a large-scale system development environment
- System Project life cycle experience is a plus
- Ability to work as part of a team as well being individually motivated
SQL Analyst Job Description
- Ensure that newly implemented system features or enhancements meet user needs as documented in specifications
- Participate in the investigation and resolution of production problems
- Post-Secondary education and/or training in Computer Science
- Exposure to Java and JavaScript
- Familiarity with multi-platform environments such as Windows, UNIX, and RDMS
- Highly proficient with Microsoft Office applications - particularly Excel
- Working knowledge of mutual fund processes and concepts including fee based systems
- Ability to design and modify applications to user specifications
- Excellent multi-tasking skills and ability to work effectively with project deadlines
- Maintain/support the inbound and outbound feeds script
- Successful within multi-tasking environment
- Ability to work with external clients
- PHP (coding – Resource Management Tool is written in PHP)
- MySQL DB (administration and coding – Resource Management Tool utilizes a local mySQL database)
- Windows Server Management (IIS Permissions/Web Site Management/Maintenance, Scheduled Tasks Management, Environment Troubleshooting)
- Technical Requirements Documentation (Detailed Technical Design/Translation of Business Requirements to Technical Implementation