Guidehouse BI Operations Database Architect/Analyst, Senior Consultant in Albany, New York
Guidehouse 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.
Demonstrates proven extensive knowledge and success in designing and implementing database solutions, including the following :
7 + years of experience as a Data Architect
Experience writing and debugging SQL queries using tools such as SQL Developer & Toad Data Point
Worked with databases including DB2 Ver 8 and Ver 10 , MS- SQLServer 2012, 2016 and/or Oracle v 12, 19c
Worked on SQL Server 2008 studio - Microsoft Management Studio, SQL Server Business Intelligence Development Studio, Integration Services, Performance Tools (Database Engine Tuning Advisor & SQL Profiler)
Experience with Apache Tomcat
Experience on Python
Experience with Putty, Toad, Exceed, Oracle Enterprise Manager, Grid, RAC, Data Guard, Spatial, SQL Plus, SQL developer , PL/SQL
Experience on SFTP, FTP, WINSCP
Worked on Scheduler tools like Windows Task Scheduler
Effective analytical, conceptual, and problem-solving skills
Ability to manage multiple parallel assignments and meet specified milestones
Provides technical expertise in the diagnosis and resolution of an issue, including the determination and provision of workaround solution or escalation to owners
Advanced knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines
Advanced proficiency in analytical, project planning, negotiating, interpersonal, and communication skills (written and oral)
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
Ensure architecture and design of the solution is in alignment with overall enterprise architecture
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
Minimum Years of Experience: 7
Minimum Degree Required: Bachelor's degree from an accredited college or university
Database - DB2 Ver 8 and Ver 10 , Oracle v 12, 19c , MS-SQL Server 2012, 2016 , PL/SQL
SQL Editor - SQL Developer , PL/SQL
SQL Server - SQL Server 2008 studio - Microsoft Management Studio, SQL Server Business Intelligence Development Studio, Integration Services, Performance Tools (Database Engine Tuning Advisor & SQL Profiler)
Oracle Connector/Access media - Putty, Toad, Exceed, Oracle Enterprise Manager, Grid, RAC, Data Guard, Spatial, SQL Plus, SQL develop er
Transmission - SFTP, FTP, WINSCP
Knowledge and experience with Microsoft Professional Suite (Word, Excel & PowerPoint)
Prior Experience on SAP Business Objects ( Web Intelligence and Web Intelligence Rich Client )
Prior Experience on BODS ( SAP Data Services )
Prior experience working with financial data
Prior experience working in federal environment
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.
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 RecruitingAccommodation@guidehouse.com . 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.
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
- Guidehouse Jobs