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!
Skills Required
- Strong analytical and problem solving skills
- 3-5 years SSRS 2005/2008 experience
- 2-3 years SSIS 2005/2008 experience
- 1-3 years SSAS 2008 experience
- 3-5 years SQL Server 2005 & SQL Server 2008 experience
- Strong knowledge in writing stored procedures and functions
- Experience creating and modifying SSIS packages
- Experience creating and modifying SSRS reports
- Experience creating and modifying SSAS cubes
- Ability to write SQL scripts for ad hoc business requests
- Familiarity with Software Design, Requirements, and SDLC
- Experience analyzing information and data processing rules
- Excellent written communication skills
- Knowledge of Microsoft Office Suite
- Maintain confidentiality according to HIPAA standards
- Healthcare industry experience and advanced knowledge of claims, membership, and provider data
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
