Enterprise BI Systems Analyst

JOB REQUIREMENTS: Summary Under general supervision, conduct business requirements review and independently formulate business approaches for providing business intelligence data warehouse management, data design, architecture, repository creation and information presentation. Work closely with business teams (Department Administrators, Accounting, Budgeting/Planning, Clinical Operations, Human Resources, Senior Leaders, etc.) and business intelligence staff to clarify and provide insight into integrating information to support business processes and business decisions. Support the overall information needs of the college in supporting strategic vision and goals. Assure information accuracy for all data presentation purposes. This role provides foundational support for the enterprise BI data warehouse, building and maintaining reports, data models, and analytical tools under the guidance of senior team members and BI leadership. Primary Responsibilities Data Integration & ETL Support Perform data migration and data integration tasks such as Extract, Transform, and Load (ETL) using SSIS or Qlik data modeling and scripting, limiting manual intervention whenever possible; develop SQL scripts for data acquisition and manipulation across SQL-compliant and other data sources. Work with senior Enterprise BI staff to ensure data integration tasks meet established accuracy and timeliness standards. Work with the Data Warehouse team to aggregate data as needed to support the creation of dimensions, facts, and data models. Business Requirements & Stakeholder Support Work with business users across administration, finance, human resources, clinical, research, and education to clarify and provide insight into integrating information that supports business processes and decisions. Understand and support business processes and informational needs, translating them into clear, written requirements. Coordinate data requirement gathering and support business information activities; support coordination with system-specific reporting teams, such as the Workday reporting team, under the direction of senior staff or the manager. Provide organizational support to operational leaders (administration, finance, human resources, clinical, research, and education) through internal data management, reporting, dashboards, and business analysis. Reporting, Cubes & Documentation Construct new and redesign existing SQL scripts and stored procedures, applying a working understanding of dimensions, facts, and data architecture. Construct new and redesign existing SSRS reports for deployment on the SQL Server Reporting Services... For full info follow application link. EEO/AA Minorities/Females/Vets/Disability The Medical College of Wisconsin is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, veteran status, disability or sexual orientation. ***** APPLICATION INSTRUCTIONS: Apply Online: ipc.us/t/91C814C8EF0E461F Qualified females, minorities, and special disabled veterans and other veterans are encouraged to apply.