Business Intelligence Architect

Full Time
Chicago

West Monroe Partners is looking for an experienced Business Intelligence Architect to join our Integration team in the Chicago office.

Key responsibilities and accountabilities include:

- Provide 'data management expertise’ to our clients in evaluating requirements and developing solution design proposals. Data management includes appropriate stewardship of data, semantics/syntax of data attributes, coding structures, and mapping schemes.
- Develop databases within the Data Warehouse (schema, indexes, etc).
- Develop ETL mappings, procedures, schedules etc.
- Develop export procedures for data sources, ensure data is fed to data warehouse through network and ensure scheduled tasks run properly.
- Coordinate activities with data source application owners to ensure integration within data warehouse and that data integrity issues are addressed.
- Liaise and attend meetings necessary to perform duties and aid business and technical development.

 

- Bachelor’s Degree
- The ideal candidate will have 5 + years of hands-on professional experience.
- Excellent organizational, verbal and written communication skills
- Travel requirements: up to 50 %
- Very strong technical knowledge in ETL tools (Informatica, PL/SQL, Microsoft DTS), Databases (Oracle), work alone or in conjunction with a DBA.
- Has good knowledge of standard concepts, best practices, and procedures within a Business Intelligence environment.
- A certain degree of creativity and latitude is required as well as flexibility in job role and working hours during critical deliveries
- A natural sense of urgency, initiative and a positive team player philosophy to be reflected in daily work ethics.

West Monroe Partners is an Equal Employment Opportunity Employer -
We believe in treating each employee and applicant for employment fairly and with dignity. We base our employment decisions on merit, experience, and potential, without regard to race, color, national origin, sex, sexual orientation, gender identity, marital status, age, religion, disability, veteran status, or any other characteristic prohibited by federal, state or local law.

Julie Meyer
Phone: 312.602.4000
Email: West Monroe Recruiting