Business Intelligence Developer
Click the Facebook, Google+ or LinkedIn icons to share this job with your friends or contacts. Click the Twitter icon to tweet this job to your followers. Click the link button to view the URL of the job, which then can be copied and pasted into an e-mail or other document.
Chicago, IL 60664
Business Intelligence Developer
Active Regular FT (72 to 80 hours per pay period)
Business Intelligence Developer
The Business Intelligence Developer designs, develops, tests and maintains reporting and analytic solutions for Rush Health, an organization whose members include Rush University Medical Center, Rush Oak Park Hospital, Rush Copley, Riverside Kankakee and approximately 1000 physicians who are on the medical staff of its hospital members. The BI Developer will work with Business Intelligence Lead Analyst and internal customers to understand and analyze requirements and develop BI solutions using Microsoft Business Intelligence tools and underlying technologies. The successful candidate must demonstrate critical analysis skills and a clear understanding of BI and Data Warehouse operating environments and related technologies.
+ Develop OLAP Cubes to meet business requirements
+ Work with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI cubes, reports and applications.
+ Develop using MDX to query OLAP Cubes, to support current and upcoming projects.
+ Utilize Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced development methodologies.
+ Develop SSIS Packages to handle ETL requirements to support EDW and Analytics Development
+ Design and develop ETL components that meet business requirements.
+ Define and maintain Source and Target Data sources
+ Understand, define and develop data mapping and transformation rules
+ Develop Dashboards and “drill-down” reports
+ Use Microsoft technologies to develop “drill-down” dashboards.
+ Develop web-based business dashboards as required, working with web development team.
+ Troubleshoot implementation issues, test security of roll-out.
+ Requirements Gathering, Analysis and Documentation:
+ Serve as a key member of cross-functional teams in order to achieve goals of BI and IT projects, including work plans, system design and testing of solutions.
+ Develop data flow diagramming for BI reports and projects of moderate complexity.
+ Develop and assist in managing project plans to achieve projects.
+ Identify project risks and impediments, notify management, and proactively work with other members of the team to complete assigned tasks as defined by project scope, timelines, and budgets.
+ Technical Support of BI Development:
+ Support technical development of BI reports, applications and other tools.
+ Read and interpret conceptual, logical, and physical models to include context, data flow, process flow, logical diagrams, and data dictionaries. Read and interpret design documents.
+ Perform complex data queries and mapping. Understand data modeling concepts (e.g., the entity-relation model) and their application: entities and tables, relations and constraints, attribute data types and column data types.
+ Write, validate, and execute test plans for solutions, applications and/or operating systems.
+ Ensure a high level of availability for all critical reports and applications.
+ Ensure overall security of reports and applications. This includes developing an understanding of Rush Health’s security standards and testing to ensure they are integrated in all reporting and BI tools.
+ Assist in updates and upgrades of BI software.
+ Evaluate and analyze utilizes and tools offered by BI applications / tools vendors
+ Data Profiling and Quality Assurance:
+ Run data profiling analysis to support report and application development.
+ Provide feedback on data quality (to the RHA Data Sourcing team, as well as to source entities) and regularly evaluate the impact of data quality issues on the end reports and end users.
+ Develop an understanding of and help support master data needs and how it is developed and managed.
+ Participate in writing data cleansing specs, identify root causes for dirty data, and facilitate negotiations between various constituent groups to develop and implement solutions to remediate any data concerns.
+ Assist project sponsors in the interpretation and use of the results; ensure that the data is understood by users.
+ Prepare supporting documentation, reports and presentation materials.
+ Coordinate prototype review, integration, system, and user acceptance testing (UAT).
+ Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests. Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
+ Develop health care subject matter expertise related to specific products, data elements, business processes, data marts, and BI applications.
+ Demonstrate basic understanding of the strategic alignment of IT solutions with business objectives
+ This will be demonstrated by accuracy and efficiency in developing BI projects, as well as demonstrated expertise through continuing education through Rush Health or other sources.
+ Share knowledge with co-workers and ensure appropriate knowledge transfer to cover duties during illness, vacations, training, etc.
Position Qualifications Include :
+ Minimum of a BS degree in Computer Science or related degree / experience required.
+ Minimum 5 years of experience in the IT industry with at least 2 years of hands-on continuous work experience in developing Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft SSRS, SSAS, and MDX in a data warehousing environment.
+ Demonstrated experience in requirements gathering and using relational databases
+ Two (2) years of experience with medical claims/clinical data is preferred.
+ Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
+ Good visual aesthetic sense relative to report development and presentation to the user.
+ Excellent written and verbal communication, facilitation, and customer facing skills
+ Must have a strong customer service orientation and excellent organizational skills.
+ Demonstrated success working in a team-based environment.
+ Must have experience in the Microsoft data warehouse and business intelligence solutions including SSRS, SSAS, and MDX. Equivalent experience (e.g. Cognos, Business Objects, and OBIEE) will be considered.
+ Understanding of Microsoft Analysis services, with MDX, DML and data mining capabilities is required. Advanced knowledge of and OLAP/MOLAP technologies, including applicability to various reporting problems, is preferred.
+ Expertise in building cubes and programming complex SQL queries and stored procedures.
+ Programming SQL queries and stored procedures required.
+ Ability to provide high quality code for production use.
+ Minimum of 3+ years of hands-on experience with MS SQL Server 2005/2008/2012 required.
+ Experience in visualization tools like Tableau and Qlikview is strongly preferred.
+ Knowledge of Web Services preferred.
+ Very familiar with Visual Studio and BI studio. Proficiency with MS Office and Visio is desired.
**Rush Health Highlights: