What are the responsibilities and job description for the Developer - Power BI SME position at Progression, Inc.?
Power BI SME
Washington D.C.
MUST :
Active Top Secret / SCI clearance is 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.
Agile / Scrum Project experience preferred
Experience working with a variety of stakeholders, from managers to technical resources, including the translation of business requirements into operational measures and reports.
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. #INDPRO
