SSIS/ SSRS Developer

Location

Dublin, OH | United States

Job description

SSIS/ SSRS Developer

BC forward is currently seeking a highly professional SSIS/ SSRS Developer

Title: SSIS/ SSRS Developer

Location : Remote

Duration: 12+ Month's

Must have Healthcare experience.

Job Description

POSITION SUMMARY (Briefly describe the purpose of the position): Under general direction, responsible for designing and/or creating, maintaining, deploying, and managing SSIS packages for internal business teams and our customers. Candidates will work collaboratively with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment. Escalate concerns to project management or Team Lead, assist in determining best practices and provide suggestions on how to improve current practices.



ESSENTIAL FUNCTIONS
* Duties and Responsibilities (List all essential duties and responsibilities in order of importance)
o Facilitates and/or participates in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data exchange.
o Ability to Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.
o Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
o Should be able to Design and guide other developers on complicated interfaces and should have strong debugging skills
o Ability to create design documents and understand business functionality
o Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
o Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations.
o Implement Database administration tasks like Scheduling and monitoring the ETL Jobs, Collated customer requirements, coordinated with different stakeholders.
o Work with customers, Business SME's and application development teams to understand requirements
o Proactively engage on continuous improvement efforts
o Experience diagnosing and resolving in incident tickets and errors
o Developed ETL specifications, data mapping and other documentation required for ETL development.
o Uses SQL, data models, data element dictionary and schema to perform data and business analysis
o This individual is responsible for understanding business data and performing quality assurance testing to ensure the data presented is correct.
o Create documentation and best practices
o Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers
o Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing
o At least 2-3 years of experience using Microsoft SQL Server Database, SSIS is required
* Knowledge, Skills and Abilities ( List all knowledge, skills and abilities that are necessary to perform the job satisfactorily)
o 4 to 5 years of experience using Microsoft SQL Server BI Suite and SSIS/SSRS
o 4 to 5 years of experience with MS-SQL scripting (required)
o 4+ years SQL Server version 2014 or higher (required)
o Experience in a Healthcare IT working with claims, member and provider data strongly desired.
o Analytical skills in a SQL environment
o Experience with QNXT or FACETS Healthcare Payer Platforms preferred
o Previous team leadership with analyzing, mentoring, monitoring healthcare plan data focusing on medical claim and financial processing member eligibility processing, provider networks and MCO contract details, auditing and reporting in compliance with Federal and State requirements
o Knowledge of Payment Reform methodologies under the Affordable Care Act and related initiatives in the Medicaid space
o Ability to build complex queries and reports using Microsoft SQL.
o Analytical and data analysis skills using Microsoft SQL (required)
o Healthcare knowledge within a claims processing environment preferably in Medicaid
o Excellent verbal and written communication skills
o Ability to abide by Gainwell policies
o Ability to maintain attendance to support required quality and quantity of work
o Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
o Ability to establish and maintain positive and effective work relationships with coworkers, clients, and customers

About BCforward:

BC forward began as IT business solutions and staffing firm. Founded in 1998, BC forward has grown with our customer's needs into a full-service personnel solution organization. Headquartered in Indianapolis, Indiana, BC ,forward also operates numerous delivery centers across North America and India. We are currently the largest consulting firm and largest MBE-certified firm in Indiana. Our uninterrupted growth has allowed BC forward to deliver uniquely configured IT staffing and project solutions for over years of catering to our customer's specific needs. BC forward currently maintains a team of over 5000 global resources. With our additional brand, Stafforward, together we have the capabilities to deliver services for a variety of industries in both public and private sectors which allows us to address your most challenging needs.

This posting is not an offer of employment. All applicants must be authorized to work in the United States and willing to cooperate with a background check and drug screen, to the extent permitted by federal and local laws up to, and including both criminal and financial reviews. The submission of intentionally false or fraudulent information in response to this job posting shall render the applicant ineligible for the position. BCforward is an equal opportunity employer. Any subsequent offer of employment shall be considered employment at will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 202015 when responding to this ad.

Job tags

Salary