Data Architect

About the Role

We are looking for an experienced Power BI Architect to lead enterprise-wide BI initiatives. This role will be responsible for designing, implementing, and governing scalable Power BI solutions across the organization. The ideal candidate will play a key role in establishing best practices, driving adoption, and owning the overall BI architecture within the Center of Excellence (CoE).

Key Responsibilities

• Lead end-to-end implementation of Power BI solutions across the enterprise
• Design scalable, secure, and high-performance BI architecture
• Act as the Power BI Architect, providing technical leadership and direction
• Own and drive BI governance, standards, and best practices within the CoE
• Collaborate with business and technology teams to translate requirements into robust BI solutions
• Define data modeling strategies, reporting frameworks, and dashboard standards
• Ensure data accuracy, consistency, and performance optimization across reports
• Support and guide development teams in Power BI implementation
• Enable enterprise-wide adoption of Power BI through training, documentation, and mentorship
• Work closely with IT/technology teams to integrate Power BI with data platforms and enterprise systems

Required Skills & Qualifications

• 10+ years of experience in BI/Data Analytics, with strong focus on Power BI
• Proven experience in enterprise-wide Power BI implementation
• Strong expertise in:
• Power BI (Desktop, Service, Gateway, Dataflows)
• Data Modeling (Star Schema, Snowflake Schema)
• DAX, Power Query (M language)
• Experience in designing and implementing BI architecture at scale
• Strong understanding of data warehousing concepts and ETL processes
• Experience working within a Center of Excellence (CoE) model
• Excellent stakeholder management and communication skills

Preferred Skills

• Experience with Azure (Azure Synapse, Data Factory, Data Lake)
• Knowledge of DevOps practices for Power BI (CI/CD pipelines)
• Exposure to governance tools and security frameworks
• Certification in Power BI / Microsoft Data Platform

We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.

Qualifications and Skills:

• Minimum 4 years of experience as a Data Engineer
• Hands-on experience with Azure cloud-based data solutions
• Fabric experience is a must – designing, implementing, and managing data workflows and pipelines
• Expertise in database design and management, including SQL databases such as SQL Server
• Proficient in ETL (Extract, Transform, Load) design for data integration and processing
• Strong knowledge of data modeling principles and techniques
• Experience with Azure Data Factory (ADF) for orchestrating data workflows
• Ability to analyze and translate data into actionable insights, reports, and visualizations
• Proficiency in Power BI for reporting and data visualization
• 
  

Desirable Skills:

• Experience with Power BI Report Builder / Reporting Services
• Knowledge of statistical analysis or Data Science
• Experience within the UK Insurance industry is a plus
• Python or R coding skills

Responsibilities:

• Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
• Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
• Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
• Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
• Implement different methods of streaming data and create reconciliations for datasets
• Build analytical models to support reporting and analytics
• Collaborate with an agile delivery team to work on the backlog of specified work

Data & BI Support Specialist - JD

Professional Work Experience

• Microsoft SQL Server skills including SSIS, SSAS, DW and Power BI

• ADF, Databricks and Azure synpase skills will be preffered

• Excellent E-Mail and phone communication skills

• Experience in guiding BI Support Engineers

• Experience in global environment

• Ability to read code and support applications, reports and processes

• Excellent analytical and problem-solving skills

• Ability to contribute both independently and as part of a team

• Excellent listening, communication, interperson

• Excellent analytical and problem-solving skills

Looking for a strong Microsoft SQL Server + SSIS resource with L1, L2, L3 (mix) Production Support experience. Role is 75% support and 25% development. Candidate should be able to troubleshoot existing SQL code, ETL jobs, incidents, and perform RCA. Power BI is only 10%. Please prioritize SQL Support Engineers, SSIS Developers, and SQL Developers with production support exposure

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

Role Summary

We are looking for an accomplished PowerBi Solution architect to architect and drive scalable, insight-rich analytics solutions across the enterprise. This role sits at the intersection of data engineering, business intelligence, and solution architecture—ideal for a candidate with mastery of modern visualization tools, modeling strategies, and end-to-end data integration.

Key Responsibilities

● Architect and implement scalable Power BI solutions that span data modeling, integration, visualization, and performance tuning

