Best Friends Animal Society
  • 312- Enterprise Data
  • USA
  • Salary
  • Full Time

Join Best Friends and turn your career into a labor of love. The benefits package is one of the best! Medical, Dental, Vision, Basic and Supplemental Life Insurance, Short and Long Term Disability, Child Care reimbursement, Pet Sitting reimbursement, Flexible Spending Account, Health Savings Account, PTO, Paid Holidays, Employee Assistance Program, 401k and Staff Discounts.

Location: Kanab, UT or Remote

Position Summary: The Business Intelligence (BI) Software Engineer II's role is to strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. The Business Intelligence Software Engineer II is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.


Strategy and Planning 5%:

  • Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.

Acquisition and Deployment 10%:

  • Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
  • Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.

Operational Leadership 25%:

  • Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
  • Lead the integration efforts for merging BI platforms with enterprise systems and applications.
  • Work with project managers to ensure that data entry, retrieval, change, and delete functions meet business requirements for project completion.
  • Conduct job duties and responsibilities according to the organization's business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
  • Monitor alerts and troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
  • Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
  • Mentor and/or provide leadership to junior members of the team.

Engineering 50%:

  • Design, code, test, and document all new or modified BI systems, applications, and programs.
  • Develop the semantic layer, metadata, reports, and report definitions.
  • Develop graphs, dashboards, and portal interfaces.
  • Design databases, data models, data marts, and data warehouses.
  • Analyze user requirements and, based on findings, design functional.
  • Design and deliver end-user training and training materials; provide technical support as necessary.
  • Build specifications for BI front-end applications based upon user requirements.
  • Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.

Information Security 10%:

  • Develop, test, and implement best practices within the BI ecosystem to ensure sensitive information is protected and only available to those with a need and the appropriate approved access to view the information.

Skills & Experience:

  • A Bachelor's degree in computer science, information systems, computer engineering, or a related field or equivalent experience.
  • MCSE: Business Intelligence certification and/or Tableau Desktop certification a plus.
  • A minimum of 2 years of experience in developing BI and OLAP solutions.
  • Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling.
  • Experience with one or more tier-one applications, databases, and data warehouses, such as Oracle, MS SQL Server, Crystal, SAP, IBM Cognos, and so on.
  • Expertise in the MS BI Stack, including SQL, SSIS, SSRS, SSAS, BIDS/SSDT, and SPS.
  • Expertise in the Tableau Desktop and Tableau Server BI environments.
  • Expertise in developing and performance tuning SQL and T-SQL.
  • Demonstrated ability designing and building ETL plans using MS SSIS.
  • In depth understanding of the SSRS environment including configuration and debugging.
  • Demonstrated ability designing and building Reports and Dashboards using SSRS and SPS, data visualizations in Tableau, and cubes using SSAS.
  • Strong ability to analyze user requirements and build data models and BI applications according to specifications.
  • Strong understanding of relational database structures, theories, principles, and practices.
  • Strong understanding of OLAP structures such as Star Schemas and cubes.
  • Experience with Enterprise CRM environments and databases, preferably with Blackbaud CRM.
  • Experience with Agile methodology and Team Foundation Server a plus.
  • Experience working with AWS data technologies such as Aurora, Athena, Red Shift, or Glue.
  • Proven customer focused approach
  • Exceptional written and verbal communication skills and the ability to explain technology in nontechnical terms.
  • Exceptional analytical, conceptual, and problem-solving skills.
  • Able to prioritize and execute tasks in a fluid and highly visible environment.
  • Experience working in a team-oriented, collaborative environment.

Physical Requirements:

  • Able to work at a computer for extended periods of time with repetitive typing, arm and hand motion.
  • Able to occasionally work outside of normal business hours for support and deployment activity.
  • Able to participate in on-call rotation as necessary.


Thank you for your interest in pursuing a career at Best Friends Animal Society. Best Friends Animal Society is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to their race, religion, ancestry, national origin, sex, sexual orientation, age, disability, marital status, domestic partner status, or medical condition.

Best Friends Animal Society
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share This Page
  • Facebook Twitter LinkedIn Email
Logo Donate One Time Monthly In Memory In Honor About Our Work Events The Sanctuary Stories Resources Adopt Ways To Give Home About - lower navigation Careers