Data Engineer

Trellance Cooperative Holdings, Inc.; Ahmedabad District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

CU Rise Analytics Pvt. Ltd. seeks a skilled Data Engineer to join our team for building robust data pipelines and migrating reports to Power BI. You will handle SSIS packages, SSRS reports, and cloud data movements from on-prem to a cloud platform, ensuring data accuracy and scalable performance.

Ideal candidates will have 3–5 years of experience, strong SQL Server expertise, and familiarity with Snowflake and Power BI, along with excellent communication skills.

Qualifications

• Bachelor’s degree in CS/Engineering or related field.
• Hands-on experience building end-to-end data pipelines with SQL Server.
• Strong SQL, T-SQL, SSIS, and SSRS expertise.
• Experience with Snowflake and Power BI integration.
• Knowledge of AWS or Azure cloud data services.
• Excellent communication and collaboration skills.

Responsibilities

• Collaborate with cross-functional teams to design efficient data pipelines from landing to consumption.
• Build, optimize, and troubleshoot SSIS packages and data transformations.
• Develop and migrate SSRS reports to Power BI.
• Ensure data integrity and accuracy across pipelines.
• Validate migrated reports against SSRS outputs.
• Stay updated with SQL Server, SSIS/SSRS, Snowflake, and BI trends.

Skills

SQL Server

T-SQL

SSIS

SSRS

Power BI

Data warehousing

ETL/ELT

Snowflake

Cloud platforms

Data modeling

Problem solving

Communication

Teamwork

Education

Bachelor’s degree in computer science, Engineering, or related field

Tools

Snowflake

Power BI

Git

CI/CD

Job description

Job Description:

Company Detail

CU Rise Analytics Pvt. Ltd. is a wholly owned subsidiary of Trellance, Inc. CU Rise Analytics is an offshore development centre of Trellance Inc., working collaboratively to offer comprehensive solutions for data analytics, technology and talent to allow our credit union clients to provide high quality service to their members and remain competitive. Our core expertise lies in data science and technology, encompassing data analytics, predictive modelling, business intelligence, and technology services.

Trellance Cooperative Holdings, Inc. is a credit union cooperative and leading technology partner for credit unions. Its companies – consisting of Rise Analytics, ProBridge, Optiri and CUDX – provide innovative technology solutions for credit unions to increase efficiency, manage risk and improve the member experience. Trellance’s mission is to make sure credit unions have access to the tools and resources they need to grow, enhance member value and remain competitive in a rapidly evolving financial landscape.

Learn more at Trellance.com

Experience Required:3 to 5 years

Job Description

We are seeking skilled Data Engineer with expertise in SQL, SSIS and SSRS to join our team. As a Data Engineer, you will be critical in our client’s work of Automation, import, export and cloud migration from on-premises systems to, a cloud-based data platform. You will be responsible for building robust and efficient SSIS packages, building reliable data pipelines to transform raw data, and migrate reports from SSRS to PowerBI. Experience with Snowflake is a plus.

Responsibilities

• Collaborate with cross-functional teams to understand data extraction and reporting requirements. Design performant, efficient, and secure data pipelines from the landing zone to the consumption level in SQL server and SSIS.
• Utilize native SSIS capabilities to implement data transformations, aggregations, and enrichments to meet business needs.
• Develop, maintain, troubleshoot and optimize SSRS reports, subscriptions, and data sets.
• Validate migrated PowerBI reports against SSRS outputs to ensure data accuracy, calculation, consistence, functional parity and stakeholder acceptance
• Develop and maintain data ingestion processes from various sources to on-premises sources to the landing zone, ensuring data integrity and accuracy throughout the pipeline.
• Work closely with the architecture team to ensure seamless integration of data sources.
• Optimize SSIS Package performance, scalability, and reliability, implementing best practices and monitoring mechanisms.
• Collaborate with data analysts and other stakeholders to understand data consumption requirements and provide solutions for efficient data retrieval and reporting.
• Stay updated with the latest advancements in SQL Server, SSIS, SSRS and Snowflake and data engineering techniques, sharing knowledge and insights with the team.

Skills & Qualifications

Must-Have

• Bachelor’s degree in computer science, Engineering, or a related field (or equivalent practical experience).
• Proven experience as a Data Engineer with a focus on SQL Server, including hands-on experience in building end-to-end data pipelines.
• Strong understanding of SQL Server architecture, data warehousing concepts, and ETL/ELT methodologies.
• Expert knowledge of SQL (T-SQL specifically for SQL Server), including writing complex queries, stored procedures, and performance optimization techniques.
• Hands-on experience with Microsoft SQL Server Integration Services (SSIS) is essential, along with general knowledge of other ETL tools
• Hands on knowledge of SQL Server Reporting Services (SSRS), including report development, parameters, expressions, datasets and deployment.
• Knowledge of connecting PowerBI to on-prem data sources through data gateways, while maintaining report and data security.
• Familiarity with cloud platforms (e.g., AWS, Azure) and their data services. Azure knowledge is a plus
• Solid understanding of data modeling principles and ability to design efficient data structures within Snowflake and PowerBI.
• Strong problem-solving skills and ability to analyze complex data requirements to develop effective solutions.
• Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams.
• Proactive and self-motivated with a passion for data engineering and delivering high-quality solutions.

Preferred Qualifications

• Expertise and experience using Snowflake procedures, functions, streams, tasks, external stages, and external tables.
• Expertise and experience using Snow pipe.
• Experience with Snowpark, especially with Python.
• Experience with version control systems (e.g., Git) and CI/CD pipelines.
• Knowledge of Python or other scripting languages for data processing and automation.
• Expertise in Banking Data/Domain.
• Familiarity with data governance frameworks and practices.
• Experience with data visualization tools (e.g., Tableau, Power BI) for reporting and analytics.