BI & Data Warehouse Architect

1 week ago


Bangalore Urban, India Calfus Inc. Full time

About Calfus

Calfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale.

Our core focus lies in creating engineered digital solutions that bring about a tangible and positive impact on business outcomes. We stand for #Equity and #Diversity in our ecosystem and society at large. Connect with us at #Calfus and be a part of our extraordinary journey


Position Overview:

As a Business Intelligence & Data Warehouse Architect, you will play a pivotal role in designing and implementing comprehensive business intelligence solutions that empower our organization to make data-driven decisions. You will leverage your expertise in Power BI, Tableau, and ETL processes to create scalable architectures and interactive visualizations. This position requires a strategic thinker with strong technical skills and the ability to collaborate effectively with stakeholders at all levels.


Key Responsibilities:

  • BI Architecture & DWH Solution Design: Develop and design scalable BI Analytical & DWH Solution that meets business requirements, leveraging tools such as Power BI and Tableau.
  • Data Integration: Oversee the ETL processes using SSIS to ensure efficient data extraction, transformation, and loading into data warehouses.
  • Data Modelling: Create and maintain data models that support analytical reporting and data visualization initiatives.
  • Database Management: Utilize SQL to write complex queries, stored procedures, and manage data transformations using joins and cursors.
  • Visualization Development: Lead the design of interactive dashboards and reports in Power BI and Tableau, adhering to best practices in data visualization.
  • Collaboration: Work closely with stakeholders to gather requirements and translate them into technical specifications and architecture designs.
  • Performance Optimization: Analyse and optimize BI solutions for performance, scalability, and reliability.
  • Data Governance: Implement best practices for data quality and governance to ensure accurate reporting and compliance.
  • Team Leadership: Mentor and guide junior BI developers and analysts, fostering a culture of continuous learning and improvement.
  • Azure Databricks: Leverage Azure Databricks for data processing and analytics, ensuring seamless integration with existing BI solutions.

Qualifications:

  • Bachelor’s degree in computer science, Information Systems, Data Science, or a related field.
  • 7-15 years of experience in BI architecture and development, with a strong focus on Power BI and Tableau/Looker.
  • Should have experience in working with ERP (Oracle EBS, SAP, Netsuite) and CRM (Salesforce) as data sources for BI Solutions
  • Should have worked on data integration: Azure/Data Factory, DBT/Fivetran, Python, SQL
  • Proven experience with ETL processes and tools, especially SSIS. Strong proficiency in SQL Server, including advanced query writing and database management.
  • Exploratory data analysis with Python
  • Familiarity with the CRISP-DM model
  • Ability to work with different data models like
  • Familiarity with databases like Azure Database, Snowflake/Big Query, Postgres, Redshift & Mongo DB, DW Concept Star Schema.
  • Experience with visualization tools such as Power BI, Quick sight and Plotly and or Dash
  • Strong programming foundation with Python with versatility to handle as :

Data Manipulation and Analysis: using Pandas, NumPy & PySpark, data serialization & formats like JSON, CSV and Parquet & Pickle. Database interaction to query cloud-based data warehouses

Data Pipeline and ETL tools like Airflow for orchestrating workflows and, managing ETL pipeline Scripting and automation. Cloud services & tools such as S3, AWS Lambda to manage cloud infrastructure. Azure SDK is a plus

  • Code quality and management using version control and collaboration in data engineering projects
  • Ability to interact with REST API’s and perform web scraping tasks is a plus


Calfus Inc. is an Equal Opportunity Employer.