● Design and lead the development of enterprise-grade data models using Star, Snowflake, and composite architecture

● Lead the integration of cloud-based data warehouse platforms including Oracle ADW and Snowflake

● Lead the development of scalable, interactive dashboards using Power BI, driving self-service analytics across business units

● Develop ETL and ELT pipelines to ingest and transform structured, semi-structured, and API-driven data sources

● Implement automated data ingestion and transformation using Python and shell scripting for performance and reliability

● Handle and harmonize data from diverse API sources across applications, platforms, and third-party services

● Deliver interactive dashboards and storytelling experiences tailored for executives, analysts, and operational teams

● Optimize semantic layers, DAX calculations, and deployment pipelines for reusability and governance

● Mentor BI developers and analysts, setting architectural standards and fostering collaboration across analytics teams

● Collaborate with cross-functional teams to translate strategic business goals into robust analytics solutions

Required Qualifications

● 8+ years in Power BI development and analytics Engineering, with 3+ years in architecture leadership roles

● Strong command of DAX, M Query, and performance tuning best practices

● Deep experience in data modeling (Star, Snowflake, composite) and cross-platform architecture

● Hands-on expertise in Oracle ADW, Snowflake, and API-based data ingestion

● Proficiency in Python, shell scripting, and automation of analytics pipelines

● Strong background in ETL/ELT development, data quality assurance, and deployment orchestration

● Demonstrated success in solution architecture across cloud ecosystems such as Azure, Oracle OCI

Preferred Skills

● Experience with Power BI Premium capacity management and deployment pipelines

● Experience with DAX, M language, and performance tuning technique

● Experience integrating third-party BI tools, data lakehouses, and stream processing services

● Effective communicator capable of translating technical architecture into business value

● Exposure to MS Fabric and Azure Data Factor

Key Responsibilities

• Lead end-to-end data migration initiatives, including assessment, planning, mapping, transformation, validation, and reconciliation.
• Define and implement data governance frameworks, standards, policies, and processes.
• Design and manage data solutions using Microsoft Azure Data Services.
• Lead development of BI dashboards, reports, KPIs, and analytics solutions.
• Work with business and technical stakeholders to understand reporting and data requirements.
• Develop and maintain data models, data pipelines, ETL/ELT processes, and reporting architecture.
• Ensure data quality, consistency, integrity, security, and compliance throughout migration and reporting processes.
• Identify data risks, dependencies, gaps, and migration challenges and drive their resolution.
• Establish data validation and reconciliation mechanisms to ensure migration accuracy.
• Provide technical leadership and guidance to data engineers, BI developers, and other project team members.
• Collaborate with application, cloud, infrastructure, and business teams during project implementation.
• Monitor data migration and BI deliverables against project timelines, quality standards, and business objectives.
• Prepare technical documentation, data dictionaries, mapping documents, governance guidelines, and project reports.

Required Skills & Experience

• 7+ years of experience in data, migration, BI, or related technology roles.
• Strong experience working on software/IT projects and managing data-related workstreams.
• Hands-on experience with Microsoft Azure Data Services.
• Strong understanding of data migration methodologies, ETL/ELT, data transformation, and reconciliation.
• Experience in Data Governance, Data Quality, Master Data, Metadata Management, and Data Security.
• Strong experience with BI reporting and dashboard development.
• Good understanding of SQL and relational databases.
• Experience with Power BI and data visualization is highly desirable.
• Knowledge of Azure services such as Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure SQL Database, or equivalent.
• Strong understanding of data architecture and data lifecycle management.
• Excellent stakeholder management, communication, analytical, and problem-solving skills.

Job Summary

The Technical Lead will be responsible for overseeing and leading projects related to Azure Data Factory (ADF), Azure Databricks, SQL, Oracle PL/SQL, and Python. The role involves designing, developing, and implementing data solutions while ensuring they meet the business requirements and align with best practices. (1.) Key Responsibilities

1. Lead and manage end-to-end data engineering projects using azure data factory, azure databricks, sql, oracle pl/sql, and python.

2. Collaborate with stakeholders to gather and understand requirements for data pipelines and analytics solutions.

3. Design and develop etl processes, data models, and data integration solutions.

4. Provide technical guidance and mentorship to the team members.

