ECS Federal, LLC - BI Reporting Developer I

Client: ECS Federal, LLC

Location: Remote

Job Description

ECS is seeking a BI Reporting Developer I to work remotely. This role is part of the Business Systems team and requires the candidate to design, develop, and maintain interactive reports and dashboards. The ideal candidate will have strong expertise in OAC (Oracle Analytics Cloud), Power BI, Tableau or similar BI tools, along with a solid foundation in data modeling and analytical reporting.

Key Responsibilities

• Design, develop, and deploy interactive dashboards, reports, and visualizations using Power BI, Tableau, OAC or equivalent tools.
• Create and optimize data models including fact tables, dimension tables, and relationships.
• Collaborate with stakeholders to gather reporting requirements and translate them into technical solutions.
• Build and maintain Data Visualizations (DV) workbooks and classic analyses.
• Develop and maintain DAX measures, calculated columns, and custom visualizations (Power BI).
• Implement drill-down, drill-through, and linked analysis functionality.
• Strong understanding of ETL/ELT methodologies with hands-on experience in designing, developing, and optimizing data integration workflows.
• Connect to various data sources (Oracle Database, ADW, data lakes, REST APIs, flat files).
• Write optimized SQL queries to extract and transform data.
• Ensure data accuracy, consistency, and integrity across all reports.
• Document reporting solutions, data models, and business logic.
• Perform performance tuning and optimization of reports and datasets.

Salary Range

$80,000 - $100,000

Requirements

Professional Skills

• Strong analytical and critical thinking abilities.
• Excellent troubleshooting and problem-resolution skills.
• Ability to write clear technical specifications and documentation.
• Effective communication skills (written, verbal, presentation).
• Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).
• Ability to work independently with minimal supervision.
• Strong time management and ability to balance multiple priorities.
• Customer-focused mindset with responsiveness to requests.
• Understanding of budget and financial management analysis.

Skills & Qualifications

• BI Tools: OAC, Power BI, Tableau, or similar (3+ years).
• Data Modeling: Star schema, snowflake schema, fact & dimension tables.
• Query Languages: SQL (intermediate to advanced).
• Data Concepts: ETL processes, data warehousing fundamentals.
• Analytical Skills: Strong problem-solving and attention to detail.

Benefits

For more details on benefits, visit: ECS Benefits