Navigant Senior Consultant - SQL Developer - Boulder, CO; Verona, WI in TORONTO, Ontario

Location: Boulder, Co; Toronto, ON, Verona, WI

Navigant Consulting, Inc. (NYSE: NCI) is a specialized, global professional services firm that helps clients take control of their future. Navigant’s professionals apply deep industry knowledge, substantive technical expertise, and an enterprising approach to help clients build, manage and/or protect their business interests. With a focus on markets and clients facing transformational change and significant regulatory or legal pressures, the Firm primarily serves clients in the healthcare, energy and financial services industries. Across a range of advisory, consulting, outsourcing, and technology/analytics services, Navigant’s practitioners bring sharp insight that pinpoints opportunities and delivers powerful results. More information about Navigant can be found at navigant.com.

We understand that the energy landscape is evolving. Emerging technologies and societal demand promise to reshape not only the energy we use, but also how we use it. In our Energy Practice, Navigant collaborates with energy industry clients to help them build, manage, and protect their business’ value. We help our clients anticipate where the energy industry is headed and how they can improve performance, grow, and address consumer and regulatory demands.

Our experts’ unparalleled depth of industry experience provides insight into regulatory processes, pricing, supply and demand dynamics, market design, fuel sourcing, financing, technologies, and operations. The breadth of our industry knowledge offers a full range of solution offerings, from insights to strategy and on to implementation. We provide sustainable results to help our clients thrive in an ever-changing environment.

Customers & Markets Team

Navigant’s Customers & Markets team focuses on energy efficiency, demand response and clean distributed energy resources. We help the

energy industry modernize, increase profitability, and mitigate risk through investment in a wide range of energy technologies. Our extensive industry expertise and rigorous analytical capabilities generate innovative and forward-looking insight to help clients position themselves for a profitable and sustainable future. Our team’s customer side services focus on:

  • Market Research & Characterization

  • Resource Planning & Potential Studies

  • Program Design

  • Program Evaluation (Impact & Process)

  • Regulatory & Policy Strategy & Support

.

Navigant Consulting, Inc. (NCI) is seeking a data systems expert with proven experience designing database systems using SQL. The ideal candidate will have experience designing, implementing, and testing relational database systems. This position will be part of a team of data scientists supporting diverse client needs, so flexibility and a desire for variety are key.

The work will provide exposure to a variety of systems and tools, including, but not limited to, R, SAS, MySQL, MS SQL, Microsoft BI, SharePoint, etc. to support a wide range of project use cases. Systems will perform a number of different functions from statistical analysis of field-collected data, Multi TB data analysis on interval based energy usage, to reporting against ongoing EM&V tracking data.

  • Developing and managing large databases in MS SQL

  • Developing and maintaining ETL packages

  • Creatively presenting data with use of dash boarding tools and excel reports

  • Assisting in report/presentation development

  • Incorporating R with SQL work to perform big data statistical analysis with our econometricians

If necessary, with appropriate skills in related technologies, the successful candidate can be trained on the Microsoft BI Stack (SQL Server, SSAS, SSIS, SSRS) after joining Navigant. As such, there is tremendous opportunity for growth and professional development.

  • BS in Computer Science, Information Systems, Database Management or equivalent experience.

  • Minimum 2 years of experience in gathering requirements, design, implementation, and test of relational database systems. In lieu of 2 years of experience, MS in Computer Science/Information Systems is required.

  • Strong SQL development knowledge. Experience with Transact SQL (TSQL)

  • Ability to effectively communicate with internal team members and external clients

  • Experience implementing data systems using the Microsoft Business Intelligence Stack, including MS SQL Server, SSAS, SSIS, SSRS is preferred

  • Experience developing reporting front ends for SQL Server data systems is preferred through tools like SSRS, PowerBI, Spotfire, etc…

  • Knowledge of database optimization/use of indices.

  • Experience in R is preferred

  • Experience in the energy efficiency field is preferred

The company offers competitive compensation packages including an incentive compensation plan, comprehensive medical/dental/life insurance, 401(k) and employee stock purchase plans.

Navigant does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Navigant and Navigant will not be obligated to pay a placement fee.

Navigant is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender identity or expression, age, or any other basis protected by law, ordinance, or regulation.