IT Business Intel Architect

Provide reporting expertise to all areas (Financials, Sales, Operations, Procurement, etc.) & act as the technical consultant pertaining to reporting packages within the company. Position may perform any of the following tasks: analyses, research, pre-packaged software configuration, design, coding, testing, debugging, implementing, training, documenting & maintaining reporting applications.

Major Duties & Responsibilities

· Work with stakeholders to understand the organization's data needs & establish a roadmap for Business Intelligence (BI) solutions aligned with business goals. Develop efficient data models, including star schemas, snowflake schemas & data marts, for data warehousing & business intelligence. Implement data validation, cleansing & auditing processes to ensure the accuracy & reliability of data. Monitor & optimize BI solutions performance to prevent slowdown or failures.

· Manage BI projects from beginning through implementation, ensuring timely delivery & adherence to scope. Implement new information while the internal company customers are still performing their normal business functions.

· Quality test report coding &/or setup configurations. Ensure work has been thoroughly tested by the individual, team member or end user prior to installation.

· Collaborate with various teams (i.e., business units, data analysts, IT, etc.) to understand their data needs & deliver BI solutions. Provide training & support to BI users to ensure they understand how to access & interpret the data. Help mentor junior members of the team.

· Safety, protect company reporting assets, maintain network & server security.

Qualifications

· Bachelor’s degree in a related field required.

· 5 – 8 years’ experience as a programmer/analyst preferred.

· Reporting software preferred (Oracle’s Transactional Business Intelligence (OTBI) & BI Publisher Reports, Fusion Data Intelligence).

· Data warehouse experience preferred.

· Programming skills; SQL, PL/SQL procedural language.