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.

Requirements

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.