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.