Senior Business Intelligence Developer

Franklin Fitch; United States; Remote; USD 120,000 - 130,000; Full time

Job summary

Franklin Fitch is seeking a Senior BI Developer / Data Engineer to modernize reporting and data platforms within its Data & Analytics team. This fully remote role follows East Coast hours and focuses on delivering Power BI dashboards and enterprise reporting.

You will design data pipelines, optimize data models, and collaborate with stakeholders to translate requirements into scalable analytics. The role blends BI development with data engineering to strengthen data quality and governance.

Qualifications

• Strong problem-solving and troubleshooting abilities.
• Experience translating business requirements into scalable BI solutions.
• Experience building dashboards and reporting solutions using Power BI.
• Experience with Oracle databases and enterprise reporting platforms such as Cognos Analytics.
• Exposure to ETL and data pipeline development.

Responsibilities

• Design, develop, and support enterprise reporting and analytics solutions.
• Build executive-facing dashboards, reports, semantic models, and datasets using Power BI.
• Develop and maintain reporting solutions across BI platforms.
• Translate business requirements into scalable reporting and analytical solutions.
• Optimize reports, dashboards, queries, and data models for performance and usability.
• Support modernization of legacy reporting environments.
• Design and develop data pipelines and integration processes.
• Extract, transform, validate, and consolidate data from multiple systems.
• Build scalable data structures that support enterprise analytics and reporting.
• Automate manual reporting and data preparation processes.
• Implement monitoring, validation, and error-handling procedures to ensure data quality.

Skills

Problem-solving

Communication skills

Tools

SQL Server

Oracle databases

Power BI

Cognos Analytics

Crystal Reports

Microsoft Fabric

Job description

Senior BI Developer / Data Engineer | 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 is an opportunity to play a key role in modernizing reporting and data platforms while supporting executive-level analytics initiatives across the business.

The position combines business intelligence development, data engineering, and enterprise reporting, with an immediate focus on delivering Power BI dashboards and strengthening the organization's data platform strategy.

Key Responsibilities

Business Intelligence & Reporting:

• Design, develop, and support enterprise reporting and analytics solutions.
• Build executive-facing dashboards, reports, semantic models, and datasets using Power BI.
• Develop and maintain reporting solutions across a variety of BI platforms.
• Translate business requirements into scalable reporting and analytical solutions.
• Optimize reports, dashboards, queries, and data models for performance and usability.
• Support the modernization of legacy reporting environments.
• Design and develop data pipelines and integration processes.
• Extract, transform, validate, and consolidate data from multiple business systems.
• Build scalable data structures that support enterprise analytics and reporting.
• Automate manual reporting and data preparation processes.
• Implement monitoring, validation, and error-handling procedures to ensure data quality.

Database Development:

• Create and optimize SQL queries, stored procedures, views, and other database objects.
• Work extensively with SQL Server and Oracle databases.
• Support enterprise reporting requirements through effective database design and performance tuning.

Required Experience:

• Strong hands-on experience with SQL (most critical requirement).
• Experience developing dashboards and reporting solutions using Power BI.
• Experience working with Oracle databases.
• Knowledge of enterprise reporting platforms such as Cognos Analytics.
• Experience writing, maintaining, and optimizing complex SQL queries.
• Exposure to data integration, ETL, and data pipeline development.
• Strong problem-solving and troubleshooting abilities.

Nice-to-Have Experience:

• Microsoft Fabric.
• Crystal Reports.
• Data warehousing and data modeling.
• ERP, WMS, eCommerce, or enterprise application reporting.
• Modern cloud analytics platforms.

What We're Looking For:

• A strong data professional who can bridge both reporting and engineering functions.
• Someone comfortable working directly with business stakeholders to understand reporting needs.
• An individual who enjoys improving processes, enhancing data quality, and driving better business insights.
• Strong communication skills with the ability to explain technical concepts to non-technical audiences.

Working Arrangement:

• Fully remote position.
• Must be able to work East Coast business hours (Monday-Thursday 7:45am-4:30pm ET, Friday 7:45am-3:00pm ET).

If you're a SQL-focused data professional with strong Power BI expertise and experience supporting enterprise reporting environments, we'd love to hear from you.