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

About this Role:

• Job Position: Senior Application Developer (SQL, Power BI, Data Engineering & AI)
• Job Location: Lenoir, NC
• Job Type: Full Time - Hybrid

We are seeking a Senior Application Developer (SQL, Power BI, Data Engineering & AI)

Job Summary:
We are seeking a Senior Application Developer to design, develop, and support modern business applications and data-driven analytics solutions across the enterprise. This role requires strong SQL development skills, advanced Power BI skills, and hands-on experience in data engineering and data warehousing. The ideal candidate can deliver high-quality end-to-end solution applications, integrations, pipelines, semantic models, and dashboards while contributing to the secure, responsible adoption of AI-enabled capabilities that improve productivity and decision-making.

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 TSQL (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.

Required Qualifications

• 3-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).
• 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).
• Strong problem-solving, troubleshooting, and documentation skills.
• Strong written and verbal communication skills and ability to work effectively with business stakeholders.

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.
• SSRS experience preferred, including maintaining or modernizing reporting solutions.
• SSIS experience preferred, including maintaining or modernizing ETL solutions.
• Development team leadership experience preferred, including mentoring developers, leading code reviews, estimating work, and coordinating delivery across stakeholders.
• Manufacturing/distribution business process experience (inventory, purchasing, logistics, order lifecycle) is a plus.