5+ Data modeling Jobs in Delhi, NCR and Gurgaon | Data modeling Job openings in Delhi, NCR and Gurgaon

Position Overview:

As a BI (Business Intelligence) Developer, they will be responsible for designing,

developing, and maintaining the business intelligence solutions that support data

analysis and reporting. They will collaborate with business stakeholders, analysts, and

data engineers to understand requirements and translate them into efficient and

effective BI solutions. Their role will involve working with various data sources,

designing data models, assisting ETL (Extract, Transform, Load) processes, and

developing interactive dashboards and reports.

Key Responsibilities:

1. Requirement Gathering: Collaborate with business stakeholders to understand

their data analysis and reporting needs. Translate these requirements into

technical specifications and develop appropriate BI solutions.

2. Data Modelling: Design and develop data models that effectively represent

the underlying business processes and facilitate data analysis and reporting.

Ensure data integrity, accuracy, and consistency within the data models.

3. Dashboard and Report Development: Design, develop, and deploy interactive

dashboards and reports using Sigma computing.

4. Data Integration: Integrate data from various systems and sources to provide a

comprehensive view of business performance. Ensure data consistency and

accuracy across different data sets.

5. Performance Optimization: Identify performance bottlenecks in BI solutions and

optimize query performance, data processing, and report rendering. Continuously

monitor and fine-tune the performance of BI applications.

6. Data Governance: Ensure compliance with data governance policies and

standards. Implement appropriate security measures to protect sensitive data.

7. Documentation and Training: Document the technical specifications, data

models, ETL processes, and BI solution configurations.

8. Ensuring that the proposed solutions meet business needs and requirements.

9. Should be able to create and own Business/ Functional Requirement

Documents.

10. Monitor or track project milestones and deliverables.

11. Submit project deliverables, ensuring adherence to quality standards.

Qualifications and Skills:

1. Master/ Bachelor’s degree in IT or relevant and having a minimum of 2-4 years of

experience in Business Analysis or a related field

2. Proven experience as a BI Developer or similar role.

3. Fundamental analytical and conceptual thinking skills with demonstrated skills in

managing projects on implementation of Platform Solutions

4. Excellent planning, organizational and time management skills.

5. Strong understanding of data warehousing concepts, dimensional modelling, and

ETL processes.

6. Proficiency in SQL, Snowflake for data extraction, manipulation, and analysis.

7. Experience with one or more BI tools such as Sigma computing.

8. Knowledge of data visualization best practices and ability to create compelling

data visualizations.

9. Solid problem-solving and analytical skills with a detail-oriented mindset.

10. Strong communication and interpersonal skills to collaborate effectively with

different stakeholders.

11. Ability to work independently and manage multiple priorities in a fast-paced

environment.

12. Knowledge of data governance principles and security best practices.

13. Candidate having experience in managing implementation project of platform

solutions to the U.S. clients would be preferable.

14. Exposure to U.S debt collection industry is a plus.

Review Criteria

• Strong Data / ETL Test Engineer
• 5+ years of overall experience in Testing/QA
• 3+ years of hands-on end-to-end data testing/ETL testing experience, covering data extraction, transformation, loading validation, reconciliation, working across BI / Analytics / Data Warehouse / e-Governance platforms
• Must have strong understanding and hands-on exposure to Data Warehouse concepts and processes, including fact & dimension tables, data models, data flows, aggregations, and historical data handling.
• Must have experience in Data Migration Testing, including validation of completeness, correctness, reconciliation, and post-migration verification from legacy platforms to upgraded/cloud-based data platforms.
• Must have independently handled test strategy, test planning, test case design, execution, defect management, and regression cycles for ETL and BI testing
• Hands-on experience with ETL tools and SQL-based data validation is mandatory (Working knowledge or hands-on exposure to Redshift and/or Qlik will be considered sufficient)
• Must hold a Bachelor’s degree B.E./B.Tech else should have master's in M.Tech/MCA/M.Sc/MS
• Must demonstrate strong verbal and written communication skills, with the ability to work closely with business stakeholders, data teams, and QA leadership
• Mandatory Location: Candidate must be based within Delhi NCR (100 km radius)

Preferred

• Relevant certifications such as ISTQB or Data Analytics / BI certifications (Power BI, Snowflake, AWS, etc.)

Job Specific Criteria

• CV Attachment is mandatory
• Do you have experience working on Government projects/companies, mention brief about project?
• Do you have experience working on enterprise projects/companies, mention brief about project?
• Please mention the names of 2 key projects you have worked on related to Data Warehouse / ETL / BI testing?
• Do you hold any ISTQB or Data / BI certifications (Power BI, Snowflake, AWS, etc.)?
• Do you have exposure to BI tools such as Qlik?
• Are you willing to relocate to Delhi and why (if not from Delhi)?
• Are you available for a face-to-face round?

