Data Engineer - SSIS / SQL Server, Azure
Preferred Location: Pune/Hyderabad, India
Impact Makers is a mission-driven management and technology consulting company that delivers exceptional value to make an impact for our clients and the world. Our experienced teams help organizations manage transformation in IT, data, cloud, and security with a focus on their customers and their people. We utilize our innovative business model to transform the business value of our work into social value for the community. We are committed to gifting 100% of our net profits to the community over the life of the company and our annual community contributions rival companies 100x our size.
About the Role
We are looking for a Data Engineer to join a larger Impact Makers (IM) delivery team supporting a key client engagement. This role focuses on engineering and maintenance of business-critical data platforms built on the SQL Server ecosystem. It is well suited for someone who enjoys understanding existing systems, building strong context, and taking thoughtful ownership over how data platforms operate and evolve. You will work as part of a collaborative IM team, partnering closely with the client's stakeholders.
Engagement Details
- Start: March 1
- Employment Type: Full Time
- Preferred location: Pune/Hyderabad, India
What You'll Do
Discovery & System Understanding
- Take time to understand existing data platforms, including architecture, data flows, and dependencies
- Build a clear picture of how data is modeled, processed, and consumed across the organization
- Ask thoughtful technical and business questions to establish shared understanding
- Translate what you learn into clear plans for stabilization and improvement
- Data Engineering & Relational DatabasesDesign, develop, and maintain SSIS packages and SQL Server Agent jobs
- Write and optimize SQL including stored procedures, views, triggers, and functions
- Work confidently with relational data models, understanding how tables, keys, and relationships support reporting and analytics
- Tune performance using indexes, statistics, execution plans, and query design
- Support large datasets and frequently used tables with a focus on reliability and scalability
- Reliability & Ongoing SupportHelp ensure data pipelines run predictably and consistently
- Investigate and resolve data issues in a structured, calm manner
- Reduce repeat issues through thoughtful, durable improvements
- Balance short-term fixes with longer-term enhancements
- Agile Delivery & Engineering PracticesWork within an Agile delivery model, participating in planning and retrospectives
- Use Git for version control and collaborate through structured release processes
- Support smooth promotion of changes across environments (Dev QA UAT Prod)
- Take ownership of work from start to finish, with a focus on quality and follow-through
- Collaboration & CommunicationWork with client stakeholders in collaboration with IM team.
- Explain data structures, dependencies, and impacts in clear, accessible language
- Collaborate with analytics, application, infrastructure, and platform teams
What We're Looking For
Must-Have
- Strong experience with SQL Server (on-premise)
- Advanced SQL skills, including performance tuning
- Hands-on experience with SSIS
- Solid understanding of relational database concepts and data modeling
- Experience supporting production data systems
- Comfortable learning existing systems and building context before making changes
- Exposure to Azure, AWS, or GCP
- Strong communication skills
- Nice to HaveExperience with SSAS
- Working knowledge of Oracle / PL-SQL
- Shell scripting for automation
- Experience with Azure Data Factory (ADF)
- Familiarity with Microsoft Fabric
- Experience with Power BI
- Exposure to Snowflake
- Familiarity with open orchestration tools such as Airflow
- Experience with Azure DevOps, Jira, or similar tools
Growth & Future Opportunities
While the initial focus is understanding and strengthening an existing SQL Serverbased platform, there is a clear opportunity to participate in future modernization efforts.
As the platform stabilizes, you may:
- Contribute to evolution toward Microsoft Fabric
- Expand orchestration beyond SSIS using ADF or open orchestration tools
- Participate in cloud discussions across Azure, AWS, or GCP
- Work with modern analytics platforms such as Power BI
We value thoughtful evolution built on a strong understanding of what exists today.
Why This Role
- Part of a larger IM delivery team, not staff augmentation
- Opportunity to stabilize today's platform and help shape what comes next
- A balanced mix of ownership, collaboration, and forward-looking work
Experience
- 2-5 years of experience in data engineering on SQL Server/SSIS, Cloud
- Experience with established data platforms and relational databases preferred
Benefits of working at Impact Makers:
As a values-based company, taking care of our employees is of the utmost importance and our employee benefits package reflects that. We offer healthcare plans with generous contributions to premiums, 401(k) with matching, and generous PTO. Impact Makers embraces the pursuit of balance between work, family, and personal interests, with a flexible, dog-friendly work environment in Scott's Addition. We like to have fun at work, collaborating through company sponsored events and pro bono opportunities. Our team members work with Impact Makers, not
