Software Engineer - Data & Analytics - Salt Lake County

JOB SUMMARY

Develop applications and solutions for analytics, reporting, and data integration.  Consult with customers from all areas of Salt Lake County government.

The Business Intelligence and Analytics team is part of the county-wide IT organization.  We work with a wide variety of data and many lines of business.  Typically, a team member will work independently with a customer to conceptualize, define, and develop a project; collaborating with other team members and IT staff as needed.

Primary technologies currently in use:

• Microsoft Power BI, SQL Server, SSRS, and SSAS
• Talend Platform for Data Management
• R, Python, Java, C#
• Esri ArcGIS

Benefits of the job:

• Flexible work schedule
• Consistent 40-hour work week
• Generous paid time off: 12 holidays, 1 personal day, 12 sick days, and up to 24 vacation days.
• Up to 80% remote work (employee's choice)
• Retirement plan options: Hybrid pension/401K or 401K w/ 10% employer contribution
• Competitive benefits (example: $0 premium HDHP with up to $1475 employer HSA contribution)

MINIMUM QUALIFICATIONS

Bachelor’s degree from an accredited college or university in Computer Science or closely related field, plus two (2) years of related data and software experience in a similar environment; OR an equivalent combination of six (6) years of related data and software education and experience.

Due to the nature of this position, the successful applicant must pass a required pre-employment background check and subsequent mandatory background checks in accordance with current County Human Resources policy requirements.

ESSENTIAL FUNCTIONS

• Develops and supports software applications, systems, and integrations.
• Provides analysis, profiling, and documentation of business information systems and applications.
• Assists in design and architecture.
• Analyzes and troubleshoots technical issues and identifies modifications needed in applications to meet changing user requirements.
• Assists in reviewing requirements; developing and maintaining appropriate datasets for purpose of analysis, profiling, and documentation of business information systems and other data sources; maintains quality control on large scale datasets.
• Works with other engineers, programmers, and analysts in planning, prioritizing, and executing assigned tasks within deadlines.
• Assists in assessing training needs; preparing training documents and training application users as needed.
• Assists in determining operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions.
• Works with Quality Assurance (QA) team in preparing test cases, plans and procedures.
• Attends team meetings to communicate project status and discuss about new ideas and any issues

KNOWLEDGE, SKILLS AND ABILITIES (KSA)

Knowledge of:

• Application design and engineering.
• Distributed software development lifecycle.
• Common programming languages and standards, e.g. C#, Java, Python, .Net, REST, SOAP, JSON, XML, SQL, HTML, etc.
• Software development environments and tools, e.g. Microsoft Visual Studio, Eclipse, Git, etc.
• Databases, data design, data warehousing, data modeling (e.g. MS SQL Server, Oracle, Informix, etc.)
• High performance design, development, encryption, error logging, debugging, scalability, code reviews, development environment configuration, and testing.
• Information security, networking, access control, application configuration, application monitoring, and application performance.
• Continuous integration and continuous delivery (CI/CD)
• Cloud solutions including SaaS, PaaS, and IaaS.

Skills and Abilities to:

• Work effectively across multiple functions, cultures, and levels of the organization.
• Communicate effectively both verbally and in writing.
• Think logically and systematically; solve complex problems; effectively apply general principles to specific conditions.
• Maintain confidentiality and professionalism.
• Remain calm under stress and can quickly adjust, evolve and multi-task between several competing priorities at once.
• Apply principles and practices of quality assurance; principles and practices of database maintenance and administration.