What are the responsibilities and job description for the Business Intelligence Analyst position at Gill Staffing?
We are seeking an experienced and dynamic Business Intelligence Analyst to lead business intelligence efforts. You will oversee the development and optimization of business intelligence (BI) reports, manage business intelligence projects from conception to implementation, and act as the main interface with clients to determine the best approach to meet and exceed their needs. In this role, you will also ensure the effectiveness and efficiency of data models, processes, and systems while aligning business intelligence efforts with overall company goals. This role involves collaborating with internal and external teams to gather data and visualization requirements, create efficient data models, write and optimize SQL queries, and design insightful dashboards and reports using Power BI and potentially other tools.
Key Responsibilities:
• Manage the full lifecycle of business intelligence processes, including data extraction, transformation, and reporting
• Oversee and guide the creation of insightful and visually appealing dashboards and reports using Power BI
• Conduct business requirements analysis, working closely with internal stakeholders and external clients
• Implement and monitor key performance indicators (KPIs) for BI operations, ensuring continuous improvement
• Develop and optimize SQL, Power Query, and DAX queries, ensuring data accuracy, integrity, and performance
• Develop and optimize extract, transform, and load (ETL) processes
• Gather requirements and translate them into data models and visualizations using Power BI
• Assist in troubleshooting database and Power BI issues and provide timely resolutions
• Stay updated with emerging trends and best practices in SQL and Power BI technologies
Skills and Qualifications:
• Bachelor’s degree in Computer Science, Information Technology, or comparable learning and job experience
• Self-starter (ability to take initiative, improve, and ask questions without being prompted)
• Excellent client-facing communication and presentation skills, with experience in business requirements analysis
• Strong understanding of SQL and database concepts
• Proficiency in Power BI Power BI, Power Query, and DAX for data visualization and reporting
• Experience with GitHub or similar technologies to manage query and report pipelines
• Leadership and project management skills, with the ability to manage multiple priorities and team members
• Analytical and problem-solving mindset, with attention to detail and a proactive approach to improving BI operations
• Ability to communicate effectively and collaborate within a team environment
• Eagerness to learn and adapt to new technologies and methodologies
Compensation and Benefits:
• Salary range of $60,000-70,000 USD.
• Health, Dental, and Vision insurance
• Retirement savings plan (401(k)) with company match • Paid time off (vacation, holidays, sick leave)
• On-site work 3-4 days/week (Novi, MI) and Remote work 1-2 days/we
Salary : $60,000 - $70,000