Columbia Distributing - Wilsonville, OR
posted 5 months ago
The IT Business Intelligence Developer role at Columbia Distributing is a pivotal position focused on delivering technical data solutions tailored to meet the needs of the company's business stakeholders. This role serves as a crucial link between the Information Technology (IT) department and various business units, necessitating a strong collaborative approach with business groups, project team members, and external vendors. The successful candidate will leverage their expertise in business analysis, design, coding, and agile software development lifecycles to create, maintain, and enhance the data management strategy that supports Columbia Distributing's operational goals. In this role, the developer will be responsible for providing both technical and business expertise, leading discussions, and facilitating meetings to elicit requirements and gain a comprehensive understanding of business needs and challenges. The developer will participate in the design and development of enterprise-wide solutions and data repositories, ensuring that the solutions align with the strategic objectives of the organization. Additionally, the role involves consulting with end users to refine and enhance existing Business Intelligence and Data Analytics solutions, thereby improving the overall effectiveness of data-driven decision-making processes. A significant aspect of this position includes defining and implementing the overall ELT and ETL architecture, which encompasses key designs on integration standards such as loading, streaming/near real-time/batch processing, change data capture (CDC), data validation, and parallelization. The developer will also participate in large-scale database migration and acquisition projects, developing multi-dimensional models and ETL processes to convert operational transactional data into dimensions and fact tables. Furthermore, the role requires scheduling and coordinating infrastructure maintenance activities, including hardware and software upgrades, while building and maintaining positive relationships with business users, management, and other technical groups across the organization.