What are the responsibilities and job description for the SQL Data Analyst position at Steinberger Floors?
**Remote Work Flexibility**
Purpose:
A SQL Data Analyst at RareMed Solutions will provide strategic and tactical support to the Analytics team and will report directly to the Lead of Analytics and Reporting. The SQL Analyst will work to develop and distribute reports on a scheduled basis both internally and externally. In addition, the SQL Analyst will work with external partners to collect and load data into the RareMed data warehouse.
Responsibilities:
Developing and maintaining stored procedures, functions, views and other scripts as necessary to generate data
Utilizing SSIS to generate packages that will clean and import data from external sources as well as export data
Independently perform root-cause analysis to identify and resolve issues quickly
Identifying key trends reports for RareMed management and external partners to drive key decisions
Work with management team to define and collect data needed for specific departments and for contractual obligations
Work with management to format internal data into dashboards before sharing externally
Utilizing an internal scheduling software as well as Windows Task Scheduler to ensure data is distributed at appropriate times
Tune and modify existing databases as needed to upgrade functionality
Other duties as assigned
Required Qualifications:
Bachelor's Degree in relevant field or related education/equivalent experience
1 – 3 years of hands-on experience in a SQL based environment
Highly proficient at writing efficient queries, views, indexes, stored procedures and functions within SQL Server
Understanding of advanced concepts in relational database management
Capacity to quickly familiarize themselves with new software and technologies
Strong analytical skills with attention to detail
Ability to exercise independent judgement to manage data in a high paced environment
Preferred Qualifications:
Advanced Excel knowledge, including Pivot Tables, Advanced Charts/Graphs, VBA.
Experience writing PowerShell scripts and batch files to move/manipulate files as needed
Prior experience with report generating technologies (SQL Reporting Services, Crystal Reports etc.)
Experience with documenting technical processes
Previous pharmaceutical and/or healthcare experience
Work Environment
This job operates in a professional office environment and teleworking from the employee’s home address listed in their employment file. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. When telecommuting employees must have reliable internet access in order to access required systems and software associated with the position's responsibilities. The amount of time the employee is expected to work per day or pay period will not change as a result of participation in the teleworking program. Employees are responsible for the set-up of their home office environment, including physical set-up, internet connection, phone line, electricity, good lighting, comfortable temperature, furniture, etc. Employee’s teleworking space should be separate and distinct from their “home space” and allow for privacy. RareMed expects employees teleworking to be as efficient and professional as if they were in the office. The amount of time spent in office or teleworking is contingent upon the needs/priorities of RareMed and will vary based on those needs/priorities.
Physical Demands
While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands and fingers, handle or feel; and reach with hands and arms.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function of the job.