BI & Data Warehouse Architect

3 weeks ago


Bengaluru, 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.

  • Bengaluru, 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...


  • Bengaluru, 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...

  • (15h Left) BI

    7 days ago


    Bengaluru, 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...


  • Bengaluru, Karnataka, India Applicantz Full time

    Job DescriptionWe are seeking a highly skilled Data Warehouse Architect to join our team at Applicantz.As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining large-scale data warehouses using Snowflake.The ideal candidate will have 5+ years of experience in designing, developing, testing, and...

  • BI Architect

    7 months ago


    Bengaluru, India Siemens Healthineers Full time

    The Power BI Architect oversees the BI strategy & projects including the Design, Deployment, Administration and Support of the Microsoft BI stack. Collaborates on database integration and architecture including dimensional data modeling, database design and ETL development. - RESPONSIBILITIES AND TASKS: - Design, develop and implement business intelligence...

  • BI Architect

    5 days ago


    Bengaluru, India Siemens Healthineers Full time

    The Power BI Architect oversees the BI strategy & projects including the Design, Deployment, Administration and Support of the Microsoft BI stack. Collaborates on database integration and architecture including dimensional data modeling, database design and ETL development. RESPONSIBILITIES AND TASKS: - Design, develop and implement business intelligence...


  • Bengaluru, India Senior .Net Developer Full time

    Data Warehouse ArchitectAbout Noesys Software :We at Noesys, through our product Infoveave, provide Analytics and Automation solutions for businesses. Infoveave makes it easy for companies to manage all their data in one place, keep track of their performance at various levels, and automate critical front and back-office processes. Infoveave is a...


  • Bengaluru, Karnataka, India Senior .Net Developer Full time

    About the Role:We are seeking a highly skilled Data Warehouse Architect to join our team. This individual will be responsible for designing and implementing data warehousing systems, developing ETL processes, and maintaining database scripts.Key Responsibilities:Design and implement data warehousing systems to meet business requirements.Develop ETL processes...

  • BI Architect

    1 week ago


    Bengaluru, India Solutionec Full time

    **About us** We are professional, agile, innovative and our goal is to SOLUTION EXCELLENCE CENTER We provide a unique blend of data savvy, industry expertise and technological excellence that allows global healthcare companies to improve their core operations and launch new business models.. Our work environment includes: - Modern office setting - Food...

  • Power BI Architect

    1 week ago


    Bengaluru, India kosmix IT services Pvt Ltd Full time

    **POWER BI ARCHITECT** **Job Location**: Hyderabad/ Bengaluru, India Are you interested in solving complex business problems with the help of data and insights? Would you like a C-suite focused business advisory experience in the field of data & analytics? Do you want to be a part of a change that is sweeping the business environments of today? If yes,...


  • Bengaluru, Karnataka, India Wipro Full time

    At Wipro, we are seeking a highly skilled Data Warehouse Architect to join our team. This is an exciting opportunity to work with cutting-edge technology and contribute to the design and development of data warehouses that drive business growth.We estimate the salary for this role to be around $120,000 per year, based on industry standards and location.About...

  • Data Warehouse Expert

    7 months ago


    Bengaluru, Karnataka, India PradeepIT Consulting Services Full time

    **About the job Data Warehouse Expert**: Timing: 12 PM to 8PM Rounds of Interviews: 3 to 4 **_ Position Overview:_** As a Senior Data Warehouse Expert, you will play a critical role in the development and implementation of an Operational Data Warehouse (OEDW) system for our client. This initiative aims to create a Single Source of Truth (SSOT) for their...


  • Bengaluru, Karnataka, India Sourcebae Full time

    We are seeking an experienced Enterprise Data Warehouse Architect with strong expertise in Snowflake and AWS. This role is crucial for managing and optimizing data warehouse operations, requiring a deep understanding of cloud-based tools and technologies.


  • Bengaluru, Karnataka, India GyanSys Inc. Full time

    GyanSys Inc. is a global technology consulting company looking to expand its expertise in data analytics by hiring an experienced Lead - Data Architect who can spearhead our Azure Databricks and Power BI initiatives.As a seasoned professional, you will be responsible for designing, developing, and implementing large-scale data warehouse solutions using Azure...

  • Power BI + Grafana

    7 months ago


    Bengaluru, India sureminds solutions PVT Ltd Full time

    The Solution Architect, D&T, Power BI possesses in-depth knowledge and experience to work autonomously and have responsibility for the overall design, development, and implementation of BI Applications. The role is proficient in the areas of solution design, development, performance tuning and troubleshooting. Working in a global environment, this role has a...


  • Bengaluru, Karnataka, India Sail Analytics Full time

    We are seeking a highly skilled Data Warehouse Architect at Sail Analytics to design, develop, test and maintain scalable data warehouses and data pipelines. About the RoleThe ideal candidate will have expertise in SQL, PySpark/Python and AWS, with a strong background in data engineering and architecture. The successful candidate will be responsible for...


  • Bengaluru, India Bloom Consulting Services Full time

    Bangalore, Hyderabad - Full Time, Full Time - Azure Data Architect, Azure data factory, Azure synopsis, Power BI Experience **10.0 - 20.0 Years** Offered Salary **18.00 - 40.00 Lakh** Notice Period **Not Disclosed** Specialities: Azure Cloud, Power BI, Office 365,.NET, SharePoint, Microsoft Technologies, Enterprise Mobility, SQL Server, Business...


  • Bengaluru, India Bloom Consulting Services Full time

    Bangalore, Hyderabad - Full Time, Full Time - Azure Data Architect, Azure data factory, Azure synopsis, Power BI Experience **10.0 - 20.0 Years** Offered Salary ** +91-XXXXXXXXXX Lakh** Notice Period **Not Disclosed** Specialities: Azure Cloud, Power BI, Office 365,.NET, SharePoint, shoppingmode Microsoft Technologies, Enterprise Mobility, SQL Server,...


  • Bengaluru, India Bloom Consulting Services Full time

    Bangalore, Hyderabad - Full Time, Full Time - Azure Data Architect, Azure data factory, Azure synopsis, Power BI Experience **10.0 - 20.0 Years** Offered Salary ** +91-XXXXXXXXXX Lakh** Notice Period **Not Disclosed** Specialities: Azure Cloud, Power BI, Office 365,.NET, SharePoint, Microsoft Technologies, Enterprise Mobility, SQL Server, Business...


  • Bengaluru, Karnataka, India Anthology, Inc. Full time

    Data Warehouse Architect **Bangalore, India** The Opportunity: Anthology offers the largest EdTech ecosystem on a global scale, supporting over 150 million users in 80 countries. Our mission is to provide dynamic, data-informed experiences to the global education community so that learners and educators can achieve their goals. We believe in the power of...