Senior Data & Applications Engineer (SQL/BI/.NET)

IAM National Benefit Funds Office; Washington (District of Columbia); On-site; USD 95,000 - 135,000; Full time

Benefits offered by this job

Health, dental, vision benefits

401(k) plan with employer contribution

Generous vacation and holidays

Job summary

The IAM National Benefit Funds Office seeks an experienced Senior Programmer Analyst to join the IT Department. You will support three funds and help implement a new benefit administration system, integrating new technologies.

The role requires strong SQL expertise, data modeling, BI, ETL, and web app development with VB.NET/ASP.NET. Collaboration across teams and mentoring of junior staff are essential.

Qualifications

• Extensive SQL development and stored code with DB administration experience.
• Experience in Agile/SCRUM development environments.
• Proficiency in data modeling and relational DB concepts.
• Proficiency with BI/ETL tools and reporting.

Responsibilities

• Analyze user specs and capture requirements; become SME.
• Develop and debug stored procedures, triggers, packages, functions.
• Perform data migration, ETL, and reporting tasks.
• Support web app development using VB.NET/ASP.NET.
• Mentor junior analysts and document processes.

Skills

SQL

Stored procedures/triggers

Agile/SCRUM

Data modeling

BI & ETL tools

.NET / VB.NET

Python

VBScript

Unix

PowerShell

Batch scripting

Team Foundation Server

Subversion

Education

BA/BS in Computer Science/Information Technology or related field

Tools

PostgreSQL

Oracle

SQL Server

UniData

VB.NET/ASP.NET

VBScript

Macros

Unix

PowerShell

SSRS

OBIEE

Power BI

SharePoint

Team Foundation Server

Subversion

Job description

The IAM National Benefit Funds Office seeks an experienced Senior Programmer Analyst to join the IT Department. You will support three funds and help implement a new benefit administration system, integrating new technologies.

The role requires strong SQL expertise, data modeling, BI, ETL, and web app development with VB.NET/ASP.NET. Collaboration across teams and mentoring of junior staff are essential.