PROGRAM COMPLIANCE OFFICER II – ASSISTANT DATA OFFICER

Salary Range: $74,803 - $119,684 ANNUALLY
Starting Pay: $74,803 ANNUALLY
Get to Know Us
Welcome to the City of Baltimore! Experience the reward of a fulfilling career and enjoy the added element of excitement in a vibrant, diverse atmosphere. The City of Baltimore offers limitless opportunities to help drive social impact, both on the job and in the community, while serving its citizens. Join us in making Baltimore a great place to live and work. In the City of Baltimore, we hire great people and provide them with the skills and opportunities to grow toward their career aspirations. If you are looking for a career change or interested in learning more, explore our opportunities and benefits programs. We are excited to have you as a part of the City of Baltimore Team! The city offers medical, prescription drug, dental, vision, optional life, AD&D, and FSA plans. This office also supplies wellness programs, support groups, and workshops. You can learn about our benefits here:
https://humanresources.baltimorecity.gov/hr-divisions/benefits
Job Summary:
The Mayor’s Office of Small & Minority Business Advocacy & Development (SMBA&D) is seeking a Program Compliance Officer II to serve as Assistant Data Officer. SMBA&D oversees compliance with the Minority & Women’s Business Program, Baltimore City Code Article 5, Subtitle 28, governing Minority Business Enterprises (MBE) & Women’s Business Enterprises (WBE). The Minority & Women’s Business Program requirements are applicable to all City contracts. SMBA&D additionally operates the MBDA Advanced Manufacturing Program, Baltimore Main Streets Program, and provides small business advancement resources.
The key responsibility of this position is to promote the vision of an integrated network of services and assist all areas of implementing the network by utilizing a data-forward approach. The most qualified candidates will have experience working with APIs, familiarity with automation tools (e.g., Power Automate), geospatial software (e.g., ArcGIS), Git / GitHub, Jira, & an understanding of basic Linux commands.

Essential Functions:

• Engage in data cleaning, manipulation, and analysis of data obtained from various sources.
• Perform quality assurance and data validation on agency and City data-related solutions.
• Create, maintain, and run monthly reports on agency systems, services, and performance.
• Create data dashboards and visualizations for agencies related to compliance, M/WBE utilization, etc.
• Assist the Data Officer in tracking internal performance metrics and standards.
• Assist the Data Officer in the implementation of the strategic plan for an integrated network of services.
• Assist the Data Officer in configuring and managing agency databases.
• Serve as a liaison for the agency and various SaaS providers / representatives.
• Design, distribute, and analyze the results of agency surveys.
• Present analysis findings to executive leadership, citizens, and city officials.
• Assist with user interface and application development.
• Assist the Data Officer in researching and implementing innovative technologies.

Required Knowledge & Skills

• Python
• Experience in Python using the Pandas library for data analysis.
• Advance Microsoft Excel Features (e.g., Formulas, Pivot Tables, Macros).
• PowerBI
• Experience in PowerBI creating visualizations and dashboards.
• Familiarity working with databases (e.g., SQL).
• Familiarity with OOP concepts.
• Ability to learn and utilize new technologies & software.
• Ability to maintain a high workload.
• Ability to articulately present, justify, and defend your findings.
• Ability to express ideas, both orally and in writing.
• Ability to maintain your schedule and honor deadlines.
• Ability to investigate situations and extract and organize facts.
• Ability to independently work and follow protocols.
• Knowledge of methods and procedures for the collection or organization, interpretation and presentation of information.
• Ability to adapt and apply concepts and techniques to the needs of specific projects.
• Ability to identify problem areas and recommend appropriate solutions based on logical consideration of alternatives.
• Ability to interpret and apply City Code, a variety of laws, rules, regulations, standards and procedures.
• Ability to prepare and present reports or recommendations clearly and concisely.
• Ability to analyze & compile operational data.
• REQUIREMENTS: Qualified candidates will have prior background in finance, accounting, or large-scale organizational management.

EQUIVALENCIES: Equivalent combination of education and experience.
Background Check
Eligible candidates for final consideration for appointments to positions identified as positions of trust will be required to complete authorization for a Criminal Background Check and/or Fingerprint must be successfully completed.
Baltimore City Government is an Equal Employment Opportunity Employer, and we are committed to a workplace that values diversity, equity, and inclusion. The City of Baltimore prohibits discrimination on the basis of race, color, religion, age, sex, ancestry, creed, national origin, disability status, genetics, marital status, military service, sexual orientation, gender identity/expression or any other characteristic protected by federal, state or local laws. Applicants requiring accommodation during the hiring process should contact the Department of Human Resources directly. Do not attach your request for accommodation to the application.

• Engage in data cleaning, manipulation, and analysis of data obtained from various sources.
• Perform quality assurance and data validation on agency and City data-related solutions.
• Create, maintain, and run monthly reports on agency systems, services, and performance.
• Create data dashboards and visualizations for agencies related to compliance, M/WBE utilization, etc.
• Assist the Data Officer in tracking internal performance metrics and standards.
• Assist the Data Officer in the implementation of the strategic plan for an integrated network of services.
• Assist the Data Officer in configuring and managing agency databases.
• Serve as a liaison for the agency and various SaaS providers / representatives.
• Design, distribute, and analyze the results of agency surveys.
• Present analysis findings to executive leadership, citizens, and city officials.
• Assist with user interface and application development.
• Assist the Data Officer in researching and implementing innovative technologies