What are the responsibilities and job description for the Business Intelligence Engineer position at Goodwill Industries of Middle Tennessee?
Job Location Lifsey-IT Job Summary: The Business Intelligence Engineer partners with business leaders to rapidly design, develop, and deploy high-impact data products within the Microsoft Fabric ecosystem. This role translates complex business questions into trusted, intuitive, and performant dashboards that drive strategic decisions. By delivering 60-day MVPs and iterating with stakeholders, the Business Intelligence Engineer ensures data solutions create measurable business value. The Business Intelligence Engineer will promote a positive work environment that celebrates our vision, mission and core values of Teamwork, Respect, Uprightness and Empowerment in every action and interaction with team members, donors, customers, management and persons served. Job Description Essential Functions Partners with stakeholders to understand business challenges and translate them into technical requirements and data models. Designs and develops end-to-end BI solutions in Microsoft Fabric, from data ingestion and modeling in the Lakehouse/Warehouse to visualization in Power BI. Writes optimized SQL/T-SQL, builds robust data models, and masters DAX and Power Query (M) to deliver performance and insightful reports. Champions data governance, quality, and best practices to ensure accuracy and trust in all data products. Deploys, tests, and iterates on dashboards with business users, incorporating feedback to improve value delivery. Collaborates with business stakeholders to align data solutions with organizational KPIs. Stays current with Microsoft Fabric, Power BI, and modern BI trends to drive innovation and adoption. Maintains BI systems, troubleshoots performance issues, and ensures reliability and security. Uses scripting or programming languages (Python or R) for automation, advanced analytics, or machine learning integrations when required. Implements and optimizes ETL processes, ensuring data is accurately extracted, transformed, and loaded into warehouse environments. Other duties as assigned. Minimum Qualifications Required Skills Education Bachelor’s degree in computer science, Data Analytics, Information Systems, or related field; or equivalent combination of education and work experience. Experience Minimum 5 years of experience in business intelligence engineering, business intelligence, or data modeling. Proven expertise in Power BI, including complex DAX, star schema modeling, and performance optimization. Strong proficiency in SQL/T-SQL for data transformation and modeling. Hands-on experience with Microsoft Fabric or equivalent modern data platform (Synapse, Databricks, Snowflake). Familiarity with data pipeline/ETL tools (Fabric Dataflows Gen2, Data Factory, or similar). Experience with additional ETL and data integration tools (e.g., SSIS, Informatica) preferred. Experience with scripting/programming for data analysis (Python or R). Knowledge / Skills Product mindset with ability to link technical solutions to business outcomes. Excellent communication skills with ability to explain complex data concepts to non-technical audiences. Ability to manage projects from design through delivery. Agile, results-driven, and comfortable delivering value quickly. Microsoft Certified: Fabric Business Intelligence Engineer Associate or Data Analyst Associate. Familiarity with data governance frameworks. Exposure to AI, automation, and advanced analytics capabilities in Microsoft environments. Goodwill Industries of Middle Tennessee's mission is to change lives through education, training, and employment. Full-Time Benefits: Health and Prescription Insurance, 403(b) Retirement Plan, Paid Vacation, Holiday, & Sick Leave, Paid Bereavement Leave, Employee Assistance Program Part-Time Benefits: 403(b) Retirement Plan, Paid Vacation & Sick Leave, Employee Assistance Program