This role will contribute to implementation methodologies and best practices, as well as work on project teams to analyse, design, develop and deploy business intelligence / data integration solutions to support a variety of customer needs. This position oversees a team of Data Integration Consultants at various levels, ensuring their success on projects, goals, trainings, and initiatives though mentoring and coaching.

Provides technical expertise in needs identification, data modelling, data movement and transformation mapping (source to target), automation and testing strategies, translating business needs into technical

solutions with adherence to established data guidelines and approaches from a business unit or project perspective whilst leveraging best fit technologies (e.g., cloud, Hadoop, NoSQL, etc.) and approaches to address business and environmental challenges

Works with stakeholders to identify and define self-service analytic solutions, dashboards, actionable enterprise business intelligence reports and business intelligence best practices. Responsible for repeatable, lean and maintainable enterprise BI design across organizations. Effective partners with client team. Leadership is not only in the conventional sense, but also within a team we expect people to be leaders. Candidates should elicit leadership qualities such as Innovation, Critical thinking, optimism/positivity, Communication, Time Management, Collaboration, Problem-solving, Acting Independently, Knowledge sharing and Approachable.

Responsibilities :

- Own end-to-end delivery of data management features, ensuring on-time and high-quality output.

- Break down large initiatives into milestones, sprints, and actionable tasks.

- Coordinate work across engineering, data science, product, and infrastructure teams.

- Monitor progress, manage risks, and adjust plans when requirements evolve.

- Ensure architectural decisions align with data strategy, scalability, and reliability goals.

- Provide directions on :

1. Data modeling

2. Data pipelines (ETL/ELT)

3. Data governance & quality frameworks

4. Metadata management

5. Data lineage tools

6. API and platform integration

- Build, lead, and mentor a team of data engineers, software engineers, and data analysts.

- Facilitate career development, performance reviews, and skill-building.

- Create a culture of accountability, ownership, and continuous improvement.

- Resolve conflicts, remove blockers, and keep the team aligned on priorities.

- Work with product managers to define clear requirements and successful metrics.

- Collaborate with business stakeholders on data needs, SLAs, and integration priorities.

- Communicate progress to executives and provide roadmap visibility.

- Manage expectations around delivery timelines, scope, and trade-offs

- Design, develop, test, and deploy data integration processes (batch or real-time) using tools such 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.

Required Qualifications :

- 10- 14 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.

- Must have at least 5+ experience in managing technical teams and leading them to deliver large scale solutions.

- Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.

- Bachelors degree or equivalent experience, masters 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.)

- Must have excellent communication skills (English) to interface with US clients directly and verify in proficient in all types of communication modes Listening, Reading, Writing and Speaking

- 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, Microsofts Power BI, Tableau, Looker etc.

Preferred Skills & Experience :

- Knowledge and working experience with Data Integration processes, such as Data Warehousing, EAI, etc.

- Experience in providing estimates for the Data Integration projects including testing, documentation, and implementation

- Ability to analyse business requirements as they relate to the data movement and transformation processes, research, evaluation and recommendation of alternative solutions.

- Ability to provide technical direction to other team members including contractors and employees.

- Ability to contribute to conceptual data modelling sessions to accurately define business processes, independently of data structures and then combine the two together.

- Proven experience leading team members, directly or indirectly, in completing high-quality major deliverables with superior results

- Demonstrated ability to serve as a trusted advisor that builds influence with client management beyond simply EDM.

- Can create documentation and presentations such that they stand on their own

- Can advise sales on evaluation of Data Integration efforts for new or existing client work.

- Can contribute to internal/external Data Integration proof of concepts.

- Demonstrates ability to create new and innovative solutions to problems that have previously not been encountered.

- Ability to work independently on projects as well as collaborate effectively across teams

- Must excel in a fast-paced, agile environment where critical thinking and strong problem-solving skills are required for success

- Strong team building, interpersonal, analytical, problem identification and resolution skills

- Can effectively utilise SQL and/or available BI tool to validate/elaborate business rules.

- Demonstrates an understanding of EDM architecture and applies this knowledge in collaborating with the team to design effective solutions to business problems/issues.

- Effectively influences and, at times, oversees business and data analysis activities to ensure sufficient understanding and quality of data.

- Demonstrates a complete understanding of and utilises DSC methodology documents to efficiently complete assigned roles and associated tasks.

- Understands and leverages a multi-layer semantic model to ensure scalability, durability, and supportability of the analytic solution.

- Understands modern data warehouse concepts (real-time, cloud, Big Data) and how to enable such capabilities from a reporting and analytic standpoint.