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

Senior Application Developer (SQL, Power BI, Data Engineering & AI) Bernhardt Furniture Company United States, North Carolina, Lenoir 1839 Morganton Boulevard Southwest (Show on map) Apr 18, 2026
Summary of Position
Bernhardt Furniture Company is 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. Currently, this position does not have direct reports, but will evolve to lead a small development team. 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.
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.
Core Competencies
Engineering excellence: quality, reliability, performance, maintainability
Strong ownership: requirements through delivery and support
Analytical thinking and structured problem-solving
Collaboration and stakeholder management
Continuous improvement mindset and curiosity in emerging technologies (AI, analytics, modern development) E/O/E