6-10 years of experience. Manages, organizes, and administers systems analysis while preparing applications and operating systems for processing data and solving problems.
PositionDescription:
The District ofColumbia Public Schools (DCPS) Office of Data & Technology (ODT) haslaunched new Business Intelligence (BI) initiatives and seeks a highlyproficient Microsoft Power BI Developer who can support on technical backendset up, dashboard development, tool deployment to users, staff and usertraining, as well as consult on developing the BI strategy and plan for theagency.
Responsibilities:
1. Design and develop compelling Power BI data visualizations.
2. Design, develop, and maintain Power BI Dataflows (Gen 2).
3. Design, develop, and maintain Fabric Warehouses.
4. Create functional and technical documentation related to Business Intelligence solutions.
5. Communicate effectively with both technical and nontechnical stakeholders.
6. Develop and conduct training for current technical staff and nontechnical users.
7. Collaborate with both business and IT partners to identify key use cases and define associated requirements.
8. Conduct and support whiteboarding sessions, workshops, design sessions, and project meetings as needed.
Qualifications:
1. Quantitative background with 6-10 years of experience applying data visualization and business intelligence to the solution of real-world business problems.
2. Advanced experience using MS Power BI. Must have a deep understanding of Power BI Desktop/Server, DAX and SQL.
3. Microsoft technology stack experience (SQL Server, SQL Management Studio, SSIS, SSAS, Azure data platform, Etc.).
4. Exceptional analytical, conceptual, problem-solving abilities, communication skills and experience training staff and users.
5. Experience working with K-12 education data and school district staff to understand the data.
6. Highly self-motivated to deliver both independently and with strong team collaboration.
---------------------------------------------
CONTRACT JOB DESCRIPTION
Responsibilities:
1. Manages, organizes, and administers systems analysis and preparation of applications and operating systems programming to process data and solve problems.
2. Establishes priorities and schedules, and oversees and reviews work of systems analysis and programming personnel.
3. Reviews feasibility studies and time /cost estimates of new or revised systems.
4. Assists in the development of standards, procedures, and operating systems applications.
5. Possesses a combination of technical training and hands-on expertise.
6. Works with stakeholders and management to ensure projects are completed on time and according to organization standards.
7. Consults with personnel in other information systems groups to coordinate activities.
8. Consults with management to clarify systems and programs intent, identify problems, suggest changes, and determine extent of application systems changes required.
9. Participates in developing a project plan and schedule with key milestones, contingency plans, workflow charts or diagrams, considering factors, such as resource requirements, computer storage capacity and speed, extent of peripheral equipment, and intended use of output data.
10. Analyzes test runs on computer and supervises correction of coded program and input data.
11. Manages the revision of existing programs to increase operating efficiency or adapt to new requirements.
12. Compiles documentation of program development and subsequent revisions.
13. Trains subordinates in systems analysis, feasibility studies, programming, and program coding.
14. Prescribes standards for terms and symbols used to simplify interpretation of programs.
15. Collaborates with computer manufacturers and other users to develop new programming methods.
16. Prepares records and reports.
17. Ensures consistency and completeness across data models.
18. Plans and delivers development architecture environments in coordination with the Environmental Support Specialist.
19. Assists in managing and directing team s technical architecture processes.
20. Develops and documents expert practices/standards.
21. Possesses strong analysis, presentation, documentation, and quality assurance skills.
22. Analyzes, determines, and documents technical requirements and impact analysis for technical and development architectures.
23. Explains defect priorities and enhancement classifications to client.
24. Leads systems analysis for architecture and development of new applications.
25. Establishes development schedule and allocates work of personnel based on project plans, timelines, and budgets.
26. Works with organizational leadership to ensure projects are in line with long-term IT strategies and initiatives.
27. Works with management to articulate systems and programs purpose, identifies problems, suggest changes, and determines required changes to existing applications.
28. Provides mentoring and guidance to agency personnel and leadership when needed.
29. Maintains awareness of new technological developments in industry and processes, and implements concepts appropriately.
30. Leads or participates in setting the service levels for applications.
31. Defines overall system architecture.
32. Provides well-structured work plans which define scope, resources, milestones, quality, risk, tasks, and acceptance criteria.
33. Prepares contingencies, scenarios, scenario plans and action items to resolve issues.
34. Leads efforts in providing technical expertise, guidance, and training to the Application and Test Teams.
Minimum Education/Certification Requirements:
Bachelor s degree in IT or related field or equivalent experience
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
|---|
| Bachelor s degree in IT or related field or equivalent experience | Required | 10 | Years |
| 6-10 yrs. clarifying system and program intent | Required | 6 | Years |
| 6-10 yrs identifying problems, suggesting changes, and determining extent of application systems changes | Required | 6 | Years |
| Advanced experience using MS Power BI. Must have deep understanding of Power BI Desktop/Server, DAX and SQL | Required | 3 | Years |
| Microsoft technology stack experience (SQL Server, SQL Management Studio, SSIS, SSAS, Azure data platform, etc.) | Required | 5 | Years |
| Exceptional analytics, conceptual, problem-solving abilities, communication skills and experience training staff and users. | Required | 6 | Years |
| Experience working with K-12 education data and school district staff to understand the data. | Highly desired | 6 | Years |
| Highly self-motivated to deliver both independently and with strong team collaboration. | Highly desired | 6 | Years |
Questions
| No. | Question |
|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? |
| Question2 | What is your candidate's email address? |
| Question3 | Candidates submitted above the hourly NTE Vendor Rate $$.$$ of $$.$$ will not be considered. Do you agree to this requirement? |
| Question4 | There are no reimbursable expenses. Do you agree to this requirement? |
| Question5 | By submitting your candidate to this requisition, you are indicating your company s acceptance of the terms and conditions contained within the Supplier Agreement, and Amendment #2022-01 to the Supplier Agreement. Do you agree to this requirement? |
Existing Incumbent Resource?: Yes