Note: The job is a remote job and is open to candidates in USA. Prodege is a marketing and consumer insights platform that helps brands, marketers, and agencies gather insights, acquire customers, and improve revenue and loyalty. The Staff Business Intelligence Analyst will build trusted datasets, analytics models, dashboards, semantic models, and self-service reporting solutions using Snowflake, dbt, and Sigma. The role partners with cross-functional teams to improve data quality, reporting reliability, and data-driven decision-making.
Responsibilities
- Design, build, and maintain dashboards, reports, and analytics products that support business decision-making
- Develop and maintain analytics data models using dbt and Snowflake
- Build trusted datasets and reusable reporting assets that enable scalable self-service analytics
- Partner with Product, Marketing, Finance, Analytics, and business stakeholders to translate reporting needs into scalable BI solutions
- Implement KPI definitions and reporting standards established across the organization
- Optimize SQL queries, analytics models, and reporting performance
- Validate data quality through testing, monitoring, and documentation
- Support executive reporting and operational dashboards
- Collaborate with Data Engineering to improve data pipelines and data availability
- Troubleshoot reporting issues and continuously improve platform reliability
- Contribute to analytics engineering best practices including testing, documentation, version control, and code reviews
- Use AI-assisted development tools to improve SQL development, documentation, reporting workflows, and analytics productivity
- Mentor junior BI engineers and analytics engineers while sharing technical knowledge across the team
Skills
- * Bachelor's degree in Computer Science, Engineering, Analytics, a quantitative discipline, or equivalent practical experience * Four or more (4+) years of experience in Business Intelligence, Analytics Engineering, Data Analytics, or a related field * Strong SQL skills with experience writing and optimizing complex analytical queries * Hands-on experience with Snowflake or another modern cloud data warehouse * Experience using dbt or similar analytics engineering frameworks * Experience building dashboards and reports using Sigma, Tableau, Looker, Power BI, or comparable BI platforms * Experience in AdTech, Performance Marketing, MarTech, marketplaces, or consumer internet businesses * Strong understanding of dimensional modeling and analytics engineering best practices * Experience developing reusable datasets and scalable reporting solutions * Understanding of KPI implementation, reporting consistency, and trusted business metrics * Strong analytical and problem-solving skills * Experience partnering with cross-functional stakeholders to gather requirements and deliver analytics solutions * Excellent communication skills with the ability to explain technical concepts to non-technical audiences * Experience using AI-assisted development tools to improve SQL development, documentation, or reporting workflows * Ability to manage multiple priorities in a fast-paced environment
- * Experience supporting experimentation platforms, A/B testing, or product analytics * Familiarity with Iceberg or modern lakehouse technologies * Experience improving BI performance, query optimization, and cost efficiency * Experience implementing data quality testing and analytics engineering best practices * Exposure to semantic modeling, reporting governance, and analytics documentation * Experience mentoring junior BI engineers or analysts * Familiarity with AI-first analytics workflows and modern BI engineering practices
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Short-term disability (STD) insurance
- Long-term disability (LTD) insurance
- Basic life insurance
- Flexible PTO
- Paid sick leave prorated based on hire date
- Eight paid holidays throughout the calendar year for US employees
Company Overview
Company H1B Sponsorship