BI Operations Data Warehouse Specialist, Senior Consultant
Vacancy expired!
OverviewGuidehouse is a leading global provider of consulting services to the public sector and commercial markets, with broad capabilities in management, technology, and risk consulting. By combining our public and private sector expertise, we help clients address their most complex challenges and navigate significant regulatory pressures focusing 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 help our clients outwit complexity and position them for future growth and success. The company has more than 12,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 www.guidehouse.com. ResponsibilitiesDemonstrates proven extensive knowledge and success in designing and implementing data warehouse solutions, including the following:
- 5+ years as a Data Warehouse Specialist
- Worked with databases including MS-SQLServer 2012, 2016, Oracle v 12, 19c, and DB2 Ver 8 and Ver 10
- Experience writing and debugging SQL queries using tools such as SQL Developer
- Experience with Putty, Toad, Exceed, Oracle Enterprise Manager, Grid, RAC, Data Guard, Spatial, SQL Plus, PL/SQL
- LUS version Putty
- File transmission using SFTP, FTP, WINSCP
- Experience with SAP Data Services
- Investigate, cleanse and manage data IBM Quality Stage
- Apache Tomcat
- Windows Task Scheduler
- Effective analytical, conceptual, and problem-solving skills
- Ability to manage multiple parallel assignments and meet specified milestones
- Ensures delivered solutions meets technical and functional/non-functional performance requirements within
- Manage day to day technical challenges and communicate to project manager any risks or issues associated with the development activities
- Client-facing experience in a consulting environment among mid-level to senior leadership
- Fantastic communicator at all levels
- Ability to perform training and mentorship
- Creates, manages and maintains required project documentation
- Build strong working relationships and manage and resolve client and team challenges
- Answering questions and providing direction to less-experienced staff
- MS-SQLServer 2012, 2016, Oracle v 12, 19c, and DB2 Ver 8 and Ver 10
- SQL Developer
- Putty, Toad, Exceed, Oracle Enterprise Manager, Grid, RAC, Data Guard, Spatial, SQL Plus, PL/SQL
- LUS version Putty
- SFTP, FTP, WINSCP
- SAP Data Services
- Apache Tomcat
- Windows Task Scheduler
- Investigate, cleanse and manage data IBM Quality Stage
- Knowledge and experience with Microsoft Professional Suite (Word, Excel & PowerPoint)
- Prior experience with IBM Quality Stage
- Prior experience with EMC Greenplum MPP, Command center and web analytics
- Prior experience with Experience in TFS GIT
- Prior experience with Python
- 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.
- 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.
- This position is open to candidates virtually from Montana, New Mexico, Utah, Wyoming, Arizona or Eastern, Pacific, Central, and Aleutian time zones.
- 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
Vacancy expired!