What are the responsibilities and job description for the SQL/SSRS Developer position at Advantage Medical Electronics, LLC?
Job Title: | SQL/SSRS Developer |
Department: | Information Technology |
Reports to: | Global IT Director |
FLSA | Exempt |
SUMMARY:
We are looking for a dedicated Mid-Level SQL and SSRS Developer to join our team. This role focuses on designing, developing, and maintaining database solutions and reports that drive business insights. The ideal candidate will have a strong background in SQL development, SSRS report creation, and data analysis to support operational and strategic initiatives.
DUTIES AND RESPONSIBILITIES:
1. Database Development & Maintenance:
- Design and optimize SQL Server databases for performance, reliability, and scalability.
- Create complex SQL queries, stored procedures, views, and triggers for application and reporting needs.
- Maintain detailed documentation of database configurations, procedures, and workflows to support clarity and operational efficiency.
- Monitor and improve database performance, ensuring high availability and security.
2. SSRS Reporting:
- Develop, deploy, and maintain SSRS reports, including parameterized, drill- through, and interactive reports.
- Work closely with stakeholders to gather report requirements and deliver actionable insights.
- Troubleshoot, enhance, and modernize existing reporting systems.3. ETL and Data Integration:
3. ETL and Data Integration:
- Implement ETL processes to extract, transform, and load data from various sources into centralized systems.
- Collaborate with data architects to design and optimize data pipelines
- Data Analysis and Support:Assist business teams in analyzing complex data to uncover trends, issues, and opportunities.
- Assist business teams in analyzing complex data to uncover trends, issues, and opportunities.
- Provide technical support for database and reporting solutions, ensuring minimal downtime.
- Create and maintain documentation for database structures, processes, and reports.
5. Continuous Improvement and Collaboration:
- Work alongside cross-functional teams to identify and implement process improvements.
- Stay updated on the latest SQL Server and reporting technologies, suggesting innovative solutions.
EDUCATION AND/OR EXPERIENCE:
- Education: Bachelor’s degree in computer science, Information Technology, Finance, or related field.
- Experience: 3-5 years of professional experience in SQL Server development and SSRS reporting. Hands-on experience with database design and T-SQL programming.
3. Technical Skills:
Proficient in SQL Server tools and technologies.
Advanced knowledge of SSRS, including creating interactive and parameterized reports.
Experience with ETL tools and data integration processes.
Familiarity with Power BI or Tableau is a plus.
Knowledge of database security and best practices.
- Soft Skills: Strong analytical and problem-solving abilities. Excellent verbal and written communication skills. Ability to work independently and in a team environment.
PREFERRED QUALIFICATIONS:
Experience with cloud-based platforms (Azure SQL, AWS RDS).
WORK ENVIRONMENT AND PHYSICAL DEMANDS:
- Prolonged periods sitting at a desk and working on a computer.
- Must be able to lift up to 15 pounds at times.
- On-Site
The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
LifeSync provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
The Age Discrimination in Employment Act (ADEA) forbids age discrimination against people who are age 40 or older. It does not protect workers under the age of 40, although some states have laws that protect younger workers from age discrimination. It is not illegal for an employer or other covered entity to favor an older worker over a younger one, even if both workers are age 40 or older.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.