Programmer Analyst 2

Lane County Technology Services is seeking a BI programmer analyst to contribute to the County’s continued growth in the use of Business Intelligence. You will work closely with project managers, business analysts, technical peers, and customers who are subject matter experts in a wide range of data sources from internal and external business applications across the County’s departments and services.

  

You will build and support solution data sets, data sources, data cubes, ETL processes, queries, reports, and dashboards to connect customers to data sources to serve customer BI needs. You should be adaptable, open to change, team focused, seek engagement with others and adept in all forms of communication with a diverse community of technical and non-technical people at all levels. 

Experience desired in BI development and support using Microsoft SQL Server, SQL Server Analysis Services, SQL Server Integration Services, ETL processes, Tableau. Knowledge or aptitude for financial accounting data is essential. Knowledge of or experience with C# and with ESRI GIS tools and data are a plus.

The Programmer Analyst 2 performs intermediate systems analysis and computer programming for the design, development, implementation and maintenance of application software systems to meet the goals and objectives of the customer served; and performs related duties as assigned.

 

COVER LETTER REQUIREMENTS:  In your cover letter, please address the follow questions:

Schedule: Monday – Friday; 8:00am – 5:00pm

*This is an AFSCME represented position*

In alignment with Lane County's Strategic Plan, incumbent(s) will be expected to demonstrate the following core behaviors: Passion to Serve, Driven to Connect, and Focused on Solutions.

The 2018-2021 Strategic Plan focuses on the areas that Lane County will pursue as a way to deliver on our vision for the residents of Lane County. To meet these challenges, we know that the basis of our efforts lies in leveraging our people and partnerships to achieve our Strategic Priorities. We also recognize that the quality and commitment of our staff is essential to a shared future where Lane County is the best place in which to live, work, and play.EXAMPLES OF DUTIES - DUTIES MAY INCLUDE, BUT ARE NOT LIMITED TO THE FOLLOWING:

• Provides internal and external customer service.

• Writes, tests, and documents computer programs.

• Participates in comprehensive application design.

• Plans, organizes and produces technical documentation and procedures.

• Develops and provides requested reports to management.

• Researches products and services for technology purchases.

• Confers with departmental or agency representatives to determine business requirements.

• Assists with tasks to establish application functional specifications.

• Evaluates, customizes, installs, and documents system components.

• Evaluates vendor hardware and application software for feasibility and cost benefit.

• Provides operational and technical support.

• Mentors staff at lower levels of the series

• Performs routine database administration and reporting functions.

• Implements and maintains application systems.

• Participates in the development of Request-For-Proposal (RFP's).

• Provides training to technical staff and users.MINIMUM QUALIFICATIONS:

• Customer service practices.

• Standard programming techniques.

• General computer operations, procedures, and operating systems.

• File structures, database concepts and capabilities of computer equipment.

• Computer hardware and software technologies.

• Basic troubleshooting procedures.

• Technical documentation procedures.

• Data management techniques and concepts.

• User interface design.

• Systems analysis, design principles, common methodologies, and tools.

• More advanced troubleshooting procedures.

• Application development environments.

• Security concepts and techniques.

• Personal computers, personal computer concepts, and the operation of personal computers.

• Establish and maintain effective working relationships.

• Effectively contribute to projects as a member of a team.

• Perform a variety of programming tasks.

• Program in one or more computer languages.

• Convey technical information simply and clearly, both verbally and in writing.

• Troubleshoot and resolve application problems.

• Improve technical skills.

• Participate in systems analysis.

• Develop application, functional, and design specifications.

• Analyze business processes.

• Design, develop, implement and maintain applications systems.

• Apply technical writing methodologies and tools to develop and maintain procedures and technical documents.

• Evaluate, recommend and implement vendor developed software.

• Work with database management systems for application development and maintenance.EXPERIENCE AND TRAINING; ADDITIONAL INFORMATION:

Equivalent to a Bachelor's degree from an accredited college or university with major coursework in computer science or a related field.

Two years of programming experience that demonstrates an increasing level of software systems expertise.

An equivalent combination of experience and training that will demonstrate the required knowledge and abilities is qualifying. An example would be 6 years of programming experience that demonstrates an increasing level of software systems expertise.

• If required to drive, must be in possession of a valid driver's license at time of application, and a valid Oregon Driver's license by the time of appointment.

• As a condition of employment, these positions require a criminal background investigation and a security clearance as required by State or Federal regulatory requirements.

The Board of County Commissioners wants to help Lane County be the healthiest county in the state. Effective October 1, 2018, any tobacco use, including vaping devices, will not be allowed inside or on the grounds of properties owned or occupied by Lane County including: All outdoor areas, parking lots, County vehicles, and personal vehicles while on County property.

Lane County is an Equal Opportunity Employer. We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace. All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Amendment Act and would like to request an accommodation, you may request an accommodation during the online application process, or request an accommodation by contacting the Department of Human Resources prior to the recruitment close date at 541-682-3124.