Senior Business Intelligence Developer

Company: Columbia Distributing
Location: Kent
Posted on: March 17, 2023

Job Description:

Job Details

Summary

The Senior BI Developer role is focused on delivering technical data solutions for Columbia's business stakeholders. The keys to this role start with understanding the business functions and needs of the stakeholders, gathering requirements, translating requirements into technical designs tasks, as well as the ability to develop the solution. This position is a senior level position that may also include mentoring a small group of analysts and BI Developers. As one of the key contacts between Information Technology (IT) and the business, this highly visible role will require strong partnership with the business groups, project team members and outside vendors.

Your experience in business analysis, design, coding, and agile and waterfall software development lifecycles will be critical to create, maintain and enhance all the reports and analytics as part of the application.

This position can be based in Kent, Wa or Wilsonville, OR.

Key Responsibilities

• Provide technical and business expertise and lead discussions and facilitate meetings to elicit requirements and thoroughly understand business needs and issues
• Participate in the design and development of enterprise-wide solutions and data repositories
• Consult with end users to refine and enhance existing Business Intelligence and Data Analytics solutions
• Define and implement overall ELT and ETL architecture including key designs on integration standards such as loading, streaming/near real time/batch, CDC, data validation, parallelization etc.
• Provide technical leadership for large-scale database migration, and acquisition projects
• Design and develop multi-dimensional and Tabular models, as well as extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables
• Tabular model performance tuning, partitioning and optimization experience
• Power BI development and administration
• Schedule and coordinate infrastructure maintenance activities such as hardware and software upgrades and maintenance
• Perform technical administration activities such as install, configure, control failover and load balancing across multiple servers and maintain security
• Build and maintain positive business relationships with business users, management, and other technical groups across the organization
• Proficient in Columbia Distributing's business processes and applications within an area of expertise (e.g., Financials, Operations, Sales)Key Competencies
  • Able to communicate effectively with all levels of management in a clear and professional manner; verbally and written, Solid documentation and communication skills are an important success factor for this role as you will focus mainly on Supply Chain Management at Columbia Distributing and will support all aspects of data warehouse management.
  • People management and leadership skills
  • Excellent problem solving, decision making and analytical skills to meet changing business needs
  • Results oriented, ability to work independently, and work cross functionally in a fast-paced environment
  • Expertise designing, building, securing, and deploying, and processing Tabular and Multi-dimensional models, including Tabular Model experience designing for self-service
  • Advanced knowledge hands-on experience of Power BI and other Microsoft Power Platforms like Power Apps/Power AutomatePhysical Demands
    • Lift/Carry 50bs.
    • Bend/stoop/crouch/squat/use arms/wrists/hands/grasp
    • Sitting and working indoors for entire shift.Expected Hours of Work
      
      This is a full-time position. Days/hours of work vary and may include weekends overtime as necessary.
      
      Travel
      
      May be required to travel monthly up to 15% of the time.
      
      Required Education and Experience
      • Bachelor's degree in Computer Science / Computer Engineering or equivalent experience
      • Minimum of 5 years' experience with SQL Server database systems including complex warehouse design, experience with designing ETL extracts from various data sources
      • Minimum of 5 years Microsoft BI Stack (SQL Server, SSAS, SSRS, Power BI, Power Automate, Power Query, Power Pivot, etc.), including development of reports (RDLs, complex stored procedures, subscriptions, ETL packages using SSIS T-SQL queries)
      • Experience working with Azure Analysis Services, Dataflow, Power BI Embedded, Power BI Rest APIs
      • Expertise developing SSIS packages (ability to design, write and modify)
      • Expertise developing SSAS cubes and Tabular models (MDX/DAX Query Skills)
      • Minimum of 2 years of experience working with a self-service tool, preferably Power BI, Cognos Analytics, Tableau, or similar
      • Experience implementing row level security on data and understand application security layer models in Power BIPreferred Education and Experience
        • Experience integrating Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
        • Experience analyzing, recommending tuning steps, and implementing performance enhancements to optimize data model, data architecture, and business intelligence performanceCompensation
          • Actual compensation packages are based on a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, certifications, and specific location.
          • Employees (and their families) are eligible for medical, dental, vision, and basic life insurance. Employees are able to enroll in our company's 401k plan. Employees are also eligible for 80 hours of vacation every year and 7-8 days of paid holidays throughout the calendar year (depending on location).
          • Hired applicant may be eligible for incentives/bonuses/annual bonuses. Classification: Exempt
            
            Reports to: Director of IT
            
            Benefits
            • Paid Vacation and Sick Days*
            • Holiday Pay*
            • Competitive Health Insurance Plans (medical, dental and vision)*
            • 401(k) with company matching*
            • Short Term Disability and more*
            • Tuition Reimbursement
            • Employee Assistance Programs
            • Scholarship Programs
            • Corporate Events Discounts
              
              * Benefit may not be available for positions covered under an active CBA, seasonal, or part-time.
              
              AAP/EEO Statement
              
              Columbia Distributing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, religion, national origin, age, protected veteran status, disability status, or any other characteristic protected by law. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
              
              Please contact the Human Resources Dept. at (425)251-9300 or email recruiting@coldist.com if you have questions regarding reasonable accommodations.

Keywords: Columbia Distributing, Kent , Senior Business Intelligence Developer, IT / Software / Systems , Kent, Washington