BI Reporting Developer I

Job Description

ECS is seeking a BI Reporting Developer I to work remotely .

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.

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

General Description of Benefits

Required Skills

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

Desired Skills

• Experience with DAX, M Query, or Tableau calculations
• Familiarity with cloud platforms (Azure, AWS, or Google Cloud Platform)
• Knowledge of Python or R for data analysis
• Experience with SSRS, SSAS, or other reporting services
• Understanding of row-level security (RLS) implementation
• Understanding of federal financial management requirements
• Experience with financial reporting and compliance
• Knowledge of government accounting standards
• Familiarity with contract management processes
• Experience with Agile/Scrum methodologies

#ECS1

ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis any characteristic protected by law. All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, or local jurisdiction law.

ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3200+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.