Configure automated data refresh and ensure end-to-end reliability.

Provide comprehensive documentation of the connection architecture.

Note: The offshore team will not be responsible for building Power BI dashboards or reports.

Deliverables :

- Secure data pipeline setup.

- Automated refresh configuration.

- Documented architecture and integration steps.

Security Integrations :

- The team must bring strong expertise in :

1. Azure Active Directory (Azure AD) - identity and access management.

2. Microsoft Entra - security and identity integrations.

3. AWS IAM - roles, policies, and cross-platform integrations.

Responsibilities :

- Support secure integration with internal systems (intranet, cloud platforms).

- Implement identity and access management best practices.

- Planning & Execution Ownership

- Analytics Engineers (AEs): define the what (scope, goals, objectives).

- Offshore Team: owns the how (planning, technical approach, execution).

- Offshore team must play back their plan to both the AEs and Infra Squad for alignment and feedback.

Solution Design :

The offshore team is responsible for :

- Developing solution designs for all assigned workstreams.

- Presenting the design to AEs for validation and feedback.

- Sharing the design with the Infra Squad to ensure technical alignment and implementation feasibility.

- Terraform - for infrastructure as code (IaC) and automation of environment setup.

- Power BI Infrastructure & Platform Configurations - focus on secure connectivity with Snowflake (not dashboard/report building).

- Snowflake - platform management, integrations, and connectivity setup.

- Security Integrations - Azure Active Directory (Azure AD), Microsoft Entra, AWS IAM.

- AWS - platform knowledge for integrations and security.

- DBT - for data transformations and modeling in Snowflake.

- MicroStrategy (optional) - familiarity with platform integration.