Dataloader – Revenue Solutions Inc – Pembroke, MA

Job title: Dataloader Company: Revenue Solutions Inc Job description: Description: Do you have experience cleansing and transforming data to new applications? Do you have experience with SQL server and utilizing SSIS? Is ETL second nature to you? Have you been part of large-scale implementation projects? If so, we're looking for you to be our Sr. Data Load Developer. You will be a part of small team and take a hands-on approach to implement the data loading activities through the Software Development Life Cycle (SDLC), define data requirements, write technical mapping specifications, create test scripts, perform unit and system testing, and lead the implementation of ETL processes from various formats (delimited, Excel, Access & SQL Server) to a new Integrated Tax System. RESPONSIBILITES WILL INCLUDE: • Lead and mentor junior team members • Providing data load design and development for external data sources including entities and accounts, financials, cases, and other miscellaneous data sources • Unit test/validate data load results before delivering to customers • Create, manage and modify automated jobs to stay current with incoming data • Develop and maintain stored procedures and views that are used by ETLs • Writing new and updating existing SQL stored procedures and functions • Troubleshoot errors and assist with customer inquiries • Performance tuning for time-sensitive production data load jobs • Perform integrity checks on data using both established and new procedures and tools, as well as creating new integrity check procedures as needed • Stay abreast with new trends and technologies within the data management and transformation fields • Contribute to the planning, documentation, and execution of data load projects • Assess and raise risks proactively • Other duties as assigned PM22 Requirements: • BS in Computer Science, MIS, Mathematics, Economics, or relevant experience • Immediate authorization to work in the United States • 4+ years of relevant work experience on large-scale implementation projects • Proficiency in creating Microsoft SSIS packages with C# scripting components • Proficiency in Microsoft's SQL Server Management Studio (SSMS) and Visual Studio • Ability to work in agile team environment (from) planning, coding, testing, deployment (to) customer acceptance and sign off • Enjoy the challenge and rewards of data analysis, transformation, and successful migration • Ability to multi-task and work in a fast-paced environment • Ability to work both in a team setting and independently • Detail-oriented, able to manage competing priorities effectively • Strong analytical problem-solving skills • Excellent verbal and written communication skills PI195451917 Expected salary: Location: Pembroke, MA Job date: Tue, 15 Nov 2022 05:04:58 GMT Apply for the job now! Apply tot his job