Application Developer
Application Developer IVInsight Global is seeking an experienced Application Developer IV to support a growing portfolio of internal business applications, databases, dashboards, and reporting solutions. This is a hands-on role combining SQL Server database development, data modeling, web application development, and business intelligence. The ideal candidate will be strongest in database architecture and SQL development, while also being comfortable working across JavaScript-based front-end applications and Power BI reporting. The developer will join a lean, collaborative team supporting the School of Medicine's administrative, financial, research, and clinical missions. The team values practical solutions, high-quality work, and the ability to deliver business value quickly. This is a net-new position created in response to increased application and reporting demand.
Key Responsibilities
Database Development and Data Modeling:
Design and maintain relational databases supporting internal business applications and reporting.
Develop scalable data models for transactional applications, dashboards, and analytical reporting.
Write and optimize complex SQL queries, stored procedures, functions, and triggers.
Evaluate query performance and implement appropriate indexing and optimization strategies.
Support the movement, validation, and integration of data across applications and reporting environments.
Ensure data models accurately reflect business definitions, workflows, and reporting requirements.
Web Application Development:
Develop and support internal, database-driven web applications.
Build responsive application functionality using JavaScript, jQuery, AJAX, HTML, and CSS.Develop and maintain ASP.NET and C# application components.
Create data-entry, validation, approval, and workflow capabilities for internal business users.
Support a combination of legacy applications and net-new development.
Deliver practical, durable solutions without unnecessary complexity or overengineering.
Business Intelligence and Reporting:
Develop and support Power BI dashboards, reports, and semantic models.
Build data models that can be used across application and reporting environments.
Develop DAX calculations and measures when needed.
Support executive and operational reporting across finance, research, clinical revenue, budgeting, and other administrative functions.
Validate dashboards and reports against source data and approved business rules.
Contribute to reporting solutions within Microsoft Fabric as the organization continues its migration.
Business Analysis and Stakeholder Support:
Partner with business leaders to gather and clarify requirements.
Translate business needs into technical designs and development plans.
Communicate directly with stakeholders regarding priorities, timelines, risks, and deliverables.
Produce clear technical documentation for applications, databases, workflows, and reporting solutions.
Work independently while collaborating closely with a small application development and BI team.