SQL Data Analyst / Data Mapper / ETL Developer (SSIS)
Role summary
Seeking an experienced SQL/SSIS ETL professional for a 6+ month remote contract in the US. The role involves designing, developing, and maintaining data integration and mapping solutions across multiple systems. Responsibilities include building robust ETL workflows using SSIS, writing complex T-SQL queries, performing data mapping and validation, troubleshooting ETL issues, and collaborating with stakeholders to ensure high data quality for reporting and analytics. Requires a minimum of 5 years of experience with SQL Server and SSIS, strong T-SQL proficiency, and a solid understanding of data quality best practices.
Location: Remote (USA only)
Type: 6+ Month Contract
Sponsorship: Not available (must be authorized to work in the U.S.)
About the Role
We are seeking an experienced SQL/SSIS ETL professional to support one of our clients in designing, developing, and maintaining data integration and mapping solutions across multiple source systems and targets. You will work closely with business and technical stakeholders to understand data requirements, build robust ETL workflows, and ensure high data quality for reporting and analytics.
Key Responsibilities
- Design, develop, and optimize ETL processes and packages using SQL Server Integration Services (SSIS).
- Develop and maintain complex T‑SQL queries, stored procedures, views, and functions for data extraction, transformation, and loading.
- Perform detailed data mapping between source and target systems, including documenting transformation and business rules.
- Analyze, profile, and validate data to ensure accuracy, completeness, and consistency across environments.
- Troubleshoot and resolve ETL job failures, performance issues, and data quality problems in a timely manner.
- Collaborate with business analysts, data owners, and BI/reporting teams to clarify requirements and translate them into technical specifications.
- Create and maintain technical documentation for ETL workflows, data mappings, and database objects.
- Support deployment, scheduling, and monitoring of SSIS jobs (e.g., via SQL Server Agent) in lower and production environments.
Required Qualifications
- Minimum 5 years of hands-on experience with SQL Server and SSIS in a data analyst, data mapper, or ETL developer role.
- Strong proficiency in T‑SQL, including writing and tuning complex queries, stored procedures, and views against large data sets.
- Proven experience designing and building ETL workflows and data pipelines using SSIS (control flow, data flow, error handling, logging).
- Demonstrated background in data mapping, data profiling, and validating data across multiple source/target systems.
- Experience working with relational database concepts, indexes, performance optimization, and basic database administration tasks.
- Solid understanding of data quality, data governance, and best practices for maintaining data integrity.
- Excellent communication skills, with the ability to work effectively on a fully remote, cross-functional team.
Nice to Have
- Experience with reporting/BI tools (e.g., SSRS, Power BI, or similar).
- Background in data warehousing concepts (star schema, dimensional modeling, fact and dimension tables).
- Experience in industries with complex data
Contract Details
- Duration: 6+ months, with potential for extension based on performance and client needs.
- Work arrangement: 100% remote within the United States.
- Employment type: W2 or 1099 or C2C ( no third-party agencies, no visa sponsorship).