esign, model and develop complex data models and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems : Participate in planning and implementing the data integration and data migration activities. : Coordinate with team members to perform database programming based on project requirements. : Develop stored procedures, complex SQL queries, scripts and database programming for systems. : Perform quality assurance tests for ensuring data integrity across multiple databases. : Interact with project leaders to understand project requirements. : Provide valid inputs in database architectural discussions. : Assist in identifying process improvements for database performance, reliability and stability. : Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. : Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and MS SQL Server by using SSIS services and transformation objects : Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies.Job Level Specific Duties• Entry-level position into business systems analysis.• Provides end user support for a specific application while learning about the application and customer. • Assists in application implementations and assists in testing end user processes using defined guidelines. • Updates existing tables and verifies the accuracy. • Collects data and runs basic reports in response to client inquiries as directed by more senior associates. • Interacts with clients, both internal and external, to supply basic information. • Analyzes business and user needs, documenting requirements, with the guidance of a senior associate.• Documents business rules/functional requirements to support system enhancements with the guidance of a senior associate.• Logs and tracks basic problems / work tickets with external product vendors or support organizations.Typical Years of Experience• Typically requires 2-4 years relevant experience.Minimum Education and Certifications• Undergraduate degree or equivalent combination of education and work experience.Skills• Awareness of system development methodology, project management and system architecture. Basic analytical / problem solving skills. • Ability to consider IT and business challenges.• Influencing and communication skills. Ability to translate between non-technical business users and technical IT resources. Strong client service attitude.• Organizational and time management skills.Physical Requirements/ Working Conditions• Ability to physically perform general office requirements. • Must be able to perform essential responsibilities with or without reasonable accommodations.• Significant travel including overnight domestic or international trips may be required.SQL Server 2016SSIS 2016Design, model and develop complex data models and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems : Participate in planning and implementing the data integration and data migration activities. : Coordinate with team members to perform database programming based on project requirements. : Develop stored procedures, complex SQL queries, scripts and database programming for systems. : Perform quality assurance tests for ensuring data integrity across multiple databases. : Interact with project leaders to understand project requirements. : Provide valid inputs in database architectural discussions. : Assist in identifying process improvements for database performance, reliability and stability. : Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. : \Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and MS SQL Server by using SSIS services and transformation objects : Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies.Requirements:4-5 years of SQL experience writing queries, stored procedures, triggers, views, etc.3+ years of SSIS experience (2012, 2016)2-3 years Azure experienceesign, model and develop complex data models and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems : Participate in planning and implementing the data integration and data migration activities. : Coordinate with team members to perform database programming based on project requirements. : Develop stored procedures, complex SQL queries, scripts and database programming for systems. : Perform quality assurance tests for ensuring data integrity across multiple databases. : Interact with project leaders to understand project requirements. : Provide valid inputs in database architectural discussions. : Assist in identifying process improvements for database performance, reliability and stability. : Perform troubleshooting and analysis to assess root cause of data issues in a timely manner. : Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and MS SQL Server by using SSIS services and transformation objects : Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies.Job Level Specific Duties• Entry-level position into business systems analysis.• Provides end user support for a specific application while learning about the application and customer. • Assists in application implementations and assists in testing end user processes using defined guidelines. • Updates existing tables and verifies the accuracy. • Collects data and runs basic reports in response to client inquiries as directed by more senior associates. • Interacts with clients, both internal and external, to supply basic information. • Analyzes business and user needs, documenting requirements, with the guidance of a senior associate.• Documents business rules/functional requirements to support system enhancements with the guidance of a senior associate.• Logs and tracks basic problems / work tickets with external product vendors or support organizations.Typical Years of Experience• Typically requires 2-4 years relevant experience.Minimum Education and Certifications• Undergraduate degree or equivalent combination of education and work experience.Skills• Awareness of system development methodology, project management and system architecture. Basic analytical / problem solving skills. • Ability to consider IT and business challenges.• Influencing and communication skills. Ability to translate between non-technical business users and technical IT resources. Strong client service attitude.• Organizational and time management skills.Physical Requirements/ Working Conditions• Ability to physically perform general office requirements. • Must be able to perform essential responsibilities with or without reasonable accommodations.• Significant travel including overnight domestic or international trips may be required.Posting Date:Department: -
# Unarmed Security GuardRocky Mount## Job Description**Position Summary**A valued contributor to our respectful and rewarding work culture, the Security Guard is responsible for performing licensed security guarding duties to ensure the safety and security of assigned...
Are you a licensed Hearing Aid Specialist who enjoys helping people hear better, communicate more confidently, and improve their quality of life? Do you want to combine exceptional patient care with the opportunity to lead and grow an established local hearing-care practice...
...Description Benchmark Group is looking for dynamic, talented individuals to fill our Architectural Designer position. We are always looking for people of exceptional talent, integrity, and professional commitment to be members of our Project Team of Choice. The right...
...Advanced Funeral Planner As an Advanced Funeral Planner, you will be responsible for assisting families in planning and securing pre-arranged funeral services for a local funeral establishment. This role requires a high level of interpersonal skills, self-motivation...
Designer Greetings is seeking a part-time Retail Merchandiser to service the greeting card department in a local store near Buffalo Grove, IL. This is an ongoing, independent contractor role with flexible scheduling.Responsibilities include straightening products, placing...