Description
The City of Saint Paul Office of Technology and Communications (OTC) is hiring a Business Intelligence Developer on the City’s Information Systems team. In this role you will help shape how data is used to improve services and operations for the residents of Saint Paul. You will build reports, dashboards, analytics and the data infrastructure that will support departments with actionable insights for informed decision-making. This role partners with departments across the City to understand data needs, drive enterprise data projects, identify meaningful approaches to interpreting and applying data, and develop compelling visualizations. You will also be instrumental in advancing the City’s enterprise data culture by promoting best practices and helping teams leverage data more effectively.
Our Benefits: We offer competitive wages, and a variety of excellent benefits (Download PDF reader), including health insurance, retirement contributions and paid vacation and sick time.
Equity, Inclusion and Belonging: The City of Saint Paul is dedicated to dismantling systemic racial, cultural, and economic barriers that prevent people from fully enjoying and participating in our community and ensuring fairness in opportunities and outcomes for all individuals. At the City of Saint Paul, we want our workforce to reflect the diverse city that we serve. Our leaders are guided by an unapologetic equity agenda, which promotes the belief that true equity is building a city that works for all of us. We encourage you to apply as we are most interested in finding the best candidate for this job.
Responsibilities
Here's what you can expect to do:
- Design, build, and maintain City’s data warehouse, data models, and database/reporting environments
- Develop and manage Extract Transform Load (ETL) processes and data pipelines
- Write, troubleshoot, and maintain SQL code
- Contribute to enterprise data infrastructure planning and development
- Develop reporting frameworks and produce reporting deliverables
- Manage the City’s data and metadata to ensure security, extensibility, and accuracy
- Provide data access to City staff and the public via enterprise data access tools
- Collaborate with City departments to understand business needs and develop effective solutions
- Communicate with end users to ensure reporting and analytics deliverables meet expectations
- Help business users leverage appropriate business intelligence tools, techniques, and best practices
- Provide business partners with training and capacity-building support in data stewardship and data literacy
- Champion and promote a strong data culture across the city
For more information and essential functions, see our job description.
Information Specific to this Position: This position is located at 25 4th St. W, Saint Paul, MN offering a hybrid schedule with mandatory in office days on Wednesdays and expected to be in office 2-3 days a week.
Qualifications
Position Requirements
- A Bachelor's Degree in Information Management, Computer Technology or related field; and four (4) years of vacancy-related work experience, or vacancy-related technical school certificate and six (6) years of work experience related to the vacancy.
- Work experience must have included business analysis and project definition that would allow one to gain a good understanding of technology relevant to the vacancy.
- A combination of education and experience to equal 8 years or more can be used to qualify for the position.
- May require a valid Minnesota Class D Driver's License, or equivalent out-of-state driver's license.
How to Apply Submit a City of Saint Paul online application by the closing date. Upload the following required document via the online application system. You will not be able to submit your application without these documents attached. (Zip files and web links will not be accepted. Each uploaded attachment is limited to 10MB.) A resume First time applying online? Read our How to Apply Online Guide.
Need technical support? For help with the online application, please call 1-855-524-5627.
Learn more about our Hiring Process Open Job Posting: This posting is open to anyone who meets the position requirements.
Selection Process: Applicants who meet the minimum job requirements will be placed on a hiring list for consideration. Hiring Managers may interview/hire anyone from the list. You will be notified if you are invited to participate in the final selection process which may include an interview, job simulation, work sample submission, or other evaluation method.
Condition of Employment: This position also requires a background check and may require a driver’s license check. Candidates will be required to submit proof of education to Human Resources upon conditional job offer. This position may be subject to limited on-call status for after-hours services associated with the assignment.
Human Resources Contact Information: Danni Smith at 651-266-6566 Email: danni.smith@stpaul.gov
The City of Saint Paul encourages individuals to apply for positions regardless of criminal history.
Veteran’s Preference: If you are a veteran and would like to receive Veteran’s preference in accordance with MN Statute 197.455, you must submit a photocopy of your DD214 preferably at time of application. Click here for more information.
Equal Employment Opportunity Statement: The City of Saint Paul is an equal opportunity/affirmative action employer. Veterans, women, persons of color, members of the LGBTQIA+ community, and individuals with disabilities are strongly encouraged to apply.
Working Title: Business Intelligence Developer Official Title: IS Systems Consultant II
City of Saint Paul
200 City Hall Annex
Saint Paul, Ramsey, MN 55102
US
