01Key Responsibilities
- Design, develop, automate, maintain and enhance BI products from wing to wing, including gathering clear requirements, programming/data pulling, ETL, automation, product delivery, and maintaining documentation/job aide.
- Daily use of SQL, SAS, and Python (future), ensuring consistent definitions and process governance.
- Drive measurable operational efficiency and standard processes for BI product delivery.
- Deliver on projects and initiatives, assigned by VP Business Intelligence and management to advance team and business priorities, including new partner onboarding and Cloud/AI journey.
- Be an SME and business consultant by understanding business needs and performance trends; share analytical thinking with solutions translating needs into insights and recommendations.
- Upgrade knowledge on BI technical and functional advancements (AI) and deploy learnings on existing and future deliverables be the SME and trainer to teams.
- Collaborate with US and India cross functional teams (including Tech, Finance, Marketing) to strengthen BI practice.
- Engage in meetings with internal and external stakeholders.
- Optimize performance of BI solutions (query tuning, extract strategies, aggregations, incremental refresh patterns) and support scalability.
- Translate user stories and acceptance criteria into technical design and build tasks; provide LOE estimates and highlight dependencies/risks.
- Partner with stakeholders to clarify business questions, identify underlying decision needs, and propose the most appropriate BI solution (dashboard, dataset, alerting, or standardized report).
- Document metric definitions, business logic, data sources, refresh cadence, and known limitations; maintain dashboard/report documentation for supportability.
- Apply access and security requirements (e.g., row-level security concepts, permission) as defined by platform standards and in coordination with administrators.
Required Skills & Knowledge:
- Minimum 4+ years of hands-on experience in creating BI, reporting and data visualization solutions through tools such as Tableau, Power BI, or similar BI/visualization platforms and BI best practices (performance, usability, basic security/access concepts).
- Minimum 4+ years of hands-on experience with SAS programing language and with relational databases (SQL, MySQL, PostgreSQL, SQL Server) for validation, reconciliation, and data-driven decisioning.
- Deep understanding of data modeling concepts (schemas, dimensional modeling basics) and data warehousing fundamentals (e.g., Data Lakes, Snowflake, AWS Redshift).
- Working knowledge of data warehousing/lakehouse concepts, ETL patterns, and data modeling .
