Columbia Distributing - Kent, WA
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 groups, requiring a strong partnership with 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 the organization’s objectives. 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 thorough understanding of business needs and issues. The developer will participate in the design and development of enterprise-wide solutions and data repositories, consulting with end users to refine and enhance existing Business Intelligence and Data Analytics solutions. A key aspect of the position involves defining and implementing the overall ELT and ETL architecture, including critical designs on integration standards such as loading, streaming/near real-time/batch processing, change data capture (CDC), data validation, and parallelization. Additionally, the developer will engage in large-scale database migration and acquisition projects, develop multi-dimensional models, and create ETL processes to convert operational transactional data into dimensions and fact tables. The role also includes scheduling and coordinating infrastructure maintenance activities, such as hardware and software upgrades, while building and maintaining positive business relationships with users, management, and other technical groups across the organization. Proficiency in Columbia Distributing's business processes and applications within specific areas of expertise, such as Financials, Operations, and Sales, is essential for success in this role.