Business Intel Technical Lead

JOB REQUIREMENTS: Business and Data Analyst capabilities with 10 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected. Reviews, analyzes, and evaluates business systems and user needs. Provide support for database/dataset inventories. Analyze the logical and physical database models and ensure data models / data dictionaries are up to date. Generate and prepare meta data linking datasets to associated business processes. Senior role that has responsibility supporting the analysis and documentation of data asset inventories for existing software and systems. This role will be assisting with system transformation efforts ensuring that business processes are properly mapped to supporting system data assets. When data inventories are identified, this role will work with subject matter experts, SME\'s, from the business and technology teams to document links between the assets and business processes. Additionally this role may be asked to work with SME\'s to update data dictionaries and document important meta data associated with the assets that will streamline system transformation from existing mainframe based systems to a web based system. This role also load datasets into relational databases creating table structures to link and cross reference data assets with reports, applications, interfaces, batch processes and their associated business processes. Good oral and written communication skills are required. This position currently offers the option to work up to 100% remote, this could change to 100% in house. On-site at the Madison Yards Way, 4822 Madison Yards Way, Madison, Wisconsin. ***** OTHER EXPERIENCE AND QUALIFICATIONS: QUALIFICATION MUST HAVE 10+ years of experience relational databases, and Structured Query Language (SQL). 10+ years of experience documenting and understanding complex business and data relationships, through Entity Relationship Diagrams (ERDs). 5+ years of experience developing and understanding ETL for data transformation. Demonstrated communication experience, working with business and technical teams. Experience with Tableau Experience with Business Objects IBM DB2 experience In depth experience creating and maintaining ERD\'s in the ERWIN tool. NICE TO HAVE SKILLS: Tech Writing, with an emphasis on communicating between the business and technical needs of a cross functional project team. Experience using data modeling tools (ex: ERwin) and understanding Entity Relationship Diagrams, ERDs, and data modeling MS SQL Server Oracle ***** APPLICATION INSTRUCTIONS: E-Mail a Rsum: joannem@cci-worldwide.com