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 :
Support secure integration with internal systems (intranet, cloud platforms).Implement identity and access management best practices.Planning & Execution OwnershipAnalytics 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.(ref : hirist.tech)