EXL

Lead Assistant Manager - Azure Data Engineer

EXL  •  Noida, IN (Onsite)  •  14 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

  • Design, develop, test, and deploy data integration processes (batch or real-time) using tools such as Microsoft SSIS, Azure Data Factory, Databricks, Matillion, Airflow, Sqoop, etc.
  • Create functional & technical documentation – e.g. ETL architecture documentation, unit testing plans and results, data integration specifications, data testing plans, etc.
  • Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.
  • Perform data analysis to validate data models and to confirm ability to meet business needs.
  • May serve as project or DI lead, overseeing multiple consultants from various competencies.
  • Stays current with emerging and changing technologies to best recommend and implement beneficial technologies and approaches for Data Integration.
  • Ensures proper execution/creation of methodology, training, templates, resource plans and engagement review processes.
  • Coach team members to ensure understanding on projects and tasks, providing effective feedback (critical and positive) and promoting growth opportunities when appropriate.
  • Coordinate and consult with the project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.
  • Architect, design, develop and set direction for enterprise self-service analytic solutions, business intelligence reports, visualizations and best practice standards.
  • Toolsets include but not limited to: SQL Server Analysis and Reporting Services, Microsoft Power BI, Tableau and Qlik.
  • Work with report team to identify, design and implement a reporting user experience that is consistent and intuitive across environments, across report methods, defines security and meets usability and scalability best practices
  • 10 Years industry implementation experience with data integration tools such as Databricks, Azure Data Factory, etc.
  • Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Azure.
  • Work together with data scientists and analysts to understand the needs for data and create effective data workflows.
  • Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
  • Minimum of 5 years of data architecture, data modelling or similar experience.
  • Bachelor’s degree or equivalent experience, Master’s Degree Preferred.
  • Strong data warehousing, OLTP systems, data integration and SDLC.
  • Strong experience in big data frameworks & working experience in Spark or Hadoop or Hive (incl. derivatives like pySpark (prefered), SparkScala or SparkSQL) or Similar, along with experience in libraries / frameworks to accelerate code development.
  • Experience using major data modelling tools (examples: ERwin, ER/Studio, PowerDesigner, etc.).
  • Experience with major database platforms (e.g. SQL Server, Oracle, Azure Data Lake, Hadoop, Azure Synapse/SQL Data Warehouse, Snowflake, Redshift etc.).
  • Strong experience in orchestration & working experience in either Data Factory or HDInsight or Data Pipeline or Cloud composer or Similar.
  • Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.).
  • Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data.
  • Understanding of on premises and cloud infrastructure architectures (e.g. Azure, AWS, GCP).
  • Strong experience in Agile Process (Scrum cadences, Roles, deliverables) & working experience in either Azure DevOps, JIRA or Similar with Experience in CI/CD using one or more code management platforms.
  • 3-5 years’ development experience in decision support / business intelligence environments utilizing tools such as SQL Server Analysis and Reporting Services, Microsoft’s Power BI, Tableau, looker etc

Graduate in Computer Science, Data Science, or related field. 3-4 years of experience in data engineering or a related field

EXL

About EXL

Choosing a digital partner is about more than capabilities — it’s about collaboration and character.

Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments.

At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations.

Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale.

Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact.

We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition.

At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward.

For more information, visit www.exlservice.com.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
New York, NY
Year Founded
Unknown
Social Media