Business Intelligence/SQL Developer

Full time job opportunity: MS BI - Business Intelligence / SQL Developer

The BI Developer has primary responsibility for creating and/or modifying all the needed stored procedures, functions, scripts, and SSIS packages to load, transform, and map the data from several sources to MSSQL Server databases or the other way around as needed. Also, creating and modify SSRS reports, dashboards, and SSAS cubes. The individual also has significant interaction with Software Development, Quality Assurance and Data Processing. These interactions may include, but are not limited to, leading and facilitating meetings, working with colleagues to identify data and information needs.

Duties ( but are not limited to):

• Creates/modifies all the needed stored procedures, functions, schemas, and SSIS packages
• Creates/modifies all the needed SSRS reports and SSAS cubes.
• Writes scripts using SQL to answer the business ad hoc requests.
• Recommends controls by identifying problems and writing improved procedures.
• Maintains system data protocols by writing and updating procedures.
• Maintains client confidence and protects operations by keeping information confidential according to HIPAA standards.
• Identify enterprise-wide data needs and assessing data integrity and analyzing data gaps.
• Collaborates with business units and employs iterative methodologies to meet and exceed client expectations.
• Passion for problem-solving and managing multiple priorities.
• Data analysis for eligibility, medical and Rx claims, provider, and utilization data
• Contributes to team effort by accomplishing related results as defined by established priorities and internal timeframes.

• Within the IT Industry, the ideal candidate will possess the following skills/qualifications:
• Strong analytical and problem solving skills
• 3 - 5 yrs. SSRS 2005/2008 experience
• 2 - 3 yrs. SSIS 2005/2008 experience
• 1 - 3 yrs. SSAS 2008 experience
• 3 - 5 yrs. SQL Server 2005 & SQL Server 2008
• Strong knowledge in writing stored procedures, functions.
• Software Design and Documentation
• Software Requirements
• Software Development Life Cycle
• Analyzing Information & Analyzing Data
• Data processing rules
• Excellent Written Communication
• Knowledge of Microsoft Office Suite
• The ideal candidate will have a record of success with problem-solving and managing multiple priorities.
• Healthcare industry experience and advanced knowledge of claims, membership, and healthcare provider data is a plus