Demo

BI Developer

iAppsData Inc
Maryland, MD Full Time
POSTED ON 2/4/2025
AVAILABLE BEFORE 4/4/2025

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a BI Developer?

Sign up to receive alerts about other jobs on the BI Developer career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$81,298 - $105,685
Income Estimation: 
$101,449 - $132,468
Income Estimation: 
$88,359 - $121,264
Income Estimation: 
$93,716 - $124,745
Income Estimation: 
$118,976 - $146,289
Income Estimation: 
$112,672 - $149,113
Income Estimation: 
$98,475 - $115,895
Income Estimation: 
$135,811 - $184,429
Income Estimation: 
$176,131 - $238,730
Income Estimation: 
$172,979 - $241,697
Income Estimation: 
$65,674 - $90,812
Income Estimation: 
$74,161 - $98,561
Income Estimation: 
$92,249 - $117,370
Income Estimation: 
$88,359 - $121,264
Income Estimation: 
$113,076 - $148,099
Income Estimation: 
$112,672 - $149,113
Income Estimation: 
$115,719 - $153,093
Income Estimation: 
$137,343 - $165,639
Income Estimation: 
$135,811 - $184,429
Income Estimation: 
$120,390 - $162,969
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at iAppsData Inc

iAppsData Inc
Hired Organization Address Logansport, IN Contractor
Hi, Hope you are doing good, (On-Site) My name is Adam Smith, I represent Iappsdata INC. We do have the job opening for ...
iAppsData Inc
Hired Organization Address Des Moines, IA Contractor
The purpose of this position is to provide technical writing support , standardization of documentation, and business su...
iAppsData Inc
Hired Organization Address Englewood, CO Full Time
Job Details Responsibilities Include: Manage CI and CD tools and processes in various business units. Drive automation a...
iAppsData Inc
Hired Organization Address Greenfield, IN Full Time
Job Details Job Title: Technical lead (Databricks, Azure Data Lake, Python) Duration: Long term contract Location: Green...

Not the job you're looking for? Here are some other BI Developer jobs in the Maryland, MD area that may be a better fit.

Python Developer

Bi Labs, Tysons, VA

PeopleSoft Developer

ACCEL BI CORPORATION, Raleigh, NC

AI Assistant is available now!

Feel free to start your new journey!