5. Ensure data quality, data governance, and data security standards are maintained throughout the project lifecycle.

6. Troubleshoot and optimize data pipelines and processes for performance and efficiency.

7. Stay updated on the latest trends and technologies in data engineering and contribute to continuous improvement efforts.

Skill Requirements

1. Proficiency in azure data factory (adf) and azure databricks for building and managing data pipelines.

2. Strong experience with sql and oracle pl/sql for data querying and manipulation.

3. Advanced programming skills in python for scripting and data processing tasks.

4. Knowledge of data modeling, data warehousing concepts, and database design principles.

5. Ability to work in a collaborative team environment and communicate effectively with stakeholders.

6. Strong analytical and problem-solving skills with attention to detail.

7. Experience in data visualization tools and techniques is a plus.

Certifications: Relevant certifications in Azure Data Factory, Azure Databricks, SQL, Oracle PL/SQL, or Python are advantageous.

Skill (Primary)

Data Fabric-Azure-Azure Data Factory (ADF)

Job Description

• Design and Implement Data Solutions: Lead the design, development, and implementation of scalable and secure Azure-

based data platforms, ensuring integration with various data sources and business systems. Deliver at least 2 major

projects every year with a focus on data engineering best practices.

• Optimize Data Pipelines: Build and optimize end-to-end data pipelines using Azure Data Factory, Azure Databricks, and

Azure Synapse, with an emphasis on automating data workflows. Achieve a 20% reduction in pipeline execution times

within the first 6 months.

• Cloud Infrastructure Management: Manage and maintain the Azure data environment, ensuring high availability, disaster

recovery, and cost optimization. Track and improve system uptime to exceed 99.9% reliability.

• Collaborate with Cross-Functional Teams: Partner with data scientists, data analysts, and business stakeholders to translate

business requirements into efficient data solutions. Facilitate at least 3 collaborative sessions per quarter to address key

business use cases.

• Ensure Data Security & Compliance: Implement data security measures, ensuring compliance with industry regulations

(GDPR, HIPAA, etc.) and company policies. Achieve and maintain full compliance in all data environments within the first

quarter of onboarding.

• Continuous Learning & Knowledge Sharing: Stay up-to-date with emerging Azure technologies, and mentor junior

engineers to promote knowledge sharing. Complete 1 Azure certification annually and conduct at least 2 internal

knowledge-sharing sessions per year.

• Sound knowledge of data governance practices, data quality management, and data security principles.

• Play a pivotal role in shaping our organization's data-driven journey, driving innovation through data analytics and insights.

• Optimize data storage, processing and retrieval mechanisms for performance, cost, and scalability using data storage

services (such as Azure Data Lake Storage, Azure SQL Database, etc.), data processing services (such as Azure Data Bricks,

Azure Synapse, etc.) and data visualization (PowerBI, Qlik, etc.) & integration services (Data API builder, logic apps, etc.)

• Monitor and troubleshoot data platform performance, identify and resolve issues, and provide recommendations for

continuous improvement.

• Collaborate with DevOps teams to automate deployment, configuration, and monitoring processes using Azure DevOps,

PowerShell, or other relevant tools.

• Stay up to date with the latest trends and advancements in cloud data services and provide recommendations on adopting

new technologies or features to enhance the data platform.

• Document technical designs, procedures, and guidelines for data platform engineering and operations

Knowledge, Skills & Experience

Job Experience • Bachelor's degree in Computer Science, Engineering, or a related field. Advanced

degree preferred.

• Proven 6-10 years experience in playing platform engineer or admin role

• Experience with big data technologies such as Apache Spark, Hadoop, or similar

frameworks.

• Solid understanding of cloud computing concepts and experience with cloud

infrastructure management and provisioning.

• Solid understanding of network security concepts and technologies (such as

firewalls, VPNs, intrusion detection/prevention systems, etc.) and data security

concepts and technologies (such as access controls, encryption, observability,

privacy laws/regulations, etc.)

• Experience in a Retail setup is preferred.

Required Skills The position will require someone with the following:

• Strategic Planning

Public

• Communication and Collaboration

• Problem Solving Skills A/B testing & experimentation

• SQL, BI tools, and storytelling with data

Job Summary