Role & Responsibilities

• 5 years’ experience in Data Testing across BI Analytics platforms with at least 2 largescale enterprise Data Warehouse Analytics eGovernance programs
• Proficiency in ETL Data Warehouse and BI report dashboard validation including test planning data reconciliation acceptance criteria definition defect triage and regression cycle management for BI landscapes
• Proficient in analyzing business requirements and data mapping specifications BRDs Data Models Source to Target Mappings User Stories Reports Dashboards to define comprehensive test scenarios and test cases
• Ability to review high level and low-level data models ETL workflows API specifications and business logic implementations to design test strategies ensuring accuracy consistency and performance of data pipelines
• Ability to test and validate the migrated data from old platform to an upgraded platform and ensure the completeness and correctness of migration
• Experience of conducting test of migrated data and defining test scenarios and test cases for the same
• Experience with BI tools like Qlik ETL platforms Data Lake platforms Redshift to support end to end validation
• Exposure to Data Quality Metadata Management and Data Governance frameworks ensuring KPIs metrics and dashboards align with business expectations

Ideal Candidate

• 5 years’ experience in Data Testing across BI Analytics platforms with at least 2 largescale enterprise Data Warehouse Analytics eGovernance programs
• Proficiency in ETL Data Warehouse and BI report dashboard validation including test planning data reconciliation acceptance criteria definition defect triage and regression cycle management for BI landscapes
• Proficient in analyzing business requirements and data mapping specifications BRDs Data Models Source to Target Mappings User Stories Reports Dashboards to define comprehensive test scenarios and test cases
• Ability to review high level and low-level data models ETL workflows API specifications and business logic implementations to design test strategies ensuring accuracy consistency and performance of data pipelines
• Ability to test and validate the migrated data from old platform to an upgraded platform and ensure the completeness and correctness of migration
• Experience of conducting test of migrated data and defining test scenarios and test cases for the same
• Experience with BI tools like Qlik ETL platforms Data Lake platforms Redshift to support end to end validation
• Exposure to Data Quality Metadata Management and Data Governance frameworks ensuring KPIs metrics and dashboards align with business expectations

About the Role:

We are seeking a talented Data Engineer to join our team and play a pivotal role in transforming raw data into valuable insights. As a Data Engineer, you will design, develop, and maintain robust data pipelines and infrastructure to support our organization's analytics and decision-making processes.

Responsibilities:

• Data Pipeline Development: Build and maintain scalable data pipelines to extract, transform, and load (ETL) data from various sources (e.g., databases, APIs, files) into data warehouses or data lakes.
• Data Infrastructure: Design, implement, and manage data infrastructure components, including data warehouses, data lakes, and data marts.
• Data Quality: Ensure data quality by implementing data validation, cleansing, and standardization processes.
• Team Management: Able to handle team.
• Performance Optimization: Optimize data pipelines and infrastructure for performance and efficiency.
• Collaboration: Collaborate with data analysts, scientists, and business stakeholders to understand their data needs and translate them into technical requirements.
• Tool and Technology Selection: Evaluate and select appropriate data engineering tools and technologies (e.g., SQL, Python, Spark, Hadoop, cloud platforms).
• Documentation: Create and maintain clear and comprehensive documentation for data pipelines, infrastructure, and processes.

 Skills:

• Strong proficiency in SQL and at least one programming language (e.g., Python, Java).
• Experience with data warehousing and data lake technologies (e.g., Snowflake, AWS Redshift, Databricks).
• Knowledge of cloud platforms (e.g., AWS, GCP, Azure) and cloud-based data services.
• Understanding of data modeling and data architecture concepts.
• Experience with ETL/ELT tools and frameworks.
• Excellent problem-solving and analytical skills.
• Ability to work independently and as part of a team.

Preferred Qualifications:

• Experience with real-time data processing and streaming technologies (e.g., Kafka, Flink).
• Knowledge of machine learning and artificial intelligence concepts.
• Experience with data visualization tools (e.g., Tableau, Power BI).
• Certification in cloud platforms or data engineering.

• Lead multiple client projects in the organization. 
• Define & build technical architecture for projects. 
• Introduce & ensure right coding standards within the team and ensure that it is maintained in all the projects. 
• Ensure the quality delivery of projects. 
• Ensure applications are confirmed to security guidelines wherever required. 
• Assist pre-sales/sales team for converting raw requirements from potential clients to functional solutions. 
• Train fellow team members to impose the best practices available. 
• Work on improving and managing processes within the team. 
• Implement innovative ideas throughout the team to improve the overall efficiency and quality of the team. 
• Ensure proper communication & collaboration within the team 
  
  

