Business Intelligence Developer

Job Summary: The IT BI Developer reports to the Project Manager as part of the Information Technology team. This role develops, maintains, and provides production support for the Data Warehouse and WebFocus BI Tool, used throughout the company.  This role works closely and collaboratively with other Software Engineers and with the Project Management resources on the IT team, such as the IT Development Manager, Business Analysts, and Quality Assurance Analysts, along with business users from all At Home departments to design, develop, implement, and support all system solutions related to the Business Intelligence needs.

 

Key Roles & Responsibilities: 

• Monitor internal work orders, and related external ticketing systems, for assigned tasks related to the support of the corporate application systems.
• Follow established procedures to meet SOX compliance requirements.
• Provide Level of Effort estimates and timelines to assist Project Management with setting delivery dates on Production Support issue resolution and Enhancement deployments. 
• Author functional and technical design documentation.
• Apply enterprise standards, policies, patterns and reference architectures to all solutions.
• Promote the use of shared applications and reusable components to reduce costs and improve information flows.
• Manipulate large data sources to transform data into business information that will help management fulfill strategic business objectives 
• Develop interactive tools that provide highly effective ‘scenario’ analysis for various key users
• Construct complex SQL queries and work with other data extraction, reporting and analytic tools to support the development of Ad Hoc queries and reports 
• Design and maintain highly complex data/databases  including but not limited to designing of complex logical/physical databases
• Build reports and set up databases to optimize the performance of the Data Warehouse while maintaining security and integrity of the data
• Engage in code review of changes made by peer developers.
• Collaborate with infrastructure support personnel to define operational aspects of business solutions (security, network, integration, etc.)
• Unit test new and modified applications.
• Assist QA resources with the definition of test cases and setup of test scenarios for QA and UAT testing.
• Define deployment and backout plans, and schedule implementations.
• Oversee the deployment and monitoring of application changes.
• Provide production support of applications, including after hours on-call support.
• Monitor and summarize progress of work orders for management.

 

 

Qualifications:

• Organizational skills, including the ability to prioritize and control job responsibilities in order to meet deadlines and an environment with overlapping and potentially conflicting priorities.
• Working ability to remain effective under stress, and respond to pressure in a manner acceptable to others and the organization.
• Ability to remain flexible and adapt to changing priorities with promptness, efficiency and ease.
• Proficient ability to communicate effectively with others using written and spoken English, including the ability to provide clear, constructive direction and feedback to team members.
• Understanding of change management strategy and practice.
• Ability to manage disagreements through consensus building, relationship management and the formation and presentation of logical, data and fact-based arguments.
• Bachelor’s degree from an accredited program in Information Systems, Computer Science or related field or equivalent year-for-year experience required.
• Three or more years of experience designing, developing, implementing, and supporting BI applications. 
• Two years of experience with WebFocus
• Experience with SQL-based technologies across multiple databases 
• Experience with SQL Server Integration Services (SSIS)
• Retail industry experience preferred, especially related to any of the following areas: store operations, warehouse distribution, store allocation, merchandising, marketing, accounting, and finance.