Send this job to a friend
Department: Information Technology
Schedule: Full-Time
Shift: Days
Hours: 8-5p
Job Details:

Summary:

This position is responsible for the design and implementation of Business Intelligence (BI) solutions through the creation of data ware houses, data marts, and data stores.  They also provide organizational support through the development of business dashboards and reports support departmental decision making.  This role works under the direction of the IT manager fin the Information Management department.  The role will interface directly with business customers and other technology application analysts.

 

Essential Job Responsibilities:

  • Providing solutions to client defined data and reporting needs.
  • Analyzing manual processes and designing programs to automate those processes.
  • Formulating and defining SQL/BI scope and objectives through research and fact-finding endeavors.
  • Designing, coding, testing, documenting, and troubleshooting SQL/BI deliverables.
  • Designing and implementing organizational and departmental dashboards.
  • The role requires preparing and reviewing detailed design specifications from which metadata or reports will be written.
  • Collaboration with others to test and resolve issues with deliverables.
  • Contributing to the development of estimates, project plans, and milestones.
  • Participating in medium or large, moderately complex projects with limited direct supervision.
  • Demonstrated commitment to continual learning while maintaining a knowledge base.
  • Monitoring and maintaining database integrity/security for SQL and SharePoint servers.
  • Performs other duties as assigned by the Information Technology Manager

Essential Job Qualifications

  • A Bachelors Degree or equivalent background and work experience in computer programming.
  • Good experience in preparing IT technical documents and presentations.
  • Requires strong and very effective, verbal and written communication skills.  Ability to express complex technical concepts effectively, both verbally and in writing.
  • Proven ability to handle multiple tasks and projects simultaneously.
  • Excellent analytical skills, attention t detail and problem-solving skills.
  • Willingness to learn and stay current on technology trends and upcoming features.
  • Ability to work in a team-oriented environment.
  • Must be self-motivated and demonstrate strong initiative.
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
  • Physical Demands
    • Able to exert up to 10 pounds of force occasionally (up to 1/3 of the time)
    • Able to lift, carry, push, pull, up to 20 pounds occasionally
    • Able to sit for the majority of the time, but may involve brief periods of time involving walking or standing.
    • Able to use keyboard frequently (3/4 of the time)

Technical Skills:

  • 2+ years' experience with SQL programming
  • Knowledge with software development methodologies, relational and dimensional database skills, and design skills.
  • Strong SQL skills are required, preferably with Microsoft SQL.
  • Familiarity with Microsoft Business Intelligence stack (SQL, Analysis Services, Integration Services, Reporting Services, MDX coding) or other equivalent Business Intelligence products.
  • Experience implementing data warehousing/ business intelligence solutions in a SQL environment is a plus
  • Knowledge of dash boarding technologies (MS PerformancePoint a plus)
  • Knowledge of SharePoint technologies a plus


back to top