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.
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.
Role Specific Requirements
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.
Experience & Education
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.