Job description
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.
Responsibilities
Guidehouse is seeking candidates with extensive knowledge of and hands‐on experience with Embarcadero ER/Studio, MS-SQLServer, Oracle and DB2 databases and other associated development tools. The Database Architect will be responsible for data modeling, creating databases and understanding ETL technologies using SSIS. This candidate will interact with internal and external team members to provide technical solutions using Agile methodology.
This position requires the individual to provide planning, estimation, scheduling, prioritization and coordination of technical activities related to report development with multiple stakeholders. Accountable to business and technology management for end-to-end application scoping, planning, development and delivery that meets and exceeds quality standards. Our professionals help our clients to harness their data to transform their business processes, improve internal controls, improve efficiency of operations, increase transparency and performance management, and to comply with Federal laws and regulations.
- Demonstrates proven extensive knowledge and success in designing and implementing database solutions, including the following:
- 8+ years of experience as a Database Architect
- Experience using Embarcadero ER/Studio Tools including Data Architect, Repository & Portal.
- Experience on ETL Technologies MS SSIS Packages and Data Quality by using IBM Quality Stage.
- Experience on Statistical Computation by using SAS.
- 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 / 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
- 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
- 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).
- Provides technical expertise in the diagnosis and resolution of an issue, including the determination and provision of workaround solution or escalation to owners
- 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
Qualifications
Required:
- Minimum Years of Experience: 8
- Minimum Degree Required: Bachelor's degree from an accredited college or university
- Hybrid Positions: Compensation may vary based on education, skills, experience and location. Selected candidate must be local and able to work from one of the following offices: Tysons, VA (HQ); Washington DC; Tampa, FL; Atlanta, GA; Chicago, IL; Huntsville, AL as needed. Client meetings may be required in-person.
- Data Modeling - Embarcadero ER/Studio Data Architect, Repository, Portal
- ETL - MS SSIS Packages
- Data Quality - IBM Quality Stage
- Statistical Computation – SAS
- Database - DB2 Ver 8 and Ver 10, Oracle v 12, 19c, MS-SQL Server 2012, 2016, PL/SQL
- SQL Editor - Toad Data Point & SQL Developer
- 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)
- Transmission - SFTP, FTP, WINSCP
- Knowledge and experience with Microsoft Professional Suite (Word, Excel & PowerPoint)
- Prior experience working with financial data
- Prior experience working in federal environment
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.
Disclaimer
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 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.
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
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.