What are the responsibilities and job description for the BI Developer position at iAppsData Inc?
Job Details
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.