Business Intelligence Developer

GENERAL SUMMARY: We are looking for an experienced Business Intelligence (BI) Developer to join our team As a Business Intelligence (BI) Developer, you will be responsible for engineering, management and strategic planning. A BI Developer who designs, develops, and maintains business intelligence solutions, including data analytics platforms and reporting tools. They translate business needs into technical specifications and create visualizations and reports. Proficiency in database management systems and BI technologies is required. These include dashboards, data visualizations, regular and impromptu reports, and data querying tools for users to the information they require.

ESSENTIAL FUNCTIONS:

• Designing and developing business intelligence solutions
• Writing and testing requirements
• Developing and maintaining data processing
• Implementing and maintaining databases
• Maintaining and improving tools for system analysis
• Collaborating with other teams to meet the needs of customers
• Perform SQL queries - design, code, test, and aggregate the results to create useful information
• Write technical documents on database content
• Map various databases used in the organization
• Develop, design, and analyze data architecture and data warehouses
• Assesses current and future data processing needs for the company.
• Translate business needs to technical specifications
• Design, build and deploy BI solutions (e.g. reporting tools)
• Maintain and support data analytics platforms
• DB/DBA background
• Business analysis skills
• Debugging/troubleshooting skills
• Create tools to store data (e.g. OLAP cubes)
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requested projects
• Develop and update technical documentation
• Maintains contacts with all user departments, software/hardware vendors, and other systems representatives.

SUPERVISORY RESPONSIBILITIES: There are no supervisor responsibilities with this position.

QUALIFICATIONS: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. (The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)

• Minimum of a Bachelor's Degree in Computer Science or Information Systems
• Minimum of 3 years of experience in BI development
• Experience with large data sets, dimensional modeling
• Experience with business intelligence tools
• Strong analytical skills
• Experience with automated testing
• Experience with writing complex queries
• Understanding of SQL and relational databases
• Strong knowledge of data analysis and visualization
• Strong knowledge of ETL and data modeling
• Ability to work in a fast-paced environment
• Strong experience with debugging and issue resolution
• Strong attention to detail
• Works in a strong team environment.
• Ability to maintain a fair, consistent set of standards as they apply to work force.
• Adjust priorities and manage time wisely in a fast-paced environment.
• Strong communication skills in order to describe complex technical information to the non-BI developers in the company. Therefore, being able to communicate clearly and effectively is also an extremely required skill in this field.
• Ability to read and interpret documents such as computer documentation, hardware operating and maintenance instructions, and procedure manuals. Ability to write business reports and correspondence. Ability to speak effectively before groups of managers, vendors and employees of the organization.
• Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret and extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
• Problem solving skills required.
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Expertise with BI technologies (e.g. Microsoft Power BI)
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Experience with JET Reporting Services

EDUCATION AND/OR EXPERIENCE: Bachelor's Degree (B.S/B.A.) in Computer Science or equivalent for four-year college or technical school. Requires knowledge and skill in current technologies used by the company or equivalent combination of education and experience.

LANGUAGE SKILLS: Ability to read and comprehend instructions, correspondence, and memos. Ability to prepare routine reports and correspondence. Ability to communicate effectively with customers, vendors and other employees of the organization. Requires excellent grammar and spelling.

Mathematical Skills: Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra and geometry.

Reasoning Ability: Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

Certificates, Licenses, Registrations: Requires a valid driver's license.

Other Skills and Abilities: Requires the ability to operate a variety of standard office equipment, such as a computer and keyboard, calculator, fax, photocopier, telephone, cell phone, etc. Requires proficiency with Microsoft Word, Excel, Outlook and PowerPoint.

physical demands: (The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)

While performing the duties of this job, the employee is regularly required to sit and use hands to finger, handle or feel. The employee is frequently required to climb stairs, talk and hear. The employee is occasionally required to stand; walk; reach with hands and arms; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, and ability to adjust focus.

Work Environment: (The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)

The noise level in the work environment is that found in a normal office environment; noise levels during visits to other locations in the building may be moderate and occasionally loud. The employee occasionally performs work related to travel.

The above statement reflects the general details necessary to describe the principle functions of the occupation described and shall not be construed as a detailed description of all the work requirements that may be inherent in the occupation.