Power BI Developer
Location: Washington D.C(On Site)
Position Type: Contract
Job Description
We are looking for a Power BI Developer who is skilled in SQL and has experience with relational databases such as Oracle and SQL Server. We are seeking a dedicated Power BI Developer to join our team and play a crucial role in sustaining business intelligence operations. The ideal candidate will be responsible for supporting performance measures developing and maintaining reports and ensuring seamless integration of various data sources into our BI systems.
What Youll Do
- Modify and validate existing automated performance measures to ensure accuracy and incorporation of the latest fiscal year data
- Minimize disruptions during the migration of financial data from legacy systems to the new Peoplesoft Enterprise Data Warehouse
- Design and implement new performance measures as needed to support various projects and programs
- Integrate data from financial management human capital applications Maximo Nextfare and other source systems into cohesive datasets for BI use
- Create and maintain strategy management application measures
- Migrate performance measures to updated software versions during Cognos Tableau and PowerBI upgrades
- Recommend new measures based on industry best practices and available data
- Enhance current Dashboard pages and recommend new pages and portlet types
- Maintain comprehensive documentation for all processes modifications and developments supporting BI operations
- Update IT documentation to reflect the latest security authorizations and process changes
- Document DMSS Operations required data calls and related documentation
- Define data requirements assess data sources and develop data marts or warehouse enhancements
- Implement ETL scripts construct consumable data sets and perform necessary testing
- Design and develop dashboards reports and analytic products including GIS data visualization
- Support endtoend development of new BI services
- Maintain and enhance existing BI infrastructure and provide user training
- Architect and implement new BI tool environments and support postimplementation activities
- Assist in data governance process design and perform customer outreach and training
Required:
- Bachelors degree in Computer Science Information Technology Data Science or a related field
- Expertise in Microsoft Power BI development and deployment
- Advanced knowledge of DAX Power Query and data modeling within Power BI
- Proficiency in SQL and experience with relational databases such as Oracle and SQL Server
- Familiarity with ETL (Extract Transform Load) tools and processes specifically with DataStage and SSIS
- Experience with BI tools such as IBM Cognos Analytics Tableau SPSS and other analytics platforms
- Knowledge of data warehousing concepts and best practices
- Understanding of high availability architecture and cloudhosted solutions especially Microsoft Azure
- Ability to customize reports with JavaScript and SQL for tools like Cognos.
- Experience with data governance and data quality management
Preferred:
- Certifications in Power BI or other relevant BI tools are highly desirable
Physical Demands
- Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal state and local standards
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings etc.
- Ability to conduct repetitive tasks on a computer utilizing a mouse keyboard and monitor
Expertise in Microsoft Power BI development and deployment Advanced knowledge of DAX, Power Query, and data modeling within Power BI