Business Intelligence Developer
Role details
Job location
Tech stack
Job description
- 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, 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.
Requirements
Do you have experience in Business requirements?, Do you have a Trade school?, 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.
Benefits & conditions
Pulled from the full job description
- AD&D insurance
- Health insurance
- Retirement plan
- Dental insurance
- Flexible spending account
- Life insurance
- Disability insurance, 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., The City of Saint Paul offers a competitive benefits package for permanent, certified positions. Temporary positions are not eligible for benefits.
Benefits vary with each position and the collective bargaining agreement. Benefits may include:
City Paid Benefits
- Health Insurance
- Vacation/Holidays
- Sick Leave
- Life Insurance
- Subsidized Metro Bus Pass
- Deferred Compensation
- Retirement Program
Optional Benefits
- Dental
- Flexible Spending Accounts
- Disability Insurance
- Accidental Death and Dismemberment Insurance
- Long Term Care Insurance