Business Intelligence/SQL Developer
AtriaGroupLLC
Posted: January 9, 2014
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
The Business Intelligence/SQL Developer is responsible for creating and modifying stored procedures, functions, scripts, and SSIS packages to load, transform, and map data from various sources to MSSQL Server databases or other databases as needed. The ideal candidate should have experience in developing business intelligence solutions and be proficient in SQL, SSAS, and SSRS. Strong communication and collaboration skills are also essential for working with cross-functional teams.
Required Skills
Job Description
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.
Skills/Qualifications:
• 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
Apply today!