We are seeking a skilled and detail-oriented Power BI Developer to design, develop, and maintain enterprise-level BI solutions. The ideal candidate should have strong expertise in Power BI, DAX, SQL, Data Modeling, and performance optimization tools such as DAX Studio, Tabular Editor, and ALM Toolkit. The candidate will collaborate with business stakeholders to transform data into actionable insights and deliver high-quality dashboards and reports.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Create complex DAX measures, calculated columns, and calculated tables to meet business requirements.
• Develop and optimize SQL queries, stored procedures, views, and ETL processes.
• Design and implement scalable Star Schema and Snowflake Data Models.
• Perform report and model performance tuning using DAX Studio.
• Utilize Tabular Editor for model management, calculation groups, best practice analysis, and metadata enhancements.
• Manage model deployment, comparison, and version control using ALM Toolkit.
• Configure and manage Power BI Workspaces, Apps, Gateways, and Security (RLS/OLS).
• Work extensively with Power BI Service/Web Experience, including dataset refresh schedules, deployment pipelines, subscriptions, and workspace administration.
• Collaborate with business users to gather and analyze reporting requirements.
• Ensure data accuracy, governance, security, and report performance.
• Troubleshoot data-related issues and implement effective solutions.
• Create technical documentation and provide knowledge transfer to support teams.

Required Skills

Technical Skills

• Strong experience in Microsoft Power BI Development.
• Expertise in DAX (Data Analysis Expressions).
• Advanced knowledge of SQL Server/T-SQL and query optimization.
• Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables).
• Hands-on experience with Tabular Editor.
• Experience using DAX Studio for model and query performance tuning.
• Experience with ALM Toolkit for model comparison and deployment.
• Strong understanding of Power BI Service/Web Experience.
• Knowledge of Power Query (M Language).
• Experience with Row-Level Security (RLS) and data governance.
• Understanding of data warehousing and ETL concepts.

Roles & Responsibilities

• Design, develop, and deliver scalable end-to-end data pipelines using Azure Data Factory, ensuring robust integration

of enterprise-wide data from diverse sources

• Build and optimize data engineering workflows using Databricks and PySpark

• Write efficient, high-performance SQL for data transformation and analysis

• Work with the Azure Cloud platform and associated services, applying strong understanding of data warehousing,

data models, and pipelines

• Provide technical leadership to a team of developers, including code reviews and enforcing best practices across the

development lifecycle

• Oversee CI/CD implementation using Azure DevOps, managing deployments across development, QA, and production

environments with proper change control processes

• Collaborate with cross-functional teams to translate business requirements into scalable data solutions

• Ensure data quality, reliability, and performance across all pipelines and platforms

Ideal Candidate

1Strong Azure Databricks Engineer / Senior Data Engineer Profile

2Mandatory (Experience 1) – Must have minimum 8+ years of overall experience in Data Engineering, Data Development, or related data technology roles, with strong hands-on experience in enterprise data pipeline development.

3Mandatory (Experience 2) – Must have strong hands-on experience with Azure Databricks, including development and optimization of scalable data engineering workflows using Databricks and PySpark.

4Mandatory (Experience 3) – Must have strong hands-on proficiency in PySpark/Python and SQL, with proven experience developing complex data transformations, processing workflows, and performance-optimized queries.

5Mandatory (Experience 4) – Must have hands-on experience with Azure Data Factory (ADF) for designing, developing, and orchestrating end-to-end data pipelines and integrating data from multiple sources.

6Mandatory (Experience 5) – Must have strong experience working on the Azure Cloud platform and associated data services, with solid understanding of data warehousing, data modeling, pipeline architecture, and enterprise data solutions.

7Mandatory (Experience 6) – Must have hands-on experience implementing CI/CD using Azure DevOps, including deployment and release management across development, QA, and production environments.

8Mandatory (Experience 7) – Must have proven technical leadership experience, including code reviews, enforcing development best practices, mentoring developers, and providing technical guidance to a data engineering team.

9Mandatory (Notice Period) – Immediate joiners or candidates who can join within 15 days.

10Mandatory (Note) - The position is open across all Cognizant offices pan India. Candidates must be willing to attend the F2F interview at the nearest Cognizant office location.