- Featured in:
-
More Sql Data Analyst Resumes
Use these Sql Data Analyst samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Statistics Resume Samples
Sql Data Analyst Resume Samples
No results found
0-5 years of experience
Developed SSIS Packages to provide data integrity between production and test environments.
- Used Microsoft SQL Server 2005 an 2008 to develop procedures to maintain the company’s legal and contractual compliance.
- Provided project development for all internal pending requests.
- Created automate processes through stored procedures utilizing T-SQL to facilitate additional production capacity and not overburden the main data server
- Optimized stored procedures in to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements.
0-5 years of experience
- Reviewed data and classified the tables/measures functions by using multiple queries, views and procedures
- Designed database schema contains over 30 tables such as users, groups, threads and posts
- Established the connection between legacy system and Discuz forum software using MySQL and SQL Server
- Migrated data from legacy system to Discuz through SQL Server and completed 99% records mapping
- Resolved kinds of software or database related issues such as data loading and migration
0-5 years of experience
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules
- Created parameterized reports and adhoc reports using Report builder.
- Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
- Performed unit testing and path testing for application.
- Designed and implemented a user interface to access data using PowerBuilder.
- Created triggers for cascading update and delete operations to maintain data integrity.
- Worked with ADO.NET objects to connect to the databases.
0-5 years of experience
Created Risk Adjustment Processing System (RAPS) file from row claim data for Medicare and Medicaid programs and submitted to CMS. Downloaded a risk adjustment return file from CMS, and integrated to a database.
- Developed SQL program to create a customized RAPS file and a customized RAPS return integration for clients based on client request.
- Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
- Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
- Developed data loading programs that integrate RAPS file data for further financial impact analysis.
- Analyzed a financial impact of a RAPS file using a risk score of each HCC (ICD9), based on the CMS-HCC Model.
- Extensively investigated different data issues and communicated with clients to resolve the issues.
- Downloaded data from FTP site, integrate data to a database and extract data for analysis.
- Trained within and outside the team to give basic understanding of the CMS risk adjustment process.
- Established departmental procedures, metrics and work flow where none previously existed.
- Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.
0-5 years of experience
Created Risk Adjustment Processing System (RAPS) file from row claim data for Medicare and Medicaid programs and submitted to CMS. Downloaded a risk adjustment return file from CMS, and integrated to a database.
- Developed SQL program to create a customized RAPS file and a customized RAPS return integration for clients based on client request.
- Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
- Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
- Developed data loading programs that integrate RAPS file data for further financial impact analysis.
- Analyzed a financial impact of a RAPS file using a risk score of each HCC (ICD9), based on the CMS-HCC Model.
- Extensively investigated different data issues and communicated with clients to resolve the issues.
- Downloaded data from FTP site, integrate data to a database and extract data for analysis.
- Trained within and outside the team to give basic understanding of the CMS risk adjustment process.
- Established departmental procedures, metrics and work flow where none previously existed.
- Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.
0-5 years of experience
Sarbanes-Oxley-compliant contract consulting & data analysis for metal coating client firm.
- Diagnosed & customized EDI data & middleware, saving the client from large non-compliance fines.
- Troubleshot & enhanced ERP software & databases & maintained their interfaces.
- SQL, Inovis TrustedLink EDI, Movex (Lawson), Infor ERP XA, Infinium.
0-5 years of experience
- Used SSRS to create versatile reports and presentations for business groups and sales associates.
- Wrote and executed SQL queries using Query Analyzer to provide custom reports to marketing and sales
- Coordinated meetings to gather business requirements to improve usability of Onyx CRM and implemented changes to resolve pain points for these users.
- Carried out the importing of thousands of 3rd party sales leads each week into the Onyx database using DTX packages and performed processes to maintain data hygiene.
- Worked closely with the marketing group to gather requirements for custom reports and client lists to support advertising campaigns.
- Provided varied support of the Onyx CRM software to over 600+ internal users worldwide
- Operated as a liaison between the technical support group and development teams to increase awareness of customer issues and resolve problems outside of my group’s reach.
0-5 years of experience
Designed and developed specific databases for collection, tracking, and reporting of data using Visual Studio Management.
- Designed, coded, tested and debugged custom queries using Microsoft T-SQL and Crystal Reports per defined technical specifications.
- Managed the extraction, transformation, and population of data files and databases (MS SQL Server 2008, Excel, and Access)
- Worked directly with customers and team members to determine project scope and specifications. Provides research and analysis to support intelligence organizations.
0-5 years of experience
SQL querying to deep dive into the datasets to search for business insights
- Extensive experience in Relational and physical data modeling for creating logical and physical design of Database and ER Diagrams.
- Worked extensively in forward and reverse engineering processes.
- Fluent with TSQL or PL/SQL
- Good Knowledge of ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents.
- Trained new recruits in data compilation, strategic research, data extraction, integrated insights, and analyses
0-5 years of experience
[company name] is an IT consulting company providing program management, requirements gathering, and strategic planning services to companies who are driving big changes in our modern world; from defense and healthcare, to technology and financial services.
- Obtained and analyzed the informational business requirements from various clients.
- Created database tables with various constraints including primary key, foreign key, etc.
- Loaded data from flat data files into SQL Server database tables using bcp, bulk insert, and table import; Created ETL packages using SQL Server SSIS Designer to extract data from flat file and excel files
- Reformatted the data and inserted the reformatted data into staging table, performed data cleansing and data type conversions and then loaded into destination table
- Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL stored procedures, user defined functions (UDFs) for data analysis
- Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration
- Loaded flat and Excel files into Access database and developed SQL scripts to create desired queries (views) for data analysis
- Generated variety of business reports from SQL server using excel with pivot table and pivot chart
- Created excel reports with pivot, drill-down and drill-through functions from Access
- Designed macros to transfer data between Excel and Access with task automation and generate reports with automatic formatting using VBA scripts
0-5 years of experience
Responsible for work flow, productivity and the overall management and monitoring of the Electronic Medical Record Database with the main goal to achieve the highest level of quality patient care which responds to the needs of the community that is also accessible, affordable and appropriate. Working closely with, and report to the Chief Information Officer, and participates in planning and program development, quality assurance and continuous quality improvement, budget development, reporting and ensuring compliance with regulations and licensing requirements
- Operate help desk and active support via telephone, E-mail, Web and onsite as needed.
- Develop, test and document Medinformatix Electronic Medical Record templates according to design specifications
- Develop, test and document Medinformatix Electronic Medical Record clinical development and reports using standard SQL based query and reporting tools
- Performing trouble shooting, diagnostics, customization, minor development, remote training.
- Setup, install, and testing existing developed databases as well as implemented, monitored, and maintained disaster recovery.
- Monitored and fine-tuned databases performance
- Use analytical skills to troubleshoot data problems surfaced through the reports as needed.
- Use and support enterprise level report writing tools to develop standard clinical and financial reports for both departmental and enterprise use as well as maintain and support existing reports against required standards of performance.
0-5 years of experience
Developed an in-house application which allowed users who were on-call to synchronize database information to a laptop
- Database support (SQL Server, MS Access)
- Ran jobs to migrate data from a UNIX database to a SQL Server database using DTS packages created in SSIS
- Normalized databases to consolidate into an enterprise system
- Developed database application using VBA
- Solved business problems applicable writing queries
- Assisted customers in solving application problems
- Designed and Developed reports using Crystal Reports
0-5 years of experience
Identified and developed data processing tools through automation and standardization using data analysis and design. Demonstrated a high level of motivation, efficiency, and ability to meet any objective with proven ability to troubleshoot with a high degree of initiative and good judgment.
- Data manipulations/scrubbing
- Update and enhance data imports and exports
- Data Analysis
- Data Extracts
0-5 years of experience
- Responsible for monitoring of scheduled SQL jobs running SSIS Packages for daily loading of production data. Troubleshooting the cause of the failure and rerunning the package.
- Setting up the automation process of downloading real estate MLS listings feed and photos.
- Perform data analysis for data integrity, perform data cleansing & normalization of data.
- Building stored procedures involving complex joins, sub queries, aggregate functions, User defined functions using TSQL and advanced SQL for a variety of business requirements.
- Scheduled windows batch jobs and SQL jobs using SQL Server Job Agent.
- Handle tickets/issues affecting production and staging data on the web sites.
SQL Data Analyst Duties and Responsibilities
Duties vary for SQL data analysts based on the specific needs of the hiring company and the amount of data being analyzed. However, these core tasks are commonly associated with this job:
Integrate Data SQL data analysts integrate data from multiple data sets into o:ne database system to streamline information.
Create Database Functions SQL data analysts program specific database functions to create database triggers and design data tables.
Design Reports After reviewing and analyzing data, SQL data analysts design reports to show statistics and other information about specific database topics.
Clean Database SQL data analysts remove dead data files and other irrelevant information to free up database space.
Write Scripts SQL data analysts write scripts to analyze data and perform specific data queries.
Resolve Data Issues SQL data analysts isolate and resolve issues with data and databases.
Add Data SQL data analysts collect data from multiple sources and add it to the database.
SQL Data Analyst Skills and Qualifications
SQL data analysts use their in-depth knowledge of SQL programming to write programs and scripts that analyze and organize data. Employers look for candidates who have all the following skills:
- Programming – SQL data analysts have strong programming skills, particularly in SQL, structured query language, and other common programming languages
- Computer skills – because SQL data analysts perform their work on computers, highly advanced computer skills are required for this job
- Mathematics – SQL data analysts use math to write complex scripts and queries in SQL and other programming languages
- Analytical thinking – sharp analytical thinking is essential for SQL data analysts, who analyze specific data sets and statistics
- Attention to detail – SQL data analysts must be highly detail oriented to write SQL programs and monitor data
- Multitasking – SQL data analysts work with multiple data sources and data sets, which requires a talent for multitasking
SQL Data Analyst Education and Training
Most employers require SQL data analysts to have a bachelor’s degree in mathematics, statistics, business, or a related field. Additionally, many employers require SQL data analysts to have past work experience with programming and databases. For some employers, a master’s degree will suffice in place of work experience. Little to no training is provided to SQL data analysts, as they already have extensive knowledge of SQL programming prior to being hired. Many companies offer an orientation period where SQL data analysts learn more about the company’s specific needs. During this period, SQL data analysts familiarize themselves with the company before assuming a full workload. This period is generally brief, typically lasting one to two weeks.
SQL Data Analyst Salary and Outlook
According to PayScale, the median annual salary for SQL data analysts is $61,128. However, job data from the Bureau of Labor Statistics (BLS) shows that database administrators (who perform many of the same duties) earn $87,020 in median annual pay, or $41.84 per hour. The BLS projects that these jobs will rise 11 percent through 2026. This is faster than the national job growth average. SQL data analysts receive complete benefits packages that include health, dental, vision, and life insurance coverage. Often, retirement planning options are also provided. Paid holidays, sick days, and vacation days are standard benefits. Some companies provide SQL data analysts with additional perks, such as profit-sharing bonuses, gym memberships, and free parking.
Helpful Resources
Find career resources, SQL techniques, programming tips, data industry events, and other helpful information for SQL data analysts with these books and websites:
Digital Analytics Association – browse through professional development resources, job openings, upcoming event dates, and research documents at the DAA website
What Is SQL? Database Learning Basics for Business Professionals – master all the basics of SQL with this guidebook that teaches techniques on writing SQL queries. This text is a how-to guide for beginners and a refresher for SQL programming professionals
Data Science Association – find news updates, browse through a digital library, and search for upcoming events in data science at the DSA website
Write Better SQL Queries + SQL Interview Questions – learn how to write better SQL queries, a skill every SQL data analyst needs, with the tips and strategies in this book
Modern Analyst – find job openings, watch training webinars, and explore content related to data analytics at this website designed for all types of data analysts and analytical professionals
Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts – use this handbook to find solutions to all sorts of SQL issues, get tips on troubleshooting, and learn strategies for using other programming languages in addition to SQL
Rate This Article
Sql Data Analyst
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
