Power BI Junior Data Engineer

At Conn Selmer, we're passionate about music and dedicated to producing the highest-quality instruments for musicians of all skill levels. As a member of our organization, we seek candidates who possess the following values : Integrity, Excellence, Teamwork, Inclusivity, and Innovation. Please see our Conn Selmer website (www.connselmer.com) for more information about who we are.

The Junior Data Engineer is responsible for performing data analysis on ERP systems, financial systems, and custom-developed applications.

Responsibilities :

• Perform data analysis on ERP systems including Microsoft Dynamics 365 and Dataverse.
• Perform data analysis on financial systems and custom-developed applications.
• Develop Power BI and Microsoft Fabric reports for financial analysis and management reporting.
• Create SQL-based queries and integrate with Data Factory pipelines to facilitate data analysis and automation.
• Support and maintain data models to enhance BI reporting within Fabric's Lakehouse and Warehouse environments.
• Engage and interact with business users to identify requirements and translate them into reporting and data solutions.
• Troubleshoot and resolve BI and data integration issues across Power BI, Fabric, and Data Factory.
• Collaborate with business users to address ad-hoc data analysis requests.
• Prioritize tasks and responsibilities to manage workload effectively.
• Fully analyze the impact of report and data requests and determine the appropriate strategy for delivery.
• Escalate high-priority or production-critical issues to appropriate support staff.
• Make recommendations for process improvements, automation, and data governance best practices.
• Communicate effectively with technical and non-technical stakeholders.

Qualifications :

• Bachelor of Science in Information Systems / MIS, Computer Science, Business, or related field (or equivalent experience).
• Hands-on experience with Power BI (including Power BI Service and Fabric integration).
• Strong SQL skills.
• Exposure to Microsoft Fabric (Lakehouse, Data Warehouse, Pipelines).
• Exposure to Azure Data Factory or similar ETL / ELT tools.
• 1-2 years of experience in Business Intelligence or Data Engineering.
• Familiarity with Microsoft Dynamics 365 and Dataverse.
• Experience or coursework in data integration, orchestration, or Fabric-based workflows.
• Knowledge of Azure Synapse Analytics.
• Familiarity with PowerApps and Power Pages (formerly PowerPortal).

Recommended Certifications (or willingness to obtain within first 6 months) :

• PL-300 : Microsoft Power BI Data Analyst
• DP-500 : Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
• DP-203 : Data Engineering on Microsoft Azure
• Future Fabric certifications as they become available