Engineer Senior Consultant - Snowflake, United States - ExlService Holdings , Inc.

Description

EXL is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth.

Bringing together deep domain expertise with robust data, powerful analytics, cloud, and AI, we create agile, scalable solutions and execute complex operations for the world's leading corporations in industries including insurance, healthcare, banking, financial services, media, and retail, among others.

Our team is over 40,000 strong in New York, with over 50 offices spanning six continents. For information, visit .

EXL is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth.

Bringing together deep domain expertise with robust data, powerful analytics, cloud, and AI, we create agile, scalable solutions and execute complex operations for the world's leading corporations in industries including insurance, healthcare, banking, financial services, media, and retail, among others.

Our team is over 40,000 strong in New York, with over 50 offices spanning six continents. For information, visit .

Application & Interview Impersonation Warning

– Purposely impersonating another individual when applying and / or participating in an interview in order to obtain employment with EXL Service Holdings, Inc. (the "Company") for yourself or for the other individual is a crime. We have implemented measures to deter and to uncover such unlawful conduct. If the Company identifies such fraudulent conduct, it will result in, as applicable, the application being rejected, an offer (if made) being rescinded, or termination of employment as well as possible legal action against the impersonator(s).

EXL is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth.

Bringing together deep domain expertise with robust data, powerful analytics, cloud, and AI, we create agile, scalable solutions and execute complex operations for the world's leading corporations in industries including insurance, healthcare, banking, financial services, media, and retail, among others.

Our team is over 40,000 strong in New York, with over 50 offices spanning six continents. For information, visit .

Application & Interview Impersonation Warning

– Purposely impersonating another individual when applying and / or participating in an interview in order to obtain employment with EXL Service Holdings, Inc. (the "Company") for yourself or for the other individual is a crime. We have implemented measures to deter and to uncover such unlawful conduct. If the Company identifies such fraudulent conduct, it will result in, as applicable, the application being rejected, an offer (if made) being rescinded, or termination of employment as well as possible legal action against the impersonator(s).

EXL may use artificial intelligence to create insights on how your candidate information matches the requirements of the job for which you applied.

While AI may be used in the recruiting process, all final decisions in the recruiting and hiring process will be taken by the recruiting and hiring teams after considering a candidate's full profile.

As a candidate, you can choose to opt out of this artificial intelligence screening process. Your decision to opt out will not negatively impact your opportunity for employment with EXL.
Job Summary

The Data Engineer Senior Consultant plays a critical role in the implementation of Enterprise Data Management (EDM) Solutions for Datasource Consulting/EXL Clients.

They are responsible for setting the development standards and best practices, and may be required to assist with requirements gathering/analysis, development, testing, documentation, and deployment tasks.

This is a business-facing role in which the consultant will work independently and collaboratively with internal and client teams to ensure project success.

The Data Engineer Senior Consultant should have practical experience developing EDM solutions, strong working knowledge of the technologies listed below, and an eagerness/ability to learn and train on new technologies.

You will have the opportunity to engage with clients utilizing all aspects of a Data Management organization including Data Governance, Data Quality, MDM, and Business Intelligence.

