Previous Job
Sr Programmer Analyst BI/ETL
Ref No.: 17-00059
Location: Mequon, Wisconsin
Position Type:Contract
Start Date: 02/15/2017
Charter Manufacturing Company, Inc. (Mequon, WI)

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 Charter Manufacturing's 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 Charter's 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 modeling 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.