Data Engineer - SSIS & Tableau (5-15 yrs)

job Title : Data Engineer - SSIS & Tableau

Experience : 5 - 10 Years

Location : Remote (Contract-to-Hire)

Employment Type : C2H (Contract-to-Hire)

Job Summary :

We are looking for a Data Engineer with expertise in SSIS, Tableau, SQL, ETL, and AWS to design, develop, and maintain data pipelines. The ideal candidate will have strong experience in data modeling, data pipeline development, and visualization using Tableau. You will collaborate with cross-functional teams, including data architects, scientists, and analysts, to deliver high-quality data solutions in an Agile environment.

Key Responsibilities :

- Design, build, and maintain scalable data pipelines following enterprise architecture principles.

- Develop and manage data collection, transformation, and validation processes.

- Create and optimize Tableau dashboards, reports, and data visualizations for business insights.

- Implement ETL processes using SSIS and optimize data storage and retrieval.

- Work with diverse data sources and ensure data accuracy, quality, and security.

- Collaborate with cross-functional teams (data architects, analysts, and scientists) to resolve technical issues.

- Ensure timely delivery of data solutions in an Agile/Lean development model.

- Translate functional business requirements into technical solutions.

- Optimize database performance and ensure seamless integration of data across platforms.

Required Skills & Expertise :

Tableau :

- Develop and maintain interactive dashboards and reports.

- Connect Tableau to various real-time and batch data sources.

- Perform data analysis, validation, and mapping to enhance reporting accuracy.

- Optimize user experience with Tableau story points and interactive dashboards.

- Conduct data exploration, validation, and performance tuning for dashboards.

- Provide technical support for Tableau-related issues.

SSIS & SQL :

- Develop and manage ETL pipelines using MSBI (SSIS) Tech Stack.

- Build a scalable data pipeline architecture for efficient data processing.

- Handle data ingestion, transformation, and integration from diverse sources.

- Maintain metadata and data requirements for consistency and governance.

- Work with AWS storage solutions (Amazon S3) for data management.

- Strong expertise in SQL query optimization and data modeling.

- Research and automate repetitive tasks to improve efficiency.

- Experience with cloud computing services (AWS, Azure, or GCP).

- Collaborate with global stakeholders across multiple time zones.