Straive · 15 hours ago
Business Intelligence Engineer
New Jersey, United States
Full-time
Onsite
Senior Level
6+ years expStraive is a global leader in enterprise-grade data analytics and AI solutions, committed to empowering businesses across various industries with cutting-edge technology and expert insights. The Senior BI Engineer will be responsible for designing, developing, and maintaining the end-to-end Business Intelligence infrastructure, transforming raw data into actionable insights through robust ETL processes and sophisticated data modeling.
CRMOutsourcing
Hiring Manager
Vipul Rai
Responsibilities
Database Development & Optimization: Design and maintain complex SQL Server objects, including stored procedures, views, functions, and triggers. Proactively identify and optimize slow-running queries to ensure peak system performance
ETL Architecture (SSIS): Architect, develop, and deploy scalable SSIS packages. Manage data extraction and transformation from diverse sources, including SQL Server, Oracle, Flat Files, APIs, and Excel, into the centralized Data Warehouse
Reporting & Visualization (SSRS): Create and manage sophisticated SSRS reporting solutions, including parameterized, drill-down, and matrix reports. Oversee report subscriptions and automated delivery schedules to ensure stakeholders receive timely data
Data Modeling: Lead the design and implementation of star and snowflake schemas. Ensure the Data Warehouse architecture supports complex OLAP requirements and long-term reporting scalability
Advanced Data Processing (Python): Leverage Python (Pandas and NumPy) for complex data cleaning, multi-source merging, and generating pivot-style aggregations from raw SQL or API feeds that exceed standard SQL capabilities
System Maintenance & Troubleshooting: Monitor scheduled SQL Agent jobs and SSIS package executions. Act as the primary point of contact for troubleshooting ETL failures and resolving data integrity issues
Qualification
Required
Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field
Minimum of 6 years of professional experience in Business Intelligence, Data Warehousing, or Database Engineering
Expert-level proficiency in TSQL and the Microsoft BI Stack (SSIS, SSRS)
Strong hands-on experience with Python specifically for data analysis (Pandas/NumPy)
Proven experience in designing relational and dimensional data models
Strong ability to troubleshoot complex data pipelines and translate business requirements into technical specifications
Excellent verbal and written communication skills, with the ability to document technical workflows and present data insights to stakeholders
Proven ability to work independently in a fast-paced environment and manage multiple high-priority projects simultaneously
Company
Straive
Straive is a global provider of technology-driven content and data services.
10001+ employees
Funding
Current Stage
Late StageTotal Funding
unknown2021-08-20Acquired
Leadership Team
Ankor Rai
Chief Executive Officer
Lori Silverstein
SVP Global Sales, Data and Content Solutions
Recent News
2025-06-21
Canada NewsWire
2025-06-19
Company data provided by crunchbase