7+ Years of experience in developing large scale applications. 
Solid Domain Knowledge and experience with various Design Patterns & Data Modelling (Associations, OOPs Concepts etc.)
Should have exposure to multiple backend technologies, and databases - both relational and NOSQL databases
Should be aware of latest conventions for APIs
Preferred hands-on experience with GraphQL as well as REST API
Must be well-aware of the latest technological advancements for relevant platforms. 
Advanced Concepts of Databases - Views, Stored Procedures, Database Optimization - are a good to have.
Should have Research Oriented Approach 
Solid at Logical thinking and Problem solving 
Solid understanding of Coding Standards, Code Review processes and delivery of quality products 
Experience with various Tools used in Development, Tests & Deployments. 
Sound knowledge of DevOps and CI/CD Pipeline Tools 
Solid experience with Git Workflow on Enterprise projects and larger teams 
Should be good at documentation at project level and code level ; Should have good experience with Agile Methodology and process
Should have a good understanding of server side deployment, scalability, maintainability and handling server security problems.
Should have good understanding on Software UX 
Proficient with communication and good at making software architectural judgments
Expected outcomes 

• Growing the team and retaining talent, thus, creating an inspiring environment for the team members. 
• Creating more leadership within the team along with mentoring and guiding new joiners and experienced developers. 
• Creating growth plans for the team and preparing training guides for other team members. 
• Refining processes in the team on a regular basis to ensure quality delivery of projects- such as coding standards, project collaboration, code review processes etc. 
• Improving overall efficiency and team productivity by introducing new methodologies and ideas in the team. 
• Working on R&D and employing innovative technologies in the company. 
• Streamlining processes which will result in saving time and cost optimization 
• Ensuring code review healthiness and shipping superior quality code 
  
  
  

• Unlimited learning and growth opportunities 
• A collaborative and cheerful work environment 
• Exceptional reward and recognition policy  
• Outstanding compensation  
• Flexible work hours  
• Opportunity to make an impact as your work will directly contribute to our business strategy.
  ​

At Nickelfox, you have a chance to craft a career path as unique as you are and become the best version of YOU. You will be part of a team with a ‘no limits’ mindset in an inclusive, people-focused culture. And we’re counting on your unique perspective to help Nickelfox grow even faster.  

Are you passionate about tech? Dedicated to learning? Come, join us to build an extraordinary experience for yourself and a dignified working world for all. 
 

What makes Nickelfox a great place for you?

In Nickelfox, you’ll join a team whose passion for technology and understanding of business has driven the company to serve clients across 25+ countries in just five years. We partner with our customers to fuel their growth story and enable them to make the right decisions with our customized technology services and insights. All in all, we are passionate to see our customers win the day. This is the reason why 80% of our business comes from repeat clients.  

Our mission is to provide dignified employment and an environment that recognizes the uniqueness of every individual and values their expertise, and contribution. We have a culture that encourages everyone to bring their authentic selves to work. Our people enjoy a collaborative work environment with exceptional training and career development. If you like working with a curious, youthful, high-performing team, Nickelfox is the place for you.

Job Title: Power BI Developer(Onsite)

Location: Park Centra, Sec 30, Gurgaon

CTC:        8 LPA

Time:       1:00 PM - 10:00 PM

Must Have Skills: 

• Power BI Desktop Software
• Dax Queries
• Data modeling
• Row-level security
• Visualizations
• Data Transformations and filtering
• SSAS and SQL

Job description:

We are looking for a PBI Analytics Lead responsible for efficient Data Visualization/ DAX Queries and Data Modeling. The candidate will work on creating complex Power BI reports. He will be involved in creating complex M, Dax Queries and working on data modeling, Row-level security, Visualizations, Data Transformations, and filtering. He will be closely working with the client team to provide solutions and suggestions on Power BI.

Roles and Responsibilities:

• Accurate, intuitive, and aesthetic Visual Display of Quantitative Information: We generate data, information, and insights through our business, product, brand, research, and talent teams. You would assist in transforming this data into visualizations that represent easy-to-consume visual summaries, dashboards and storyboards. Every graph tells a story.
• Understanding Data: You would be performing and documenting data analysis, data validation, and data mapping/design. You would be mining large datasets to determine its characteristics and select appropriate visualizations.
• Project Owner: You would develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions, and would be continuously reviewing and improving existing systems and collaborating with teams to integrate new systems. You would also contribute to the overall data analytics strategy by knowledge sharing and mentoring end users.
• Perform ongoing maintenance & production of Management dashboards, data flows, and automated reporting.
• Manage upstream and downstream impact of all changes on automated reporting/dashboards
• Independently apply problem-solving ability to identify meaningful insights to business
• Identify automation opportunities and work with a wide range of stakeholders to implement the same.
• The ability and self-confidence to work independently and increase the scope of the service line

Requirements: 

• 3+ years of work experience as an Analytics Lead / Senior Analyst / Sr. PBI Developer.
• Sound understanding and knowledge of PBI Visualization and Data Modeling with DAX queries
• Experience in leading and mentoring a small team.