Business Intelligence/SQL Developer

Atria Group LLC; Fort Worth (TX); On-site; USD 70,000 - 100,000; Full time

Job summary

Atria Group LLC seeks a full-time BI Developer responsible for creating and modifying SQL scripts, stored procedures, and BI reports. This role entails collaboration with various teams and problem-solving in a healthcare context. Ideal candidates will have proven SQL Server experience and strong analytical skills.

Qualifications

• 3 - 5 years experience with SSRS 2005/2008.
• 2 - 3 years experience with SSIS 2005/2008.
• Strong knowledge in SQL Server 2005 & 2008.

Responsibilities

• Creating and modifying stored procedures, functions, and SSIS packages.
• Writing scripts using SQL for business ad hoc requests.
• Creating and modifying SSRS reports and SSAS cubes.

Skills

Analytical skills

Problem solving

Writing stored procedures

SSRS

SSIS

SSAS

SQL Server

Excellent Written Communication

Tools

Microsoft Office Suite

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.

Qualifications

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