BI & Analytics Data Specialist

As a Data Engineer BI Analytics & DWH at Calfus, you will play a crucial role in constructing scalable data infrastructure and efficient data pipelines to support our business intelligence and analytics capabilities. With 37 years of experience in ETL/ELT development, data modeling, and database design, you will contribute to data warehousing and data lake initiatives. Additionally, you will aid in enabling data visualization through tools like Tableau or Power BI. **What Youll Do:** - **ETL/ELT Development:** - Design, build, and maintain efficient ETL and ELT processes using tools such as Azure Data Factory, Databricks, or similar orchestration frameworks. - Ensure reliable data ingestion from various sources into centralized storage systems (DWH/data lakes). - **Data Modeling & Warehousing:** - Design relational and dimensional data schemas tailored to business use cases in data lakes or traditional data warehouses (e.g., Snowflake, Redshift, Postgres). - Develop and maintain data models optimized for analytics and reporting. - **Database Engineering:** - Write efficient SQL queries and stored procedures to transform, clean, and aggregate data. - Manage data transformations and complex joins to support analytical workloads. - **BI & Visualization Support:** - Provide basic support for report and dashboard development in visualization tools such as Tableau or Power BI. - Collaborate with analysts and business users to understand reporting needs and enable self-service BI. - **Performance & Data Quality:** - Monitor and troubleshoot data pipelines and warehouse jobs to ensure timely and accurate data availability. - Apply basic data quality checks and validations to ensure trustworthiness of data outputs. **On your first day, we'll expect you to have:** - Bachelors degree in Computer Science, Information Systems, Data Engineering, or a related field. - 37 years of experience in data engineering with hands-on ETL/ELT development and data modeling. - Solid SQL skills and experience with database systems such as SQL Server, Postgres, Snowflake, or Redshift. - Exposure to cloud-based services and data tools (e.g., AWS S3, Azure Data Factory, Databricks, Lambda functions). - Basic understanding of data serialization formats like JSON, Parquet, or CSV. - Familiarity with Python for scripting and data manipulation. - Bonus: Exposure to visualization tools such as Power BI, Tableau for dashboard/report creation will be a plus. **Benefits:** Calfus values its employees and offers a strong benefits package, including medical, group, and parental insurance, along with gratuity and provident fund options. Additionally, we support employee wellness and provide birthday leave as a valued benefit. Calfus is an Equal Opportunity Employer. We believe diversity drives innovation and are committed to creating an inclusive workplace where everyone has the opportunity to thrive, regardless of background, identity, or experience. All applicants are welcome to apply. As a Data Engineer BI Analytics & DWH at Calfus, you will play a crucial role in constructing scalable data infrastructure and efficient data pipelines to support our business intelligence and analytics capabilities. With 37 years of experience in ETL/ELT development, data modeling, and database design, you will contribute to data warehousing and data lake initiatives. Additionally, you will aid in enabling data visualization through tools like Tableau or Power BI. **What Youll Do:** - **ETL/ELT Development:** - Design, build, and maintain efficient ETL and ELT processes using tools such as Azure Data Factory, Databricks, or similar orchestration frameworks. - Ensure reliable data ingestion from various sources into centralized storage systems (DWH/data lakes). - **Data Modeling & Warehousing:** - Design relational and dimensional data schemas tailored to business use cases in data lakes or traditional data warehouses (e.g., Snowflake, Redshift, Postgres). - Develop and maintain data models optimized for analytics and reporting. - **Database Engineering:** - Write efficient SQL queries and stored procedures to transform, clean, and aggregate data. - Manage data transformations and complex joins to support analytical workloads. - **BI & Visualization Support:** - Provide basic support for report and dashboard development in visualization tools such as Tableau or Power BI. - Collaborate with analysts and business users to understand reporting needs and enable self-service BI. - **Performance & Data Quality:** - Monitor and troubleshoot data pipelines and warehouse jobs to ensure timely and accurate data availability. - Apply basic data quality checks and validations to ensure trustworthiness of data outputs. **On your first day, we'll expect you to have:** - Bachelors degree in Computer Science, Information Systems, Data Engineering, or a related field. - 37 years of experience in data engineering