Technical Architect – Data Integration

4 weeks ago

India Blutic Full time

Blutic is looking for an Technical Architect – Data Integration & Reporting with 10+ yrs experience in designing, architecting, and overseeing the implementation of data solutions using SSIS, SSRS, SQL Server, and Snowflake, while leading a team of 12–15 offshore developers and QA analysts. This role requires hands-on architecture expertise, the ability to modernize legacy systems (e.g., migrations to cloud/Snowflake), and leadership to drive productivity improvements in alignment with client goals.

This is a 100% long term remote opportunity. The candidate should be willing to work in 9 hrs shift anywhere between 11am-11pm IST with an overlap of 3-4 hrs on Pacific time zone.

Core Skills Required:

  • 8+ years designing and implementing SSIS/SSRS solutions (large-scale ETL, data warehouses).
  • 2+ years hands-on with Snowflake (architecture, SnowSQL, performance tuning).
  • Expert in SQL Server (query optimization, indexing, partitioning).
  • Experience with cloud migrations (Azure/AWS) and hybrid architectures.

Key Responsibilities

1. Solution Architecture & Design

  • Design end-to-end data solutions: Architect scalable ETL frameworks, data warehouses, and reporting systems using SSIS, SSRS, and Snowflake.
  • Modernize legacy systems: Lead migrations from on-prem SQL Server to Snowflake/cloud platforms (Azure/AWS), ensuring optimal performance and cost efficiency.
  • Define best practices: Establish coding standards, design patterns, and governance for ETL/reporting development.
  • Evaluate new technologies: Propose innovations (e.g., API integrations, automation tools) to enhance the client's tech stack.

2. Technical Leadership & Delivery

  • Hands-on development: Review and optimize complex SSIS packages, SSRS reports, and Snowflake SQL for performance and maintainability.
  • Troubleshoot high-impact issues: Resolve architectural bottlenecks in data pipelines and reporting systems.
  • Mentor team members: Conduct technical deep-dives and pair programming sessions to uplift team skills.

3. Team Leadership

  • Manage offshore team performance: Set clear goals, conduct reviews, and ensure accountability for 12–15 developers/QA analysts.
  • Agile process ownership: Drive sprint planning, retrospectives, and daily stand-ups with a focus on continuous improvement.
  • Cross-functional collaboration: Partner with onshore teams to align priorities and remove roadblocks.

4. Client & Stakeholder Management

  • Architecture reviews: Present design proposals to client SMEs and incorporate feedback.
  • Productivity tracking: Report on progress toward 5–10% annual efficiency gains (e.g., reduced runtime, cost savings).
  • Risk mitigation: Proactively flag technical debt or scalability challenges.

5. Compliance & Security

  • Design for security: Implement data masking, access controls, and audit trails in Snowflake/SQL Server.
  • Enforce standards: Ensure compliance with client's VDI, MFA, and documentation requirements.

Required Skills & Qualifications

Technical Expertise

  • Nice-to-Have:
  • API development (C#/.NET), Python for scripting.
  • Certifications: Snowflake Architect, Microsoft Data Platform, AWS/Azure Data.

Leadership & Soft Skills

  • Proven team leadership: 5+ years managing offshore teams (10+ members) with Agile/Scrum.
  • Client-facing skills: Ability to explain technical trade-offs to non-technical stakeholders.
  • Innovation mindset: Track record of driving process improvements or cost savings.

Education & Experience

  • Bachelor's/Master's in Computer Science or related field.
  • Experience in regulated industries (financial, healthcare) preferred.

  • Salesforce Technical Architect

    3 weeks ago

    India NTT DATA Full time

    NTT DATA strives to hire exceptional innovative and passionate individuals who want to grow with us If you want to be part of an inclusive adaptable and forward-thinking organization apply now We are currently seeking a Salesforce Technical Architect to join our team in NoidaBengaluruChennaiHyderabad Karnataka India Job Summary We are seeking a...

  • Enterprise / Platform Architect

    4 days ago

    India NTT DATA Full time

    **Req ID**: 327606 We are currently seeking a Enterprise / Platform Architect to join our team in Bnagalore, Karnātaka (IN-KA), India (IN). **Job Description: ServiceNow Technical Architect** **Experience Level**: 8+ years in ServiceNow development & solutioning **Domain Expertise**: ITSM, ITOM, ITAM, ServiceNow Architecture, Performance...

  • Data Architect

    3 days ago

    India Artefact Full time

    **Key Responsibilities** - **Enterprise Data Strategy & Client Engagement**: - Develop and maintain a comprehensive data architecture strategy that aligns with organizational and client business objectives. - Serve as a key technical advisor for clients, translating business requirements into innovative data solutions. - Build and maintain strong client...

  • Expert Data Architect and Integration Specialist Wanted

    13 hours ago

    India beBeeData Full time ₹ 20,00,000 - ₹ 25,00,000

    Effective Data Modeler and Integration Specialist Needed We are seeking a highly skilled SAP BW with ABAP and SAC consultant to join our organization. This is an exciting opportunity to expand your skill set, achieve job satisfaction, and work-life balance. The ideal candidate will have:Strong experience in designing and implementing end-to-end data models...

  • Technical ServiceNow Architect

    4 weeks ago

    India Vriba Solutions Full time

    Job Title: Technical ServiceNow ArchitectLocation: "Remote" or Pune OR NoidaExperience: 8-10 yearsEmployment Type: Full-timeJob Summary:We are seeking a highly skilled Technical ServiceNow Architect to lead the design, development, and implementation of ServiceNow solutions across multiple modules. The ideal candidate will have deep technical expertise in...

  • Technical ServiceNow Architect

    4 weeks ago

    India Vriba Solutions Full time

    Job Title: Technical ServiceNow Architect Location: "Remote" or Pune OR Noida Experience: 8-10 years Employment Type: Full-timeJob Summary:We are seeking a highly skilled Technical ServiceNow Architect to lead the design, development, and implementation of ServiceNow solutions across multiple modules. The ideal candidate will have deep technical expertise...

  • Senior Integration Architect

    3 weeks ago

    India Prolifics Full time

    Overview At Prolifics we are currently implementing multiple solutions in Software Development and we are looking to hire talented Senior Integration Architect for our development centre in India This position would be based out of Hyderabad and is a permanent position If you are looking for a high growth company with rock-solid stability if you...

  • Data Architect

    3 weeks ago

    India Crescendo Global Full time

    We are hiring for a Data Architect professional with 10 years of experience who will be responsible to design ingestion transformation and summary layer Location - Kolkata Gurgaon MumbaiYour Future Employer- A leading consulting organization known for its innovative solutions and collaborative work environment They are committed to driving excellence and...

  • Senior Data Architect

    4 weeks ago

    India Blue Cloud Softech Solutions Limited Full time

    We are on an exciting journey to build and scale our advanced analytics practice.We are looking for a Senior Data Architect who has experience in building data lake and data warehouse architectures using On-Prem and Cloud technologies. We are seeking a highly skilled and experienced Data Architect with a strong background in Big Data technologies,...

  • Technical Sap Btp Integration Consultant

    4 weeks ago

    India Insight Global Full time

    Must-haves 3+ years of professional experience in SAP BTP (Business Technology Platform called Integration Services on a TECHNICAL stance Professional experience converting functional discussion into what it means from a technology system Experience with API Integration (Application Programming Interface, which allows the different software systems to talk...