**Job Title:** Business Intelligence Engineer - Intermediate **Job Family:** Information Technology **Job Code:** 120 **Date Created/Updated** : January 2022 **Summary:** **BI Engineer** The salary range for this role is $90k to $108k Annually 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 a_ _n_ _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._