Any salary estimation specified in this job board may or may not be aligned with our organization’s pay philosophy. Apply to connect with a Talent Acquisition Partner who can provide you more details!
We are seeking a skilled and detail-oriented Microsoft SSIS Developer (contractor) with strong Microsoft SQL Server expertise and experience in SQL Server Analysis Services (SSAS). This role is responsible for designing, developing, and maintaining ETL solutions using Microsoft SSIS to support data integration, data warehousing, and reporting initiatives across the organization.
The ideal candidate will have experience managing ETL processes, ensuring data accuracy and integrity, and collaborating with cross-functional teams to understand business requirements and deliver scalable data solutions.
This is an individual contributor role with no direct reports. The position works closely with IT project teams and business stakeholders across multiple departments.
Essential Duties:
- Design, develop, test, and maintain ETL solutions using SQL Server Integration Services (SSIS)
- Maintain and enhance existing ETL workflows to improve data integrity, reliability, and performance
- Create and maintain SSAS multidimensional and/or tabular models
- Support enterprise data warehouse architecture and data integration initiatives
- Implement data validation, transformation, and cleansing processes
- Optimize ETL and cube processing performance
- Develop and maintain technical documentation, including data flow diagrams and process documentation
- Collaborate with business and technical teams to gather requirements and translate them into scalable solutions
- Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner
- Continuously improve ETL processes by incorporating best practices and feedback
Technical Skills:
- Proven experience as an ETL Developer with at least 3 years of experience using SSIS.
- Strong understanding of data integration, data warehousing, and ETL processes.
- Microsoft SQL Server
- SSIS (SQL Server Integration Services)
- SSAS (SQL Server Analysis Services)
- T-SQL
- Oracle
- Data Warehousing
- ETL Development
- Power BI / SSRS
- Problem Solving
Soft Skills:
- Knowledge and experience in the business areas of manufacturing and/or e-commerce
- Highly analytical with the ability to work on small to large complex projects
- Ability to develop solutions requiring analysis and research
- Exceptional problem solving, analytical, and customer-facing skills
- Ability to cultivate an understanding of what the business is trying to achieve while working with a standard technology stack to define effective and efficient solutions
- Proven ability to deliver projects within short timelines
- Excellent verbal and written communication skills, with the ability to summarize and present findings or challenges to all levels of staff and management
- Ability to work on one or more projects as a project team member
- Ability to work in decentralized team and communicate using virtual communications tools (phone, conferencing, web meetings)
- Ability to work independently with minimum guidance and be a self-starter; takes actions to achieve goals; proactive
Education: Bachelor’s degree in computer science, Information Systems or other related field from four-year College or University.
Experience: 3 to 5 years of hands-on experience using SSIS.
This description indicates the general nature of the tasks and responsibilities required of positions given this classification. It is not intended as a complete list of specific duties and responsibilities. Nor is it intended to limit or modify the right of management to assign, direct, and control the specific duties of individuals performing this function. The Company reserves the right to change, modify, amend, add to or delete from any section of this document as it deems, in its judgement, to be proper.
