Business Intelligence Developer

About the job Business Intelligence Developer

We seek a skilled and innovative Business Intelligence (BI) Developer to join our data-driven team. The ideal candidate will be proficient in developing and maintaining BI solutions that transform raw data into actionable insights, enabling informed decision-making across the organization. As a BI Developer, you will play a crucial role in the continued effort of designing, implementing, and optimizing our BI infrastructure while collaborating with cross-functional teams to deliver meaningful data solutions. This role will report to the Information Systems Manager.

Responsibilities

• Manage the data needs of technology-forward projects. Admin Office365/Azure, ERP (Dynamics GP, SalesPad), integrated software including CRM, Customer Survey Platform, Paycom, etc.
• Extract, transform, and load (ETL) data from various sources into data warehouses or data marts, ensuring data accuracy and consistency.
• Optimize and fine-tune SQL queries and data models for optimal performance and responsiveness.
• Develop and maintain data pipelines, data integration processes, and data cleansing procedures.
• Implement data governance practices, ensuring data quality, security, and compliance with relevant regulations.
• Participate in data architecture and modeling discussions to ensure the scalability and flexibility of BI solutions.
• Design, develop, and maintain BI reports, dashboards, automated alerts, and data visualizations using industry-leading tools and technologies (e.g., PowerBI, T-SQL, PowerShell, Python).
• Collaborate with business stakeholders to gather requirements and translate them into effective BI solutions that address data analysis and reporting needs.
• Implement automation of various functions in Microsoft GP, Taulia, SalesPad, and others related to departmental needs.
• Monitor and troubleshoot BI solutions to identify and resolve performance issues or data discrepancies.
• Stay current with industry trends and best practices in BI and data analytics, bringing innovative ideas to enhance the organization's data capabilities.
• Collaborate with cross-functional teams, including data analysts, data scientists, and business users, to understand their requirements and provide data-driven solutions.
• Provide training and support to end-users, ensuring they can effectively utilize BI tools to access and analyze data.
• Participate in the planning and execution of BI projects, ensuring on-time delivery and alignment with business goals
• Collaborate with third-party IT support vendors as needed and ensure they are informed when projects affect them or the services they provide or manage.
• Assist with data capture, planning, and implementation of new software releases and cross-functional assignments.
• Contribute as a member of the Opportunity Analysis Team by researching, following up, resolving issues, and documenting resolution processes that may need to be replicated by others.

• Strong understanding of software systems, including cloud-hosted (Azure), web-based, and software-as-a-service (SaaS).
• Prior experience with Microsoft GP, SalesPad, ZenDesk, and StockIQ would set a candidate apart but is not required for this role.
• Proficiency with PowerBI, MS SQL, PowerShell, Python, and SSRS.
• Experience in data warehouse design and schema structuring.
• Strong problem-solving, attention to detail, and analytical skills.

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
• 5+ years' experience required.
• Critical thinking uses logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, and problem approaches.
• Communicating effectively in writing as appropriate for the needs of the audience.
• Positive work attitude that is professional, responsive, and welcoming.
• Demonstrated abilities of resourcefulness, flexibility, thinking with good judgment, initiative, and a strong work ethic.
• Proficiency in computer software in all aspects of Microsoft Office, particularly Excel, Word, and Outlook.
• Judgment and decision making - considering potential actions' relative costs and benefits to choose the most appropriate one.
• A team player driven to help our client's team accomplish our goals.