Salesforce Programmer

Pay Range: $80,600-$84,900

*This position follows a hybrid schedule, working two days in-office and three days remotely. You must be located in the Detroit /Metro-Detroit area and have the flexibility to accommodate this schedule. The schedule is subject to change anytime during employment (with notice) and could go fully in-office or remote. *

GENERAL JOB SUMMARY

As Data Programming Administrator, the primary responsibility involves overseeing the administration of the Salesforce application and managing various data analysis and geospatial activities. The role focuses on configuring and manipulating data to meet the program and business requirements of the department.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Oversee day-to-day user administration, security settings, and permissions on the DLBA's Salesforce platform.
• Design, develop, and configure solutions utilizing the complete Salesforce toolset, including custom objects and fields, validation rules, Visualforce pages, Lightning components, workflows, triggers, and process builder.
• Administer daily configuration and manipulation of objects, fields, and page layouts.
• Assist in creating complex workflow rules, data validation, and triggers.
• Document system changes, produce training materials, conduct end-user training, and resolve issues.
• Identify data requirements through customer interviews, analysis of department applications, programming, and operations, and evaluation of existing systems.
• Design, develop, test, document, and deploy third-party integrations with Salesforce.
• Create and maintain views, reports, dashboards, and other Salesforce.com forms, page layouts, custom objects, and applications as needed.
• Design, create, and manage user roles, security, groups, permission sets, queues, and profiles.
• Execute test plans to ensure high-quality delivery.
• Collaborate with departmental subject matter experts, data, and support teams on solutions, maintenance, and process improvements aligning with business objectives.
• Participate in cross-functional project teams.
• Generate workflow diagrams, component diagrams, sequence diagrams, and other relevant documentation.
• Provide detailed estimates of the effort required to implement capabilities based on business requirements and solution design.
• Ensure data integrity throughout DLBA inventory and programs.
• Stay current with professional and technical knowledge through educational workshops, reviewing publications, networking, benchmarking, and participating in professional societies.
• Perform additional related duties as assigned by the department Assistant Director or Director.
• QUALIFICATIONS (Knowledge, Skills, Abilities):
• Knowledge of web-based systems architecture, service-based architecture, and enterprise application architecture.
• Experience managing expectations while balancing alternatives against business and financial constraints.
• Ability to develop and maintain working relationships and communicate effectively across all staff levels.
• Demonstrated good judgment and a pragmatic approach to delivering solutions that optimize architecture activities across company needs, business constraints, and technological realities.
• Professional knowledge and relationships with the Salesforce ecosystem.
• Organized and analytical, with the ability to work effectively in a team environment.
• Design and implementation of project schedules, handling multiple priorities in a fast-paced environment.
• Proficiency in Microsoft 365 (Teams, Word, Excel, PowerPoint, Access, Outlook).
• Mission-driven individual with high personal integrity and a strong sense of public service to the residents of the City of Detroit.

EDUCATION/EXPERIENCE

• Bachelor’s Degree in Computer Science, GIS Software Engineering, Management Information Systems, or Urban Planning/Public Policy (with a focus on data manipulation) or related field
• At least one (1) year of experience with data manipulation
• Experience with enterprise integration tools and extract, transformation and load (ETL) tools
• Experience with process review and improvements
• Experience with Salesforce (or other relevant system) configuration and custom development strongly preferred

SPECIAL REQUIREMENTS, LICENSES, AND CERTIFICATIONS

• SFDC Certifications: Salesforce Certified Administrator or higher, preferred