Job Description Aligned Solutions has partnered with a well respected company seeking a Business Intelligence (Power BI Developer) who will play a critical role in driving data-driven decision-making across sales, marketing, and supply chain functions. This role requires deep expertise in Power BI development, data modeling, SQL, and ETL processes to design scalable BI solutions and deliver actionable insights. --- Key Responsibilities Power BI Development & Data Modeling · Design, develop, and optimize Power BI dashboards and reports to support business strategy and performance tracking. · Build and maintain data models to ensure accuracy, consistency, and performance efficiency in Power BI. · Write advanced DAX calculations and implement row-level security (RLS) in Power BI reports. · Develop Power Query transformations to clean and integrate data from multiple sources. SQL & Data Management · Write complex SQL queries to extract, manipulate, and transform data from relational databases. · Optimize data queries for improved performance in Power BI reports. · Manage data integration from diverse sources (ERP, CRM, external APIs) into a unified reporting environment. ETL & Data Pipeline Management · Develop and maintain ETL processes to ensure efficient data extraction, transformation, and loading. · Collaborate with IT to integrate Power BI with Azure, SAP, or other enterprise data sources. · Troubleshoot and resolve data integrity and performance issues within Power BI reports. Business Intelligence & Reporting · Work closely with cross-functional teams (Sales, Marketing, Supply Chain, Finance) to identify reporting needs and deliver actionable insights. · Automate recurring reports and dashboards to streamline data delivery and reduce manual work. · Continuously improve BI solutions by identifying and implementing new reporting enhancements. --- Required Qualifications · Bachelor’s degree in Computer Science, Business Analytics, Statistics, Supply Chain, or related fields. · 5+ years of experience in Power BI development, data analytics, or business intelligence roles. · Expert in Power BI – including DAX, Power Query, data modeling, and dashboard optimization. · Advanced SQL skills – ability to write and optimize queries for large datasets. · Experience with ETL processes – integrating and transforming data from multiple sources. · Strong knowledge of data visualization best practices and KPI tracking. · Familiarity with Azure, SAP, ERP/CRM systems, or API data connections is a plus. --- Preferred Skills Experience in demand planning, supply chain analytics, or inventory management. Strong Excel skills (Power Query, VBA, Live Dashboards). Exposure to Python or R for advanced analytics (optional but a plus). Experience optimizing Power BI performance for large-scale datasets.
Posted On: Friday, February 7, 2025
Compensation: 21,000