BI Engineer

Job Title: Business Intelligence Engineer - Intermediate

Job Family: Information Technology

Job Code: 120

Date Created/Updated:  January 2022

Summary:

The BI Engineer Intermediate is responsible for building, implementing, and supporting enterprise data solutions. The right individual will possess experience in all stages of project delivery and support (requirements, logical and physical design, implementation, testing and deployment). The BI Engineer Intermediate should have a firm grasp of BI/Data Warehouse technologies and will have had in-depth experience with the Microsoft BI Stack (SQL, SSIS, SSRS and SSAS). 

Duties and Responsibilities:

• Participate in data gathering, research, and analytical abilities to develop insightful conclusions and generate solutions to address user needs.
• Collaborate with cross-functional teams for effective delivery and support of data solutions.
• Create written communication materials that effectively summarize findings and support recommendations.
• Contribute to quality assurance and user acceptance testing strategies by writing test plans and participating in the execution of testing (Unit and UAT).

Education and Experience:

• 3+ years Business Intelligence experience.
• BA/BS degree in computer science, information technology, engineering, or related experience.

Required Skills:

The BI Engineer Intermediate should possess proven understanding and expertise in various BI technologies. The engineer must have demonstrated experience with the Microsoft BI stack; exposure to other technologies is a plus (HaloBI, PowerBI, Tableau, Oracle, SAP BW, SAP Business Objects, etc.). 

Competency Requirements

• 3+ years of database design and integration experience with SQL Server databases.
• Relational Database and SQL language experience.
• Extraction, Transformation and Loading (ETL) experience (Microsoft SSIS).
• Analytics/OLAP Cube development experience (Microsoft SSAS).
• Report development experience (PowerBI).
• Working knowledge of project management methodologies and best practices (Agile).
• Query/Solution performance tuning and optimization.
• Troubleshooting and incident resolution.
• Strong verbal and written communication skills.

Preferred Skills

• Multi-Dimensional Expression (MDX) development experience.
• Understanding of Master Data Management concepts.
• Experience with heterogenous data integration methodologies such as transmitting JSON/XML data via a REST API.
• C# programming experience.
• Experience with cloud technologies (Azure, AWS, Snowflake, etc.).

*This is an exempt role, paid a salary wage. This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting.  We may ultimately pay more or less than the posted range, and the range may be modified in the future.  An employee’s pay position within the salary range will be based on several factors including, but limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, any collective bargaining agreements, and business or organizational needs. Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.