What are the responsibilities and job description for the Data Warehouse / Power BI Developer position at KMRG, LLC?
ROLE
We are seeking an experienced Data Warehouse / Power BI Developer to support the U.S. Government Publishing Office’s (GPO) Application Development and Management (ADM) division in Washington, D.C. In this role, you will develop and maintain enterprise reports using Power BI and Azure Synapse, integrate data from federal financial and operational systems, and support semantic modeling efforts to drive insight across business units.
This is a full-time opportunity in which we'll provide competitive pay, comprehensive benefits, and job stability and security.
Apply today!
RESPONSIBILITIES
KNOWLEDGE & SKILLS
BACKGROUND
EDUCATION
LOCATION
TELEWORK
CLEARANCE
CLIENT
TRAVEL
WORK HOURS
EMPLOYMENT CLASSIFICATION
RELOCATION
******************
KMRG, LLC is an Equal Opportunity/Affirmative Action (EEO/AA) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, gender identity, sexual orientation, ancestry, national origin, age, marital or civil partnership status, mental disability, physical disability, medical condition, pregnancy, maternity status, political affiliation, military or veteran status, genetic information, traits historically associated with race, or any other basis prohibited by federal, state, and/or local law.
Other Considerations. Applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 100% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 100% of the time.
We are seeking an experienced Data Warehouse / Power BI Developer to support the U.S. Government Publishing Office’s (GPO) Application Development and Management (ADM) division in Washington, D.C. In this role, you will develop and maintain enterprise reports using Power BI and Azure Synapse, integrate data from federal financial and operational systems, and support semantic modeling efforts to drive insight across business units.
This is a full-time opportunity in which we'll provide competitive pay, comprehensive benefits, and job stability and security.
Apply today!
RESPONSIBILITIES
- Respond to assigned tasks in the GPO’s assignment tracking system ServiceNow
- Develop and modify reports in Microsoft Power BI based on business unit requests
- Build and update semantic models using Azure Synapse, incorporating new data fields and structures as needed
- Identify required data and its relationships within systems such as Oracle Federal Financials, SQL Server, and other enterprise platforms
- Coordinate with the Enterprise Service Bus (ESB) team to establish or synchronize new data feeds to the Synapse Data Lake
- Add new fields and data elements to semantic models when data already exists in the Data Lake
- Work iteratively with business unit stakeholders to validate report outputs and gather feedback for refinement
- Ensure developed reports align with user requirements and meet production standards before release
- Maintain documentation of report specifications, development steps, and release notes
- Support the transition from SAP Business Objects to Power BI by helping replicate and modernize legacy reporting assets
- Respond to ad hoc reporting requests throughout the contract year, including audit, compliance, and management dashboards
KNOWLEDGE & SKILLS
- Proficiency in Power BI, including report structuring and data modeling concepts required
- Knowledge of semantic modeling principles within cloud data architectures required
- Knowledge of Azure Synapse features (e.g., pipelines, workspaces, etc.) required
- Knowledge of ServiceNow or similar assignment tracking systems required
- Knowledge of SAP Business Objects report architecture preferred
- Proficiency with DAX, Power Query (M language), or similar scripting tools preferred
BACKGROUND
- 5 years of experience developing reports using Microsoft Power BI required
- Experience building and modifying semantic models using Azure Synapse or a similar cloud-based platform required
- Experience identifying and integrating data from systems such as Oracle Federal Financials, SQL Server, or other enterprise databases required
- Experience coordinating with technical teams such as the Enterprise Service Bus (ESB) team to establish or synchronize data feeds required
- Experience participating in iterative development cycles with business unit stakeholders required
- Experience responding to tasks or work assignments in ServiceNow or a comparable assignment tracking platform required
- Experience developing or modernizing reports to support a transition from SAP Business Objects to Power BI preferred
- Experience supporting ad hoc report development, including compliance, audit, and executive-level dashboards preferred
- Experience documenting report specifications, data mapping, or release notes preferred
EDUCATION
- Bachelor’s degree in information systems, business, or a related field preferred
LOCATION
- Washington, D.C., 20401
TELEWORK
- Remote work is available
CLEARANCE
- U.S. citizenship is required as it supports the U.S. federal government
CLIENT
- U.S. Government Publishing Office’s
TRAVEL
- Travel is not required
WORK HOURS
- Flexible days and hours
EMPLOYMENT CLASSIFICATION
- Employment Classification Eligibility — Exempt
RELOCATION
- Not eligible for relocation benefits
******************
KMRG, LLC is an Equal Opportunity/Affirmative Action (EEO/AA) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, gender identity, sexual orientation, ancestry, national origin, age, marital or civil partnership status, mental disability, physical disability, medical condition, pregnancy, maternity status, political affiliation, military or veteran status, genetic information, traits historically associated with race, or any other basis prohibited by federal, state, and/or local law.
Other Considerations. Applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 100% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 100% of the time.
Salary : $100,000 - $140,000
