Job Description:
Job Title: Business Intelligence (BI) Developer – Power BI & SQL
Job Summary
We are seeking a skilled and self-directed Business Intelligence (BI) Developer to help us build and maintain a modern reporting infrastructure across two SQL environments—Microsoft SQL Server and PostgreSQL—using Power BI. This role will be instrumental in transforming raw data into actionable insights for finance, sales, operations, and executive leadership teams. The ideal candidate is fluent in SQL (T-SQL and PostgreSQL dialects), has deep expertise in Power BI data modeling and visualization, and can work independently to understand business requirements, design scalable solutions, and maintain a clean and reliable BI library.
Key Responsibilities
• Connect to and query both Microsoft SQL Server and PostgreSQL databases to extract and transform data for reporting.
• Design, develop, and maintain Power BI datasets, data models, dashboards, and reports.
• Create intuitive, visually compelling dashboards that drive data-informed decision-making.
• Collaborate with business stakeholders to gather requirements, define KPIs, and iterate on report design.
• Optimize performance of Power BI reports and underlying SQL queries.
• Maintain a well-organized and governed BI workspace/library.
• Document data sources, logic, and report usage for internal stakeholders.
Required Qualifications
• Strong SQL skills in both Microsoft SQL Server (T-SQL) and PostgreSQL.
• Proven experience building and publishing Power BI dashboards and data models.
• Ability to write efficient queries and optimize performance across large datasets.
• Excellent problem-solving skills and attention to detail.
• Strong communication and documentation skills.
Preferred Qualifications
• Experience working with data warehouses, ETL pipelines, or data integration tools is a plus.
• Experience in a distribution, manufacturing, or multi-entity environment is a bonus.
• Power BI Desktop and Power BI Service.
• Microsoft SQL Server Management Studio (SSMS).
• pgAdmin or other PostgreSQL clients.
• DAX and Power Query (M).
• Git, DevOps, or version control tools (optional).
Key Competencies
• SQL & Database Querying
• Power BI Dashboard Development
• Data Modeling & DAX
• Performance Optimization
• Stakeholder Collaboration
• Documentation & Reporting
• Problem Solving