MSBI Developer - PamTen Inc

Senior Database Application Development Associate will work as part of the Application Development Department alongside other SQL Server Developers within the DBA/Development team. This role involves developing custom SQL Server applications and code (using T-SQL), building and supporting robust ETL applications (using both T-SQL and SSIS), and performing root-cause analysis for development-related issues such as code bugs, performance problems, and locking/blocking concerns.

The ideal candidate should have a strong background in database design and the ability to interpret and implement business requirements provided by Business Analysts and other stakeholders. Experience with additional components of Microsoft's BI stack (SSAS, SSRS) and PowerBI is a plus. The Senior Database Application Development Associate must demonstrate a proven history of delivering excellent results, possess strong communication skills, and work effectively in a team environment.

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.