Data Analyst

Data Analyst

If you could go back in time and work for companies like Microsoft or Google when they were still under 50 people you’d jump at that chance.

We can’t promise that Vivonet, Inc. will be the next Google, but we can tell you that we’re receiving some pretty serious recognition in the industry for our game-changing approach to an old and tired industry.

Here are some examples of the type of attention that we’re getting:

  • We made the 2008 Ready To Rocket list. Ready to Rocket identifies companies with the greatest potential for revenue growth in the coming year. http://www.readytorocket.com
  • Red Herring Canada identified Vivonet, Inc. in its Top 50 Awards. These awards celebrate the most innovative and promising companies in Canada.
  • In 2008, Vivonet, Inc. was a finalist (we can’t win everything) in MacLean’s Top 100 Employers.

This is the type of recognition that you get when you grow by more than 200% three years in a row.

But what makes Vivonet, Inc. so special?

Our flagship product, Halo™ Secure Web-Based POS (http://www.Vivonet.com) has been turning the Restaurant POS industry on its head by giving independent restaurant owners the same type of tools as the giant chains. Now the little guy (or gal) can take on their chain-run neighbor on a level playing field.

As a result of the huge success of the Halo™ Secure Web-Based POS product, we’ve already built, what we believe is, the largest data warehouse of independent retail transactions.

Halo™ is doing to point of sale, what wikis did to encyclopedias.

Want to join our revolution? Learn more about our vision and means to get there at http://www.Vivonet.com.

Vivonet, Inc. is currently looking for a Data Analyst for our Burnaby, BC office. We are seeking a credible professional who has experience dealing with a variety of complex information structures. Your insight and ability to recognize patterns, your ability to produce elegant solutions, your swift resolution of issues and your commitment to excellence will serve you well in this position.

Responsibilities:

  • Assist with the design and implementation of new and existing products
  • Participate in design/code reviews and inspections
  • Participate in the creation and improvement of internal software development standards
  • Provide leadership and mentoring for development and compliance functions
  • Drive software best practices ensuring high quality work
  • Discover software learning and training opportunities
  • Implements and maintains database standards, guidelines and quality assurance for database deliverables including;

    • • Data loading and maintenance, ETL, splits/merges, cleansing
    • Design and implement scripts to be used by Scheduling for backup purposes
    • Design and implement scripts for recovery purposes
    • Maintenance and scheduling
    • Methods and procedures for tracking data quality, completeness, redundancy, and improvement

  • Ensure change management processes are adhered to
  • Codes complex queries, but also identifies elegant solutions by bringing different perspectives to solving problems
  • Train appropriate departments on database features and SQL skills
  • 3rd tier support for database issues, contributing to brain-storming
  • Play an active role in the management of problem analysis and resolution activities
  • Develop, implement and enforce problem management process
  • Oversee data extracts/refresh in test and development environments
  • Develop and automate database processes as possible
  • Provide consultative and technical support services to all major database development and systems integration, including:

    • • Test database creation
    • Data conversion and simulation
    • Troubleshooting
    • Distributed database implementation
    • Data security
    • Guide product architecture decisions to ensure the best application performance
    • Assists in the design of user interface and business application prototypes
    • Assist documentation and training staff in producing client-side support and operational manuals

  • Assists with database product software releases to ensure consistency, data continuity, and compatibility with dependent systems, while supporting defined SLA levels
  • Keep current on rapidly changing technological trends

Requirements:

  • 3+ years of stored procedure and query building using PL/SQL and T-SQL
  • 3+ years of database performance tuning and testing
  • Demonstrated ability to code and tune SQL queries for optimal efficiencies in Oracle and MS SQL Server
  • Strong understanding of database structures, theories, principles, and practices.
  • Knowledge of TKPROF, explain, plan, showplans
  • Experience with Microsoft Windows and Linux environments
  • Extensive experience in UNIX/Linux and Windows scripting
  • Top-notch interpersonal and communication skills
  • Must be extremely flexible, independent, hardworking and self-directed
  • Ability and willingness to do requirements gathering + refinement
  • Tenacity, initiative, and drive to see project tasks through to completion
  • Respectful of coworkers
  • Willingness to step up and fill company needs beyond job description where feasible
  • A valid BC Driver’s License with full driving privileges or equivalent

Additional Assets:

  • Knowledge of SSIS and ETL processes and tools
  • MySQL experience
  • JDBC experience
  • Oracle or Microsoft related certifications
  • Experience working within Scrum teams
  • Experience with PCI and PAPB standards
  • Experience with storing and manipulating XML data
  • Experience with .NET and LINQ in respect to MS SQL Server

Benefits:

  • Vivonet is a venture-backed company located in beautiful Burnaby, BC
  • Competitive salaries with benefits
  • Rewards courageous explorers, excellence pursuers, and team success committers

    • Ready to rocket your career? Email resume, cover letter, with salary expectations to careers1[@]vivonet.com or fax 604.408.4307 with the subject line “100628 – DATA ANALYST”

    Return to Careers.