Developer - Power BI SME

*Work with Progression, Inc. get your application bumped to the front of the line*

Power BI SME
Washington, DC
Pay From: $155,000 per year

MUST:
Experienced Power BI SME
Active Top Secret clearance required
7+ years of related experience as a Power BI Developer with an excellent track record
Proficient with Power BI and Power Apps.
Experienced in writing complex statements, scripts, stored procedures, triggers, and views to 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 the 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
Bachelor's degree in Data Science, Computer Science, or a related field

DUTIES:
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.


*Progression Inc. is an affirmative action/equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, status as a protected veteran, or status as an individual with a disability. "Healthcare benefits are offered to all eligible employees according to compliance mandated by the Affordable Care Act"* #INDPRO