Advent Global Solutions, Inc.
Location
Dallas, TX | United States
Job description
MS SQL Developer (SSIS/ SSRS) -Dallas/ Plano, TX- Long term contract (Onsite)
The Database Developer will be responsible for creating and maintaining database software to meet functional, performance, and availability goals. Additionally, the developer will be expected to support peers, follow standards, and make technical recommendations.
ESSENTIAL DUTIES AND RESPONSIBILITIES
include the following. Other duties and tasks may be assigned.
- Perform in an independent capacity and set a strong example for other database developers.
- Responsible for the development and management of Enterprise Data Warehouse / Data Lake processes and policies, following strategic direction on best practices for holistic Data Architecture.
- Design, develop, and implement MS SQL Server SSIS ETL jobs to effectively process high-volume data sources and meet nightly processing windows.
- Conduct analysis and design of data models for the development and maintenance of existing enterprise systems.
- Monitors industry trends and directions and develops and presents substantive technical recommendations to management.
- Work with users to define, implement and automate data warehouse requirements based on Microsoft SQL BI Stack.
- Build data structures, functions and views for source data integration, data management, and consumption by other systems
- Ability to communicate data modeling and process flow concepts, while tailoring solutions to business requirements
- Ability to interpret business logic and develop appropriate dataflows and data dependencies
- Understand and design system integration as required for extracting data for reporting purposes
- Ability to work with and communicate with a team of Developers/Analysts and non-technical Business Stakeholders.
- Design databases and ensure stability, reliability, and performance.
- Develop, test, and maintain Microsoft SQL database objects for CLIENT S software.
- Refactor existing database objects to support enhancements of system control, diagnostic and other research subject areas.
- Investigate and support new technology initiatives to improve or enhance current database capabilities.
- Prepare documentations for database applications and ETL processing.
- Learn new applicable programming techniques as needed.
- Work with other database personnel, front end programmers and customer support as needed.
- Be available, as needed, should critical software issues arise.
- Write documentation and SOPs for future use.
- Actively promote GUEST customer service standards; develop effective relationships at all levels of the organization.
- Participate in team concepts and promote a team effort; perform duties in accordance with company policies and procedures.
- Regular and reliable attendance is required for the job.
QUALIFICATIONS/REQUIREMENTS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
Requirements include:
- years of experience working with data in a healthcare related field - Clinical and Billing a plus
- years of experience writing reports against Microsoft SQL Server databases.
- 6+ years of experience with a source control system (e.g., GIT, SVN, TFS, etc.)
- Strong knowledge and experience writing T-SQL queries and Stored Procedures (i.e., correlated sub queries, inline SQL....)
- Experience with
- SSIS,
- SSRS,
- Tableau and other visualization tools,
- Creating and managing ETL processes
- Bachelor's degree in Computer Science, Information Systems, Health Care Administration, Business, or equivalent experience, preferred
- Strong ability to quickly understand complicated and highly normalized databases and reporting structures
- Critical thinking and analytical skills
SUCCESSFUL COMPETENCY FACTORS:
Use of the following skills: problem solving, analytical ability, effective communication, confidentiality. Interpersonal skills necessary to work with staff, senior management, insurance companies, government and private agencies. Multi-task in an efficient, professional and calm manner.
WORK ENVIRONMENT:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Minimal travel/overnight travel may be required. (up to 25% of time)
- Noise level in the typical work environment is moderate due to the number of staff in the business office area and staff/patients/equipment in patient care areas.
please send me your Updated word format resume with the end customers name which you supported with the below information for this role
Full Name :
Contact #
Current Location with postal code:
Email ID:
Visa Status ( needed Visa and DL Copies) :
LinkedIn, if so any :
Availability once confirmed for the project to start the project :
Last 4 digits SSN:
Skype ID:
Are you fine to work Onsite in Dallas, TX:
Can you attend inperson interview ( Y/N):
Rate/hr on W2 All Inc, kindly mention the rate with the Tax term:
DOB (MM/ DD):
A Small write-up why think an ideal fit for the above role :
SQL Development :
T-SQL:
SSIS:
SSRS:
3 Professional Managerial Level References, with their official email id and contact numbers:
Certifications if any kindly mention and attach the copy:
Best Time and Contact number we can reach you in business working hours:
Highest Education details with University Name, Year of Start and Passout :
Report this job
- Dice Id: agsinc
- Position Id: AGSSISITX
Job tags
Salary