That means we do not discriminate against any applicant for employment, or any employee because of age, colour, sex, disability, national origin, race, religion, or veteran status. All employment is decided based on qualifications, merit, and business need.



  • Bangalore Urban, India Calfus Inc. Full time

    About CalfusCalfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale.Our core focus lies in creating...


  • Bangalore, India Calfus Inc. Full time

    About Calfus Calfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale. Our core focus lies in...

  • Calfus Inc. | BI

    1 week ago


    bangalore, India Calfus Inc. Full time

    About CalfusCalfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale.Our core focus lies in creating...

  • Calfus Inc. | BI

    1 week ago


    bangalore, India Calfus Inc. Full time

    About Calfus Calfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale. Our core focus lies in creating...


  • Bangalore, India GyanSys Inc. Full time

    Dear Candidate, Gyan Sys is looking for Lead/Architect - Azure Databricks for our overseas customers consulting Projects based in Americas/Europe/APAC region. Please apply for the job role or Share your CV directly to Responsibilities: Position: Lead/Architect - Azure Databricks Relevant experience: 7 to 13 Years Primary Skills: Azure Databricks,...


  • bangalore, India GyanSys Inc. Full time

    Dear Candidate,GyanSys is looking for Lead/Architect - Azure Databricks for our overseas customers consulting Projects based in Americas/Europe/APAC region. Please apply for the job role or Share your CV directly to Responsibilities:Position: Lead/Architect - Azure DatabricksRelevant experience: 7 to 13 YearsPrimary Skills: Azure Databricks, Hadoop,...

  • Data architect

    1 week ago


    Bangalore, India MPACT TRAINING AND DEVELOPMENT Full time

    We are seeking experienced, motivated andenthusiastic Data Architect to join our team. As part of the team, you will be involved in the implementation of the ongoing and new initiatives for our company and contribute to our mission of delivering high-quality data-driven solutions to our clients. Primary Skills: Snowflake, AWS/Azure data services, Data...

  • Lead Data Engineer

    1 month ago


    Bangalore Urban, India Calfus Inc. Full time

    About CalfusCalfus is a Silicon Valley headquartered software engineering and platforms company. The name Calfus finds its roots and ethos in the Olympic motto “Citius, Altius, Fortius – Communiter". Calfus seeks to inspire our team to rise faster, higher, stronger, and work together to build software at speed and scale.Our core focus lies in creating...


  • bangalore, India GyanSys Inc. Full time

    Dear Candidate, GyanSys is looking for Lead/Architect - Azure Databricks for our overseas customers consulting Projects based in Americas/Europe/APAC region. Please apply for the job role or Share your CV directly to Responsibilities: Position: Lead/Architect - Azure Databricks Relevant experience: 7 to 13 Years Primary Skills: Azure Databricks,...


  • bangalore, India Holiday Inn Club Vacations Full time

    At Holiday Inn Club Vacations, we believe in strengthening families. And we look for people who exhibit the courage, caring and creativity to help us become the most loved brand in family travel. We’re committed to growing our people, memberships, resorts, and guest love. That’s why we need individuals who are passionate in life and bring those qualities...


  • Bangalore, India Holiday Inn Club Vacations Full time

    At Holiday Inn Club Vacations, we believe in strengthening families. And we look for people who exhibit the courage, caring and creativity to help us become the most loved brand in family travel. We’re committed to growing our people, memberships, resorts, and guest love. That’s why we need individuals who are passionate in life and bring those...


  • bangalore, India Holiday Inn Club Vacations Full time

    At Holiday Inn Club Vacations, we believe in strengthening families. And we look for people who exhibit the courage, caring and creativity to help us become the most loved brand in family travel. We’re committed to growing our people, memberships, resorts, and guest love. That’s why we need individuals who are passionate in life and bring those qualities...


  • bangalore, India Holiday Inn Club Vacations Full time

    At Holiday Inn Club Vacations, we believe in strengthening families. And we look for people who exhibit the courage, caring and creativity to help us become the most loved brand in family travel. We’re committed to growing our people, memberships, resorts, and guest love. That’s why we need individuals who are passionate in life and bring those qualities...


  • Bangalore, India Holiday Inn Club Vacations Full time

    At Holiday Inn Club Vacations, we believe in strengthening families. And we look for people who exhibit the courage, caring and creativity to help us become the most loved brand in family travel. We’re committed to growing our people, memberships, resorts, and guest love. That’s why we need individuals who are passionate in life and bring those...

  • Data Architect

    1 week ago


    Bangalore, India MPACT TRAINING AND DEVELOPMENT Full time

    We are seeking experienced, motivated andenthusiastic Data Architect to join our team. As part of the team, you will be involved in the implementation of the ongoing and new initiatives for our company and contribute to our mission of delivering high-quality data-driven solutions to our clients. Primary Skills: Snowflake, AWS/Azure data services, Data...

  • Data Architect

    1 week ago


    Bangalore, India MPACT TRAINING AND DEVELOPMENT Full time

    We are seeking experienced, motivated andenthusiastic Data Architect to join our team. As part of the team, you will be involved in the implementation of the ongoing and new initiatives for our company and contribute to our mission of delivering high-quality data-driven solutions to our clients. Primary Skills: Snowflake, AWS/Azure data services, Data...

  • Power BI Architect

    1 month ago


    Bengaluru / Bangalore, Pune, India Brain Management Consultants India Private Limited Full time

    As a BI Architect specializing in Power BI, you will be responsible for designing and implementing scalable and efficient BI solutions that leverage the full capabilities of Power BI. You will work closely with business stakeholders to understand requirements, define technical specifications, and architect solutions that meet business objectives. The ideal...

  • GCP Data Architect

    2 months ago


    Bangalore Urban, India Tech Mahindra Full time

    Looking for GCP Data Architect. Over all exp :12-18yrs Location : Pan India. Interested please share resume. Minimum of 5 years of experience in a Data Architect role, supporting warehouse and Cloud data platforms/environments. Experience with common GCP services such as BigQuery, Dataflow, dataproc, GCS, Cloud Function and related CI/CD processes Strong...


  • Bangalore, India Quantiphi Full time

    Role: Associate Architect BI Experience: 6 to 9 years Location: Mumbai/Bangalore/Trivandrum Tableau Expertise: Advanced skills in designing and managing Tableau dashboards. Cognos Proficiency: Deep understanding of Cognos report structures and functionalities (Good to have) Domain Knowledge: Insurance domain knowledge (Good to have) Data Analysis: Strong...

  • Associate Architect

    7 months ago


    bangalore, India Quantiphi Full time

    Role: Associate Technical Architect - DataExperience Level: 6 to 9 YearsWork location: Mumbai, Bangalore, Trivandrum (Hybrid)Role & Responsibilities:5+ years of experience in building and managing Data Lakes, Data Warehouse, Data Integration, Data Migration and Business Intelligence/Artificial Intelligence solutions on Cloud (GCP/AWS/Azure)Ability to...