BI Reporting Developer I

ECS Tech Inc•Fairfax, VA

3h•$80,000 - $100,000•Remote

About The Position

ECS Federal is seeking a skilled BI Reporting Developer I – to join the Business Systems team. This role 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, with a solid foundation in data modeling and analytical reporting.

Requirements

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
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

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