Senior Consultant, Data Architect & Engineer

at Guidehouse in Montpelier, Vermont, United States

Job Description


Guidehouse is a leading global provider of consulting services to the public and commercial markets with broad capabilities in management, technology, and risk consulting. We help clients address their toughest challenges and navigate significant regulatory pressures with a focus on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that prepare our clients for future growth and success. The company has more than 10,000 professionals in over 50 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies. For more information, please visit:


The Energy Sustainability & Infrastructure (ES&I) Analytics team is seeking a data architect and engineer with proven experience designing and developing databases, data warehouses, and ETL solutions. The ideal candidate will have experience designing, implementing, enhancing, maintaining, and testing relational database systems and ETL solutions. This position will be part of a team of data scientists supporting diverse client needs. The work will provide exposure to a variety of systems and tools, including, but not limited to, Snowflake, MS SQL, R, Shiny, ArcGIS, Blob storage, etc. in support of a wide range of project use cases. Systems will perform a number of different functions including but not limited to geospatial transportation analytics, multi-terabyte data analysis on interval-based energy usage, and reporting against ongoing EM&V tracking data Support delivery of database solutions by producing and communicating deliverables for both internal and external clients. Common responsibilities include:

+ Assist consulting staff working with large data to set up and query Snowflake databases

+ Implement analytical / data warehousing platforms and analytics solutions, and support project team use of the same

+ Support data management solutions specifically designed and optimized for use with:

+ RStudio Server (R Analytics)

+ Rstudio Connect (Shiny Dashboards)

+ Analytica


+ Serve as a resource for project teams looking to ingest, store, and query structured data.

+ Implement, enhance and maintain large databases solutions and complex ETL pipelines

+ Automation of existing and new database and ETL solutions

+ Incorporating R with SQL work to perform big data statistical analysis

+ Collaborate across teams to problem-solve and provide content expertise to tailor solutions for individual clients

+ The ideal candidate will also be expected to keep pace with technology trends and explore new ideas and solutions to problems. As such, there is tremendous opportunity for growth and professional development.


Required: · Bachelor’s or Master’s degree in Computer Science, Information Systems, Math, Engineering, Database Management or equivalent work experience · 2+ years of experience in gathering requirements, design, implementation, and test of relational database systems · 2+ years of experience designing, implementing and maintaining complex ETL solutions Preferred: · Experience with source code version control technologies such as Git and Azure DevOps · Ability to effectively communicate with internal team members and external clients · Ability to effectively communicate with both technical and non-technical audiences · Experience with the Microsoft Business Intelligence Stack, including MS SQL Server, SSAS, SSIS, SSRS is preferred · Big data platform experience is preferred; Experience with Linux is preferred · Experience in R is preferred · Experience in the energy efficiency field is preferred · Experience with Snowflake · Experience with geospatial databases and processes

Additional Requirements

The successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevent the candidate from performing the job responsibilities as described. This position is open to candidates virtually from Montana, New Mexico, Utah, Wyoming, Arizona, Hawaii or Eastern, Pacific, and Central time zones. Due to our contractual requirements and federal orders, including an Executive Order from the White House and an emergency regulation from the Centers for Medicare & Medicaid Services (CMS), the position for which you are applying requires that you provide proof of your vaccination status. If you are unable to receive the COVID-19 vaccine for medical reasons or because of a sincerely held religious belief, you may request an exemption from the vaccination requirement which shall be reviewed after the submission of requested documentation. If an accommodation is granted, the conditions may include weekly testing and masking. All Guidehouse employees also agree to follow any additional health and safety mitigation policies that may be required in the workplace.


About Guidehouse Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee. Rewards and Benefits Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Benefits include:

+ Medical, Rx, Dental & Vision Insurance

+ Personal and Family Sick Time & Company Paid Holidays

+ Position may be eligible for a discretionary variable incentive bonus

+ Parental Leave and Adoption Assistance

+ 401(k) Retirement Plan

+ Basic Life & Supplemental Life

+ Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts

+ Short-Term & Long-Term Disability

+ Tuition Reimbursement, Personal Development & Learning Opportunities

+ Skills Development & Certifications

+ Employee Referral Program

+ Corporate Sponsored Events & Community Outreach

+ Emergency Back-Up Childcare Program

Copy Link

Job Posting: JC192153849

Posted On: Sep 11, 2021

Updated On: Mar 27, 2022