Our job openings are designed to give you the best working experience in an ideal
learning environment.
~Business Intelligence Developer
POSITION DESCRIPTION
The Business Intelligence Developer is responsible for design, development, testing, maintenance, and support of reporting solutions. This individual will work with Business Intelligence Analysts 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 a clear understanding of BI and Data Warehouse operating environments and related technologies.
RESPONSIBILITIES
* Work with project lead, analyst, and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
* Develop parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web deployment.
* Utilize Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced development methodologies.
* 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.
* 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.
* Determine testing needed to assure the functionality and integrity of reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary.
* Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.
* Assist in configuration and upgrades of BI software.
* Participate in evaluating and analyzing utilities and tools offered by BI applications/tools vendors.
* Share knowledge with co-workers and ensures appropriate knowledge transfer to cover duties during illness, vacations, training, etc.
* Prepare technical documentation.
QUALIFICATIONS
* Bachelors degree, preferably in Computer Science (equivalent professional experience considered)
* Minimum 5 years 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.
* 3+ years of hands-on experience with MS SQL Server 2005/2008.
* Advanced knowledge of and OLAP/MOLAP technologies and dimensional modeling, including applicability to various reporting problems.
* Expertise in building cubes and programming complex SQL queries and stored procedures.
* Recent programming experience with ASP.Net, JavaScript, and XML 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).
* Proficiency with MS Excel, Access, Visio, and Project is desired.
* Professional experience in successfully supporting applications
* Experience in gathering and analyzing business requirements.
* Use Cases, Storyboarding/Iterative presentation layer development skill set
* Ability and past experience producing technical documentation
* Good written / oral communication skills.
* Demonstrated success working in a team-based environment.
* Two (2) years experience with medical claims/clinical data is preferred.