About Us Straive (formerly SPi Global) is a global leader in AI-driven value creation, business transformation, and Global Capability Center (GCC) delivery empowering private-equity portfolio companies, mid-market firms, and enterprises with scalable, technology-enabled execution. We operationalize Data Analytics and AI for global enterprises, working with severalFortune 500 companies . We serve clients across industries, including Banking, Financial and Information Services, Retail, Media and Technology, EdTech, Science and Research, Logistics and Supply Chain, and Pharma & Life Sciences. Our strategically placedteam of 20,000+ employeesoperates in nine countries: the Philippines, India, the United States, Nicaragua, Vietnam, the United Kingdom, Singapore, South Africa, and Canada. Job Description We are seeking a seasonedSenior BI Engineerto lead the design, development, and maintenance of our enterprise data platform. You will be the bridge between raw data and actionable business insights, ensuring our ETL pipelines are robust, our data models are scalable, and our reporting is world-class. Key ResponsibilitiesDatabase Development & Optimization:Lead the design of complex SQL Server objects (stored procedures, UDFs, triggers). You will be the go-to expert for performance tuning and query optimization. ETL Architecture (SSIS & Python):Architect and deploy end-to-end ETL/ELT pipelines. While SSIS is our core, you will usePythonto extend capabilities, such as interacting with REST APIs or performing complex data manipulations that traditional tools can't handle. Data Modeling:Design and implement scalableStar and Snowflake schemas . You will ensure the Data Warehouse is optimized for OLAP cubes and high-performance reporting. Reporting & Analytics (SSRS):Deliver sophisticated, high-impact reports including drill-through and matrix formats. You will manage the full lifecycle of report subscriptions and automated distribution. System Integrity & Mentorship:Monitor SQL Agent jobs, troubleshoot critical failures, and provide technical leadership/code reviews for junior team members. Key Tech Stack & Skills Required: 5+ years of experiencein BI development within the Microsoft SQL Server ecosystem. Expert-level T-SQL:Deep knowledge of CTEs, window functions, and execution plans. Data Warehousing Mastery:Solid understanding of Kimball/Inmon methodologies. Python Proficiency:Experience using Python (Pandas, NumPy, SQLAlchemy) for data engineering tasks. SSIS/SSRS:Proven track record of deploying enterprise-level packages and reports. Preferred: Experience with cloud data platforms (Azure Synapse, AWS Redshift, or Snowflake). Exposure to Power BI or Tableau for modern visualization. Knowledge of CI/CD practices for SQL Server (e.g., SSDT, Azure DevOps). Required Education & Experience Education:Bachelor’s degree in a field such as Engineering, Computer Science, or a related technical field. Experience:5+ yearsof relevant experience Recognition & Achievements We have been recognized as a Star Performer in Data & AI Services Specialists - Everest’s North America PEAK Matrix 2025, and as a Leader in AIM’s Pema Quadrant of Agentic AI Service Providers - 2025. In Nov 2023, Straive acquired Gramener, an award-winning, design-led data science company, enhancing our data, analytics, and AI capabilities. In June 2025, we acquired SG Analytics, a leading provider of AI-powered insights and contextual analytics services.
Job Title
Senior BI Engineer