Business Intelligence Developer

Role Overview

• Report Creation
• Create, test, implement and maintain reports and ad-hoc queries providing actionable information necessary to support business or customer requirement.
• Identify data needed to provide the desired output.
• Design and develop analytic and reporting solutions appropriate for Business Intelligence platform.
• Fine tune reports and dashboards for optimal performance.
• Assist with issue resolution and end user support.
• Be efficient with BI reporting tools.
• Use the latest techniques in the industry to make the reporting process efficient which includes but is not limited to automation, speed, aesthetic designs and reducing complexity.
• Business Analysis
• Work with the business to analyze data and understand business and reporting needs.
• Translate the requirement into technical specifications.
• Communicate status reports/important findings to management and decision-makers.
• Work to achieve standardized business reports and data across the organization or for customers.
• Perform data analysis on analytical and reporting requirements and recommend solutions for development.
• Data Model / Extraction Integration
• With guidance from BI Dev 2 and BI Dev 3, build, enhance, and support data modeling and extraction of data elements from multiple internal or external databases to meet business or customer reporting requirements.
• Design and build data load process taking all dependencies into consideration.
• Support data loading and extraction processes including ensuring optimal performance.
• Recommend and develop new metrics that may benefit the company or customers.
• Research, Training, and Self Study
• Perform on going self-study of job-related issues.
• Conduct and/or attend both formal and informal departmental and computer training.

Requirements

• Less than 2 years related experience
• Bachelor’s degree (Computer Science, MIS or related field)
• Non-degree considered if 12+ years of related experience along with a high school diploma or GED
• Occasional travel (0-5%)
• Occasional overnight stays (0-5%)
• Sit 8 hours and stand 0 hours.
• Typical office environment (low noise level, limited exposure hot/cold temperatures, dust, fumes, and vibrations).
• Regular interaction with others and performs a degree of independent work.
• Physical and mental demands are akin to the majority of office positions with prolonged periods of sitting and prolonged use of a computer/keyboard.
• Infrequent lifting, walking and climbing stairs.
• Occasional use of office equipment (copiers, printers, etc.).
• Good written, verbal, analytical and interpersonal skills.
• Experience with SAP system configuration and administration desired or with advanced visualization tools such as SSRS, Tableau or Power BI.
• Experience developing custom and complex queries in SQL for reporting needs.
• Understanding of Microsoft SQL Server and SSIS development.
• Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.
• Good understanding of SQL with familiarity with creating custom DAX expressions/functions.

Tech Stack

• MS SQL Server
• SQL
• SSIS
• Tableau

Benefits

• Health/Dental/Vision/Prescription Drug Plan
• Flexible Benefits Plan
• 401K Retirement Savings Plan
• Life and Disability Benefits
• Paid Parental Leave
• Paid Holidays
• Paid Vacation
• Tuition Reimbursement
• and much more.