Data Engineer - ETL/SSIS Location: Remote Duration: 12-month contract to start with strong possibility of extension. Our client, a leading provider of technology enabled risk and claims management solutions, is seeking an experienced Data Engineer with strong skills in SSIS, ETL processes, and advanced SQL scripting (T-SQL and PL/SQL). This long-term, remote contract role is part of a high-performing data team responsible for large-scale data migration, cleansing, and transformation projects across enterprise claims systems. You will play a critical role in building and optimizing data pipelines, ensuring clean and accurate data for high-volume transactional environments. Key Responsibilities: • Design, build, and troubleshoot robust SSIS-based ETL pipelines to process and transform data from external client systems. • Develop and optimize complex T-SQL or PL/SQL scripts, stored procedures, and queries for data transformation, cleansing, and validation. • Perform data mapping, normalization, and deduplication to ensure data integrity during migrations. • Collaborate closely with stakeholders and QA teams to ensure data accuracy, consistency, and business alignment. • Tune SQL performance using indexing, execution plan analysis, and query optimization techniques. • Analyze data from multiple structured sources (CSV, XML, flat files) to derive insights and support business reporting needs. • Create and maintain automated reports using tools such as SSRS, BusinessObjects, or Crystal Reports. • Build/Monitor/Troubleshoot Extract, Transform and Load (ETL) nightly jobs using SSIS. • Design and implement T-SQL views from dimensional models to support reporting. • Optimize SQL query performance by analysis, profiling and indexing to minimize response time. Required Skills: Advanced proficiency in: • SQL scripting (T-SQL or PL/SQL) • SSIS and ETL pipeline design, development, and troubleshooting • Data cleansing, transformation, and validation best • SQL Server performance tuning, indexing, stored procedures, and debugging • Working with structured data formats (CSV, XML, flat files) • Data migrations across multiple formats and systems • Excellent communication skills with the ability to explain complex data logic clearly • Strong attention to detail, analytical mindset, and ability to work independently • Experience in high-volume claims systems, insurance, or similar transactional environments • Familiarity with cloud environments such as Azure • Experience implementing CI/CD pipelines and using tools like Azure DevOps • Experience with reporting tools (SSRS, Crystal Reports, BusinessObjects) • Strong analytical mindset and exceptional attention to detail • Excellent verbal and written communication; able to explain complex data logic clearly • Proactive, accountable, and self-motivated • Comfortable working independently in a remote, fast-paced setting • Team-oriented, adaptable, and eager to learn We're looking for a collaborative, driven go-getter who can hit the ground running, take initiative, and thrive in a fast-paced environment where proactive problem-solving and ownership are key to success. Benefits • Medical Insurance – Four plans to choose from for you and your family • Dental and Orthodontia Benefits • Vision Benefits • Health Savings Account (HSA) • Health and Dependent Care Flexible Spending Accounts (FSA) • Voluntary Life Insurance, Long-Term and Short-Term Disability Insurance • Hospital Indemnity Insurance • 401(k) Retirement Plan • Paid Sick Time Leave • Legal and Identity Protection Plans • Pre-tax Commuter Benefit • 529 College Savings Plan Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying; no sponsorship is currently available. Employment is contingent upon successful completion of a pre-employment screening. Accommodation will be provided throughout the hiring process as required under MRP’s Employment Accommodation Policy. Applicants are encouraged to make accommodation needs known in advance.