5+ years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Job Category:
Information Services
See more jobs for students and recent grads who studied:
Senior Programmer/Analyst - BI/ETL
Systems Search | Mequon, Wisconsin
Tell Us More About Your Job Preferences
By telling us what you think of this job, we can help find jobs that match your interests. If you want to see more jobs like this, click on the smiley face. Or if this job isn't what you are looking for, click the frowny face. Learn More...

Follow This Company

Job Description

The Sr. Programmer/Analyst is responsible for performing analysis, modification, and daily support of the Business Intelligence activities that are of a high level of complexity and business impact under minimal supervision. This position will work closely with Information Technology and business personnel to understand business requirements and ensure that developed and purchased applications properly function to meet business needs across the organization. The Sr. Programmer/
Analyst will consult with members of the business community at all levels to identify current operation procedures, clarify program objectives, interpret and evaluate business requirements and provide effective, efficient and innovative system and programming solutions in a fast paced team oriented environment.

With minimum supervision, the Sr. Programmer/Analyst reviews, analyzes, and modifies application systems and programs, including designing, coding, testing, debugging, documenting and installing applications to support the organization's business information systems. Consults with users to identify current operating procedures and to clarify program objectives. The Sr. Programmer/Analyst will develop program and system specifications of moderate to high levels of complexity to be acted upon personally or by others on the IT staff for program development. Participates in on-call and after-hours application and end user support as required. Works closely with senior IT personnel members to coordinate application integrity, security, and dependability for the operational and long term success of IT and business objectives.

The Sr. Programmer/Analyst will work individually and with project teams to develop application programs and business systems, addressing support needs, troubleshooting application issues, resolving code issues. The Sr. Programmer Analyst will work with IT and business personnel, vendors and service providers. The Sr. Programmer/Analyst will work with more junior associates to help them develop additional skills and abilities for program design, troubleshooting, issue resolution, platform and environment training, and system process flows. The Sr. Programmer/Analyst supports and enforces the Software Development Life Cycle (SDLC) and Change Management disciplines of IT in order to maintain appropriate levels of quality and to reduce risk in the operation of systems, equipment, and general business processing.


  • Use strong analytical skills to produce a well-structured ETL data model design to support intuitive dashboards
  • Design ETL processes and data flows to align with long-term Data Warehouse Architecture
  • Managing multiple data sources and projects to support analytics objectives
  • Define and oversee best practices to guide long-term enterprise data quality
  • Build and maintain relationships with business information owners to implement our BI strategy
  • Work with business users to collect requirements for analytics, dashboards, and reports
  • Provide documentation on interfaces, jobs, schemas, standard operating procedures, data movement and databases
  • Oversee Change Management Process for Business Intelligence solutions assuring all code changes are properly documented in the BI and data warehousing space
  • Provide training and technical support to business users
  • Interpreting, debugging, and optimizing ODI SQL outputs
  • Understanding of application configuration, primarily Oracle Data Integrator (ODI)
  • Understanding of design concepts in ELT vs ETL
  • Guide long term integration application direction including administration, testing and future upgrade assessments
  • Manage ETL processes in Linux/UNIX/Windows operating systems


  • Bachelors degree in Computer Science, Management Information Systems or other technical discipline or equivalent work experience
  • Eight years previous programmer and programmer/analyst experience working with end users in requirements gathering, analysis, and application design and development in a Client Server and/or web based environment.
  • Five years Oracle or similar database design and support experience
  • Experience guiding Data Warehousing and Business Intelligence best practice design principles
  • Must have experience with multi-source extract and varying data warehouse design concepts
  • Strong knowledge of BI tools
  • Proven experience working with data warehousing, ETL, operational reporting, Business Intelligence concepts, tools and procedures
  • Strong technical experience working with data modelling principles and techniques
  • Experience working with data warehousing concepts, terminology, and architecture
  • Microsoft Windows operating system experience and Office applications
  • Strong written and verbal communication skills
  • Participate in on-call and after-hours application and end user support.


Applicants must be eligible to work in the specified location

About Systems Search

Dunhill Staffing Systems has demonstrated a long-term commitment to the staffing industry. We are the second largest placement firm, by dollar revenue in the United States. Our nationwide network of over 125 offices can communicate with each other to fill your positions faster and more effectively than the competition. One of the things we are most proud of at Dunhill is our interview-to-placement-ratio. This ratio describes the system wide average number of interviews it takes to successfully place a candidate into a job. This ratio can tell you a great deal about the recruiting company with whom you are working. The industry average interview to placement ratio is currently 10:1. At Dunhill, our 4:1 ratio is among the best - great news for both hiring managers and candidates. This means that we protect the time of our hiring managers by making sure they are only speaking with qualified individuals who are ready to make a career move for the right opportunity. For candidates it means we protect your time and energy as well - only sending you on interviews for which you are well qualified.

This company profile was created by AfterCollege and is about Systems Search. This page is not endorsed by or affiliated with Systems Search. For questions regarding company profiles, please email: care@aftercollege.com.