Developer - Power BI SME
Job Description
Progression Inc is seeking a seasoned Power BI specialist to join its analytics team in Washington, DC. The role focuses on designing and delivering robust BI solutions, building ETL and data warehousing capabilities, and shaping data models and reports, with on-call production support and mentoring responsibilities to guide junior colleagues.
Location: Washington, DC (onsite). Salary: USD 155,000 per year. Education: Bachelor's degree in Data Science, Computer Science, or a related field. Experience: minimum 7 years.
Responsibilities
- 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.
- Designs, implements, executes, and debugs manual test cases and automated test scripts using a variety of testing techniques.
- Demonstrates strong data analysis skills and the ability to trace 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.
Requirements
- 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
- Proficient with 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
- Familiarity with SQL Server
- Familiarity with Cognos
- Familiarity with Tableau
- Experience with cloud data warehousing or data integration as a service
- Bachelor's degree in Data Science, Computer Science, or a related field
Technologies
- Power BI
- Power Apps
- Erwin
- Oracle
- SQL Server
- Cognos
- Tableau
Benefits
- Healthcare benefits are offered to all eligible employees according to compliance mandated by the Affordable Care Act
Similar Jobs
A
