Business Intelligence Engineer - Data Analytics (5-15 yrs)

AWS Business Intelligence Engineer Responsibilities :

The business intelligence engineer will be responsible for design, development and maintenance of ongoing data pipelines, metrics, reports, visualizations, analyses, dashboards etc to drive business decisions. The candidate will own data integration including connecting to multiple data sources and developing efficient ETL processes. In addition, they will bring in best practices of data warehousing to ensure data is stored securely and easily accessible.

They should also be able to monitor data pipelines to ensure data integrity & availability and be adept at troubleshooting as and when needed.

Key Deliverables/Outcomes :

- Seamless integration of data from multiple sources into a unified system

- Create and streamline redshift cluster & S3 to ensure easy data access and flows

- Efficient and reliable data storage & access

- Building AWS data catalog available to AWS SageMaker and other data tools

- Clear documentation of the code and artifacts.

- Comprehensive dashboards and reports providing stakeholders with valuable insights

- Own Variance diagnostic tool to proactively identify pockets of high forecasting variance.

Qualifications Needed :

- 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

- Experience with Spark and PySpark querying language for big data technology

- Experience with AWS data catalogue and AWS Glue is an asset

- Experience with data visualization using Tableau, Quicksight, or similar tools

- Experience with building and maintain basic data artifacts (e.g. ETL, data models, queries)

- Experience with scripting language (e.g., Python, Java, or R)

- Knowledge of how to improve code quality and optimizes BI processes (e.g. speed, cost, reliability)

- Experience with statistical analysis, co-relation analysis