Senior Business Intelligence Developer
-
IT/Tech
Job Description & How to Apply Below
Senior BI Developer / Data Engineer (Power BI & Cognos) | Fully Remote (East Coast Hours) | $120,000-$130,000
A growing North American organization is seeking a Senior BI Developer / Data Engineer to join its enterprise Data & Analytics team. This position is ideal for a data professional with strong expertise across SQL Server, Power BI, Cognos Analytics, and enterprise reporting environments who can help modernize reporting platforms while supporting executive-level analytics initiatives.
This role combines business intelligence development, data engineering, reporting architecture, and enterprise data modeling, with an immediate focus on enhancing Power BI reporting capabilities while supporting and evolving existing Cognos reporting solutions.
Key Responsibilities:Business Intelligence & Enterprise Reporting:
- Design, develop, and support enterprise reporting solutions across Power BI and Cognos Analytics platforms.
- Build executive-facing dashboards, semantic models, datasets, and KPI reporting solutions in Power BI.
- Develop, maintain, troubleshoot, and optimize Cognos reports, packages, and reporting models.
- Work closely with business stakeholders to define reporting requirements and translate them into scalable analytical solutions.
- Modernize legacy reporting environments and support migration initiatives from Cognos and other reporting platforms.
- Develop reusable reporting standards, metrics, and governance processes to ensure consistent reporting across the organization.
- Optimize report performance, query execution, and data model efficiency across both Power BI and Cognos environments.
- Design and develop scalable data pipelines, ETL processes, and enterprise data integration solutions.
- Consolidate data from SQL Server, Oracle, ERP, WMS, and other business systems into centralized reporting platforms.
- Build and maintain data models, semantic layers, and enterprise reporting datasets.
- Implement robust data quality, reconciliation, and validation processes.
- Support enterprise analytics initiatives leveraging modern Microsoft data technologies, including Microsoft Fabric where applicable.
- Automate manual reporting and data preparation activities.
- Create, optimize, and troubleshoot complex SQL queries, stored procedures, views, and database objects.
- Analyze and improve SQL Server performance through indexing, execution plan analysis, statistics management, and query tuning.
- Build and support data warehouse and reporting structures.
- Investigate reporting discrepancies and perform reconciliation across reporting layers.
- Support large-scale reporting environments containing millions of records.
- Expert-level SQL development experience with SQL Server.
- Strong Power BI experience, including:
- DAX
- Semantic Models
- Performance optimization
- Security (RLS)
- Hands-on experience with IBM Cognos Analytics.
- Experience with Cognos Framework Manager and package development.
- Experience troubleshooting Cognos reporting and scheduling issues.
- Experience designing enterprise reporting and analytics solutions.
- Experience with ETL, data integration, and data pipeline development.
- Strong understanding of star schema design, dimensional modeling, and data warehousing concepts.
- Experience working directly with business stakeholders to gather and refine reporting requirements.
Preferred Experience:
- Candidates with both Power BI and Cognos experience are strongly preferred.
- Microsoft Fabric.
- Data warehousing and dimensional modeling.
- Crystal Reports.
- Reports Now.
- ERP, WMS, JD Edwards, eCommerce, or enterprise reporting environments.
- Experience modernizing or migrating legacy BI platforms.
- Direct Lake, Data Factory, CDC, and cloud analytics platforms.
- A BI professional who can operate comfortably across both modern and legacy enterprise reporting platforms.
- Someone capable of bridging reporting, analytics, and data engineering disciplines.
- A strong problem solver with experience investigating data discrepancies, reporting issues, and performance bottlenecks.
- An individual with excellent communication skills who can work directly with executives and business stakeholders.
- Someone who enjoys improving data quality, reporting governance, and enterprise analytics capabilities.
Position Requirements
10+ Years work experience(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction