Sr Application Developer (SQL, PBI, Data Engineering & AI)

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

Department:
Information Technology (IT)

Position Type:
Full-Time | Exempt

Location:
Lenoir, NC (Hybrid)

Reports To:
Software Development Manager / VP of IT (as assigned)

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)