Power BI SME (Top Secret Cleared)

ECS is seeking a Power BI SME (Top Secret Cleared) to work in our Washington, DC office.

• Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions.
• Design, implement, execute, and debug manual test cases and automated test scripts using a variety of testing techniques.
• Strong data analysis skills and the ability to track a data element from source to transformation to target.
• Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools, preferably Erwin.
• Creates and implements BI reporting solutions, ETL solutions using best practices and methodologies; identifies root causes of issues with data quality and other related issues.
• Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments.
• Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met.
• Secure sensitive content to align with regulatory and legal requirements.
• Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.
• Mentors junior staff.
• Provide on-call production support on a rotating basis.

Salary Range: $200,000 - $225,000

General Description of Benefits

• Must have a current Top-Secret Clearance with the capability of obtaining SCI / CI-Poly if needed to meet contract requirements.
• Bachelor's degree in Data Science, Computer Science, or a related field.
• 7+ years related experience as a Power BI developer with excellent track record
• Proficient with Power BI and Power Apps.
• Experienced in writing complex statements, scripts, stored procedures, triggers, and views implement business intelligence and data warehousing solutions. Experience in extracting data from heterogeneous data sources.
• Solid foundation in, and application of, data warehousing and reporting platform concepts with ability to recommend solutions and drive best practices.
• Familiarity with Oracle, SQL Server, Cognos & Tableau (or similar) environments is a must.
• Experience with cloud data warehousing or data integration as a service.