Do you value collaboration, continuous improvement, and public service? At this progressive and innovative public transit organization, we believe in providing people with the independence to achieve their goals, creating a more vibrant, sustainable, and equitable community.
We proudly present an exciting career opportunity which offers an attractive starting wage, an excellent benefit package, and an inclusive, friendly work environment. Lane Transit District values diversity and strives to expand representation at all levels of the workforce. We welcome applications from BIPOC, women, people with disabilities, members of the LGBTQ community, and veterans.
As SQL Server Database Developer you will be responsible for improving the quality of data analytics to produce high-quality SQL programming for purposes of, but not limited to, SQL Integration (SSIS), Reporting (SSRS and Power BI) and to support business process. Strong documentation is a must. This person will be an integral part of the Data Warehouse team. They will be tasked with a range of tasks from SQL Server maintenance and monitoring to understanding business requirements, data structures and data relationships. They will design, develop, test, document, upgrade, convert and transition SQL objects; they will convert SSRS and legacy Crystal reports to Power BI.
The ideal candidate is someone who is excited about modernizing data flows and developing clear, useful and documented data objects and processes. Must be comfortable working independently and advising lead IT team members on courses of action in SQL Server sizing, maintenance. This is an ideal position for someone with strong SQL Foundations and a desire to build on those skills toward becoming a SQL DBA at some point in the future.
- Can articulate and complete a process of discovery to build understanding about enterprise user core systems (those with SQL Server foundations).
- Will be a creative thinker who can translate business needs and produce required data objects.
- Will work IT Help Desk tickets with database, SQL, and reporting issues and following those issues to resolution, with documentation.
- Can develop SQL Job automation schedules for data flows that maintain DW sources (dimension and fact and others) and maintain or change same, if required, to reduce contention.
- Work closely with all staff to understand business problems and work collaboratively toward solutions.
- Develop and maintain technical documentation for reference, future planning and disaster recovery.
- Develop and maintain a report catalog.
- Manage confidential data, including HIPPA protected information.
- Validate data, including frequent communication with users to assess confidence in reports.
- Develop long-term plans for report maintenance.
- Design performance metrics related to Power BI and SSRS usage as well as report adoption.
- Performs related work as required.
- Gathering Information - Observing, receiving, and otherwise obtaining information from all relevant sources.
- Processing Information - Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- Communicating Internally - Coordinating across all roles and levels to areas, co-workers, and internal stakeholders
- Organizing, Planning, and Prioritizing Work - Developing specific goals and plans to prioritize, organize, and accomplish your work.
- Thinking Creatively - Developing, designing, or creating new applications, ideas, relationships, systems, or products.
- Making Decisions and Solving Problems - Analyzing information and evaluating results to choose the best solution and solve problems.
- Computer Literacy - Knowledge of standard business tools, such as computers, cell phones, and software including Microsoft Office Suite.
- Customer and Personal Service - Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
- Active Listening - Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
- Time Management - Managing one's own time and the time of others.
- Speaking - Talking to others to convey information effectively.
- Service Orientation - Actively looking for ways to help.
- Monitoring - Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
- Reading Comprehension - Understanding written sentences and paragraphs in work related documents.
- Writing - Communicating effectively in writing as appropriate for the needs of internal and external audiences.
- Active Learning - Understanding the implications of new information for both current and future problem-solving and decision-making.
- Critical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
- Oral and Written Comprehension - The ability to listen to, read, and understand information and ideas presented through spoken words, sentences, and writing.
- Oral and Written Expression - The ability to communicate information and ideas in speaking and writing so others will understand.
- Speech Recognition - The ability to identify and understand the speech of another person.
- Speech Clarity - The ability to speak clearly so others can understand you.
- Selective Attention - The ability to concentrate on a task over a period of time without being distracted.
- Deductive Reasoning - The ability to apply general rules to specific problems to produce answers that make sense.
- Mathematical Reasoning - The ability to choose the right mathematical methods or formulas to solve a problem.
- Time Sharing - The ability to shift back and forth between two or more activities or sources of information.
- Category Flexibility - The ability to generate or use different sets of rules for combining or grouping things in different ways.
- Problem Sensitivity - The ability to tell when something is wrong or is likely to go wrong.
- Information Ordering - The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
- Perceptual Speed - The ability to quickly and accurately compare similarities and differences among sets of letters, numbers, objects, pictures, or patterns. The things to be compared may be presented at the same time or one after the other. This ability also includes comparing a presented object with a remembered object.
- Inductive Reasoning - The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
- Originality - The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem.
- Fluency of Ideas - The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).
Microsoft Office Suite - Outlook, Word, Excel, PowerPoint, SharePoint, Visio, T-SQL, SSIS, SSRS, SSMS.
MINIMUM QUALIFICATIONS FOR HIRE:
- Bachelor Degree (or higher) or 4+ years of professional work experience.
- Must possess an ability to connect to SSMS, discover database objects, read views and stored procedures, document and read data flows and develop reports to specifications.
- Demonstrated ability to write SQL queries and develop SQL views or stored procedures.
- Experience querying tabular models with MS Excel and SSRS
- Must be able to effectively and proactively communicate with the IT and business teams to gather technical input and understand output needed
- Must have experience with SSRS report development
- Ability to work autonomously and self-motivate
- Ability to work well with a remote team and remote subject matter experts
- Creativity in simplifying and organizing visualizations with report content
- Experience understanding the connections of applications to databases is helpful.
- Ability to create data maps
- Experience working with Source Control systems with databases wand reporting objects
- Experience with tools that help track and record hours of work.
- Crystal reports experience
A valid Oregon State Driver's License and a driving record acceptable to the District's insurance carrier.
A minimum of 1 year, but less than 3 years, of on-the-job training is normally required to perform the job effectively. Continuous training and development will be expected in order to obtain and to utilize current and "cutting edge" knowledge and practices in the day-to-day performance of one's job duties.
Incumbents work with significant independence. Work and schedule is dependent on demands across the organization. Generally, work can be scheduled during normal business hours but any requirements needing operation or maintenance observation and input could require early morning and overnight hours. During systems implementations and upgrades, position may be required to work longer hours or weekend hours to accommodate support needs. In addition, during rare cases, this role may need to be on call for emergency technology response.
Incumbent follows procurement policies and procedures with regard to financial decisions, however, incumbent does not have direct financial authority.
Adept at communicating highly complex business problems and equally complex data solutions in user-friendly terms. Position requires ability to negotiate tactfully across a range of business process stakeholders. Must maintain confidentiality of business data, including adherence to federal regulation for certain classes of data e.g. protected health information (PHI), employee personnel information, etc.
This position does not supervise others.
COVID POLICY: At this time LTD requires all new hires to be fully vaccinated.
Work is performed mostly in a remote/hybrid office environment, during business hours. Equipment utilized includes standard office equipment including personal computer, with job specific software and peripherals. The majority of each day will be spent on the computer. At times this role will be expected to do work at LTD sites.
Lane Transit District is an Affirmative Action/Equal Employment Opportunity Employer. Materials are available in alternative formats by calling 541-687-5555.