Job Details

Explore Location

System Specialist - Information Technology

TELA Bio

Malvern, Pennsylvania, United States

(on-site)

Posted 1 day ago

Job Type

Full-Time

Salary

$65,000.00 - $85,000.00

Salary - Type

Yearly Salary

Job Function

Other

Description

Position Title: Systems Specialist Position OverviewA SQL Systems Specialist manages, monitors, and optimizes relational database systems (primarily SQL Server) to ensure data integrity, high availability, and security. They develop complex queries, maintain database performance, perform backups/restoration, and support development teams with data modeling and ETL processes. They will also work with SSRS, SSIS and Power BI daily to assist users with report requests.Essential Duties and Responsibilities

Convert business needs into needed specifications and coordinate with team members for customizations
Address user requests, resolve issues, and liaise with internal teams
Adherent to change management procedures
Performance Tuning: Monitoring database performance, identifying bottlenecks, and optimizing SQL queries, stored procedures, and indexes
Maintenance & Backup: Implementing backup/recovery strategies, managing database integrity checks, and handling SQL Agent jobs
Development Support: Collaborating with teams to design database schemas, develop ETL processes, and build SSIS packages/SSRS reports
Data Integrity & Security: Ensuring compliance with security standards (e.g., STIGs, HIPAA) and performing data migration/integration
Create, manage and update Power BI dashboards

Implementation & Continuous Improvement

Track system adoption and KPIs to drive improvements.
Recommend enhancements based on data and feedback.

Cross-Functional Collaboration & Change Management

Act as an effective link between business teams and IT or development resources.
Lead workshops, training programs, and meetings that involve multiple departments.
Assist in managing change initiatives to increase user acceptance of new processes, tools, and solutions, thereby enhancing system usage.

Education and Experience

Bachelor's degree in information systems, or a related field
Five years of relevant professional information system experience

Required Knowledge, Skills and Abilities

Strong analytical and critical thinking abilities
Excellent communication skills, with the ability to engage effectively with both technical and non-technical team members in-person and remote environments
A user-focused perspective combined with strong business orientation
Capable of working independently within a dynamic, multi-entity environment
Standard work hours are Monday through Friday, 8:30 a.m. 5:00 p.m., with flexibility required across North American time zones and a willingness to work additional hours as necessary
Consume, analyze, and manage data using Python, SQL, and other programming languages
Conduct basic business analyses such as exploratory data analysis and reporting.
Transform results into digestible visualizations
Familiarity with SSRS as well as Report Builder
Knowledge of T-SQL, SQL Server Management Studio (SSMS), SSIS, SSRS, and/or SSAS

Typical Tools

Microsoft SQL Server (T-SQL)
SSMS, SSIS, SSRS, SSAS
Power BI

Physical DemandsThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to:

Ability to carry and lift product inventory of up to 10 lbs.
Must have demonstrated ability to multitask in high pressure, changing conditions.

Working ConditionsThis position works in the home office or corporate office. The noise level in the work environment is quiet to moderate. Primary Location and TravelWe anticipate that on an ongoing basis this role will be based in the Corporate Office with the ability to work from home one day a week after initial training is completed. No travel is expected for this position. DisclaimersThis is a representative description of the job and is not intended to be all-inclusive. Employees may perform other related duties as required to meet the ongoing needs of the organization. Duties, responsibilities, and activities may change at any time with or without notice. TELA Bio, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, pregnancy, national origin, age, marital status, protected veteran status, disability status, or any other status protected by federal, state, or local law. For more information, please check out our website: www.telabio.com

PI282838533

Job ID: 82796510

Jobs You May Like

Manager End User Engineering

AmeriGas

King Of Prussia, PA, United States (on-site)

Continuing Non-Tenure-Track Teaching Faculty...

Villanova University

Villanova, PA, United States (on-site)

Assistant Teaching Professor of Mathematics

Villanova University

Villanova, PA, United States (on-site)

Certified Middle School Technology Teacher

Kaleidoscope Education...

Aston, PA, United States (on-site)

Job Location

Median Apartment Rent in City Center

(1-3 Bedroom)

$1,500 - $2,600

Utilities

Basic

(Electricity, heating, cooling, water, garbage for 915 sq ft apartment)

$155 - $472

High-Speed Internet

$50 - $100

Transportation

Gasoline

(1 gallon)

$3.07

Taxi Ride

(1 mile)

$2.51

Data is collected and updated regularly using reputable sources, including corporate websites and governmental reporting institutions.