Principal Business Intelligence Engineer

Primary Duties & Responsibilities


* Lead the architecture, design, and evolution of enterprise-scale data warehouse and analytics platforms supporting global business operations and strategic decision-making.


* Define and implement enterprise data modeling standards, governance practices, and scalable architectural frameworks for analytics and reporting solutions.


* Design and optimize Snowflake-based solutions, including advanced SQL development, dbt frameworks, JavaScript-based stored procedures, and data pipelines.


* Lead the development of scalable and maintainable dimensional data models, including staging, intermediate, semantic, and enterprise reporting layers with automated testing, lineage tracking, and documentation standards.


* Drive enterprise data integration initiatives involving Oracle E-Business Suite (EBS), ERP systems, manufacturing systems, external APIs, and cloud-based data platforms.


* Serve as the technical authority for enterprise BI and analytics engineering solutions, providing guidance and mentorship to engineers and cross-functional technical teams.


* Partner with business leaders and stakeholders across Finance, Supply Chain, Manufacturing, Operations, and IT to translate strategic business objectives into scalable technical solutions.


* Lead architecture reviews, performance optimization efforts, data quality initiatives, and enterprise scalability planning for mission-critical analytics systems.


* Establish best practices for ETL/ELT development, CI/CD deployment processes, code quality, testing frameworks, and operational support procedures.


* Evaluate emerging technologies and recommend improvements to enterprise data architecture, analytics platforms, and reporting capabilities.


* Lead complex cross-functional programs and coordinate technical activities across multiple teams to ensure successful delivery of enterprise initiatives.


* Drive continuous improvement initiatives for data governance, metadata management, reliability, observability, and operational excellence.


* Participate in strategic planning discussions related to enterprise analytics capabilities, data modernization efforts, and long-term platform roadmaps.

Education & Experience


* Minimum 9+ years of experience in enterprise data engineering, BI engineering, analytics engineering, or related disciplines.


* Minimum 8+ years of hands-on experience with Oracle E-Business Suite (EBS), enterprise data warehousing, and Snowflake development.


* Deep expertise in enterprise data architecture, dimensional modeling, data warehouse design, and large-scale analytical systems.


* Advanced proficiency in SQL, PL/SQL, SnowSQL, T-SQL, and performance optimization techniques for large-scale data platforms.


* Extensive experience designing and developing advanced stored procedures, orchestration frameworks, and scalable ELT/ETL pipelines.


* Strong experience building e...