You will also be working closely with Cloud, Big Data, Data Modeling, and Project Management consultants. You must be able to fill different positions in multi-functional and multi-shore project teams.
(60%) Analysis/Development/Testing
Leads the software development team during the design, build, test, support phases
Evaluates the introduction of new technologies and implements solutions and enterprise data integration strategies
Provide analysis and recommendations to overall data strategies and roadmaps
Partners with Solution Architects to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas
Leads engineering teams and guides members in best practices for data movement, data quality, master data management (MDM), data masking, data sub-setting and/or data virtualization development (collectively referred to as data integration and data management activities)
Drives the technical design, installation & configuration, development, optimization, error handling and support of data management initiatives for customer engagements
Installs and configures software in on-premises and cloud environments
Ensures the compliance of project team to development, naming and coding standards
Creates and implements scheduling strategies for data management processes
Administers and supports data management environments and repositories
Works with business partners to review prototypes and develop iterative revisions
Oversees and performs troubleshooting and provides resolutions for reporting issues
Works closely with and assists other consultants, provides leadership, and collaborates with clients to understand and interpret data through stakeholder interviews and by defining, analyzing, and validating data
Develops appropriate tool development guidelines and documentation
Evaluates and tests new tools and technologies.
Develops and executes test cases/plans to ensure high-quality releases, based on test driven development using industry best practices such as Gherkin
Defines data pipeline orchestration and subsequently automates code deployments or mentors junior team members to automate the deployments using tools such as Apache Airflow, Control-M, or Autosys
Performs data management development tasks in areas of data movement, data quality, MDM, business intelligence, etc. - DQ, data architecture, etc.?
Supports testing, root cause analysis, bug fixing and deployment activities
(30%) Communication/Organization/Documentation/Leadership
Leads collaboration and ensures success with offshore delivery team
Assists in producing detailed and comprehensive documentation for testing and deployment activities.
Deals effectively with all team members and builds strong working relationships/rapport with them
Demonstrates ability to organize tasks and time necessary to complete assigned tasks/deliverables
Coordinates with Project Managers and Leads to help drive project planning
Perform feasibility analysis, scoping exercises, and works with the project manager to prioritizes deliverables
Leads the data engineering aspect of projects for the enterprise, including hands on delivery
Leads the software development team during the design, build, test, support phases
Directs and implements data integration processes, including data capture, testing and validation methods
Prioritizes and organize multiple tasks providing direction, tools, technical and process support to less senior developers
Provides appropriate training, mentoring and support for Data integration tools to the developers
Provides proactive technical oversight and advice to integration architect and development team
Assists developers, analysts, and designers in conceptualizing and validating solutions that meet business requirements
Aligns data architecture plans with strategic business objectives
Utilizes agile-based approach to implementing data services and solutions
Provide analysis and recommendations to overall data strategies and roadmaps
Coordinates and oversee the assignments, delivery, and quality of data integration project
Develops appropriate tool development guidelines and documentation
Ensures the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle
Assists with infrastructure and capacity planning
Assist with the development and enforcement of integration standards
(10%) Other duties as assigned or identified
Education & Experience
7+ years of experience in a Data Management/Engineer role
5+ years of consulting experience strongly preferred
3+ years of experience leading offshore teams
Practical experience in at least 3 of the following areas:
Data Integration/Movement
Data Quality
Master Data Management
Data Governance
Business and Data Analysis
Data Modeling
Quality Assurance
Project Management
Advanced Analytics
Experience with developing and supporting data management environments utilizing tools such as Tableau, Power BI, TIBCO, MSBI, Informatica, and Databricks
Experience with or ability to learn modern data platforms involving AWS, Azure, GCP, Snowflake, Denodo, etc. Ability to learn MDM platforms,
Experience with Informatica MDM, Orchestra EBX, or similar tools a plus
Bachelor Degree or Equivalent
Excellent organizational and analytic abilities
Outstanding communication and people skills
Knowledge, Skills & Abilities
Practical development experience with an object-oriented programming language
Python and Java preferred
Experience with version control frameworks such as Git and Subversion preferred
Highly proficient in SQL
Proficient at writing complex SQL statements and interpreting results
Proven experience in operational analysis, data analysis, and problem resolution activities
Proficient with PowerCenter or SSIS ETL design and development
Excels in a fast paced, agile environment where critical thinking and strong problem-solving skills are required for success
Physical Demands and Working Conditions

Works in a normal office environment requiring light physical effort by handling objects up to 20 pounds occasionally and/or up to 10 pounds frequently.

Works with standard office equipment (such as phone, fax and personal computer).Ability to navigate stairs frequently during the course of a business day in various work locations.

Sitting at desk for most of day, and working with computer.

#J-18808-Ljbffr