What are the responsibilities and job description for the Sr. Database Developer/BI Developer with Python position at Kaizen Technologies Inc?
Role : Sr. Database Developer / BI Developer with Python
Making sure you fit the guidelines as an applicant for this role is essential, please read the below carefully.
Location : Washington DC(Onsite position)
12 Months
The 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 relatedfield.
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.
