Sr. Application Developer

Role: Sr. Application Developer

Location: Lenoir, NC (Hybrid – 3 days per week onsite)

(FULLTIME / Direct Hire)

Senior Application Developer (SQL, Power BI, Data Engineering & AI)

Required Qualifications

• 5+ years of professional experience in application development with significant data responsibilities.
• Advanced SQL skills (complex queries, performance tuning, indexing concepts, and database object development).
• Demonstrated SSRS and SSIS experience
• Strong Power BI experience (data modeling, DAX, Power Query, performance optimization).
• Proficiency in one or more modern programming languages such as C#, Java, Python, or JavaScript.
• Experience with modern web technologies: HTML, CSS, JavaScript, and TypeScript.
• Experience with modern front-end frameworks/libraries such as React (or equivalent).

Preferred Qualifications

• Experience with data warehouse/analytics engineering (dimensional modeling, curated datasets, governed semantic layers).
• Experience building and integrating REST APIs and system-to-system integrations.
• Experience with Microsoft Power Platform (Power Apps / Power Automate) and related development patterns.
• Experience developing and integrating SPFx web parts and/or Power Apps Component Framework (PCF) components.
• Experience with DevOps practices and automation tooling (e.g., Azure DevOps) and scripting (e.g., PowerShell).
• Experience with version control (e.g., Git) and Agile delivery practices.
• Familiarity with AI concepts and enterprise AI tooling, including implementing secure, governed AI-enabled solutions.
• Manufacturing/distribution business process experience (inventory, purchasing, logistics, order lifecycle) is a plus.

Key Responsibilities
Power BI & Enterprise Reporting

• Design, build, and optimize Power BI datasets/semantic models and reports using best practices.
• Develop DAX measures and Power Query transformations; optimize performance and user experience.
• Partner with business users to define KPIs and ensure consistent calculation logic across reports.
• Support publishing, access controls, and governance for enterprise reporting.

Application Development (Modern Technologies)

• Design, develop, test, deploy, and maintain business applications and services using modern engineering practices.
• Build and enhance web applications, APIs, and integration services.
• Write clean, maintainable, efficient code; participate in code reviews and contribute to development standards.
• Collaborate with stakeholders to translate business requirements into technical specifications and solution designs.

SQL Development & Data Engineering

• Develop and optimize complex T-SQL (stored procedures, views, functions) and perform performance tuning and indexing.
• Engineer reliable data pipelines for ingestion, transformation, validation, and orchestration; implement logging and monitoring.
• Troubleshoot data integration issues and ensure data accuracy, integrity, and auditability.
• Create and maintain technical documentation for databases, pipelines, and interfaces.

Data Warehouse / Analytics Engineering

• Design and maintain analytics-ready datasets, dimensional models, and governed semantic layers.
• Establish and enforce standards for metric definitions, dataset reuse, refresh schedules, and data documentation.
• Improve data quality and availability through validation routines and automated checks.

AI Technology Enablement

• Identify and implement AI-assisted opportunities in analytics and application workflows (e.g., summarization, anomaly detection, intelligent search, guided insights).
• Apply responsible AI practices, including validation, governance alignment, and human-in-the-loop controls as appropriate.
• Contribute to reusable patterns for safe, secure AI integration into business processes.

Operational Excellence & Support

• Provide production support, perform root cause analysis, and implement permanent fixes.
• Maintain runbooks, technical documentation, and deployment/support procedures.
• Mentor junior developers and contribute to team capability building.