MSBI Developer

Major Duties and Responsibilities:

• Perform all aspect of database development under the direction of the DBA manager including:
• Conduct thorough code reviews of current and previous development efforts.
• Optimize and tune database code for performance enhancements.
• Design, develop, enhance, and support database applications.
• Develop complex SQL code, including stored procedures, triggers, views, and functions.
• Apply a deep understanding of indexing (Clustered/Non-Clustered).
• Modify, create, maintain, and optimize ETL processes using SSIS/Python.
• Develop data extraction and import programs using SSIS.
• Demonstrate proficiency in conducting research on emerging database and data warehouse technologies.
• Collaborate with stakeholders, including IT scrum teams, to ensure a comprehensive understanding of business requirements.
• Work closely with network administrators, systems analysts, and software engineers to troubleshoot and resolve issues, escalating problems as needed.
• Perform additional duties as assigned.

Required Qualifications:

• Bachelor's degree in Information Systems / Technology, Computer Science, or a related field.
• 7+ years of experience working with databases, preferably SQL Server.
• 7+ years of experience in developing ETL processes, including the use of SSIS packages in a Microsoft SQL Server database environment.
• Extensive experience working with MS SQL Server versions 2016, 2017, and 2019.
• Proficiency in Python programming, with essential experience in data manipulation and analysis. Familiarity with libraries such as NumPy, Pandas, pyodbc, and SQLAlchemy is a plus.
• Technical expertise in relational and dimensional database design.
• Strong understanding of database security principles and data privacy practices/laws.
• Experience in database/metadata analysis and design.
• Excellent written and oral communication skills.
• Strong interpersonal skills with the ability to work in a team-oriented environment.
• Self-directed, proactive, and capable of solving problems beyond immediate tasks.
• Flexibility to adapt to changing priorities and manage multiple tasks efficiently.
• Experience working with internal and external resources to ensure timely completion of deliverables.
• Proven ability to prioritize and execute tasks in high-pressure environments with attention to detail.
• Strong analytical and problem-solving skills.
• Ability to work independently and collaboratively in a team environment.
• Familiarity with Microsoft Fabric technologies, including Data Lake, Data Warehousing, and data governance.

Desired Qualifications:

• Proficiency in SQL development, with a solid grasp of database design, optimization, and query performance tuning.
• Good understanding of core database fundamentals, including:
  • Backup and recovery processes.
  • Security concepts such as users, roles, and schemas.
  • Storage basics like pages, extents, and data files.
• Experience with SQL Server High Availability and Disaster Recovery solutions, such as:
  • SQL Server clustering and failover techniques.
  • Database mirroring, log shipping, and transactional replication.
• Strong understanding of both physical and logical data modeling principles.
• Familiarity with SQL Server 2019 features, with experience applying them in development or R&D settings.
• Experience with reporting platforms like SSRS, SSAS, PowerBI, or similar tools.
• Experience with Microsoft Fabric is a plus
• Healthcare IT or support experience is a plus but not required.
• Database administration skills (backup, recovery, security) are a plus but not mandatory.