Data Architect
Company: Guidehouse
Location: Sacramento
Posted on: March 17, 2023
|
|
|
Job Description:
Job Family :
Database Administration (Digital)
Travel Required :
None
Clearance Required :
Ability to Obtain Public Trust
What You Will Do :
Data Architecture & Design
Identifies organization-wide initiatives and makes recommendations
for data warehouse growth and integration for the enterprise.
Leads the overall design of the data warehouse and works to ensure
performance objectives are met.
Work with the development teams in the data modeling and database
design of product and efficient SQL for fast application
performance
Extensive knowledge and high level of proficiency with Microsoft
SQL Server required.
Extensive familiarity with data management principles and best
practices in order to properly store, migrate, and structure data
for multiple applications
Design conceptual, logical, and physical database models for data
warehouse applications.
Oversee the evolving architecture of the data warehousing
environment, either changing existing data models or developing new
models to support new or expanded data content.
Development, Testing & Implementation
Assist in integrating current on-prem data to the cloud, as well as
work with teams to migrate and upgrade databases successfully
Comply with current Software Development Life Cycle process and
transitioning to Agile /Scaled Agile Framework methodologies where
applicable
Work with Database Administrators to identify poor performance and
develop alternatives to maintain performance and security of the
collective database and data warehouse ecosystem.
Assist in developing solutions for data quality issues discovered
in data warehouse and products.
Act as a technical resource to the data/application developers and
reviews their work to ensure consistency and integration with
existing warehouse structures.
Plan and coordinate database and data warehouse unit and system
tests monitor results and take corrective action. Coordinate
scripts and commands for data manipulation.
Participate with QA teams, coordinating the coding, testing, and
implementation of complex programs and scripts to build and
maintain data warehouse databases.
What You Will Need :
BS/BA degree . In lieu of degree 4 additional years of experience
is required
8-10 year prior experience working either as a Database
Administrator, Database Developer, Data Architect, or other data
management related role
3-5 years minimum experience working on job related software
platforms including Business Objects/Tableau/Power BI Products
Extensive technical expertise with Database and Data Warehouse best
practices, Microsoft SQL Server (Multiple versions) & other
platforms
Experience with ETL development and report writing
Experience with Tableau, Business Objects, Power BI
Ability to mentor and supervise other data design and management
team members
U.S. Citizen or Green card is required for the position. Candidate
must successfully pass a Federal Background Investigation.
What Would Be Nice To Have :
Insurance (commercial or government) data knowledge
Experience working with the USDA or other federal agencies desired,
but not required
The annual salary range for this position is
$130,200.00-$195,300.00. Compensation decisions depend on a wide
range of factors, including but not limited to skill sets,
experience and training, security clearances, licensure and
certifications, and other business and organizational needs.
What We Offer:
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
Parental Leave
401(k) Retirement Plan
Group Term Life and Travel Assistance
Voluntary Life and AD&D Insurance
Health Savings Account, Health Care & Dependent Care Flexible
Spending Accounts
Transit and Parking Commuter Benefits
Short-Term & Long-Term Disability
Tuition Reimbursement, Personal Development, Certifications &
Learning Opportunities
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Care.com annual membership
Employee Assistance Program
Supplemental Benefits via Corestream (Critical Care, Hospital
Indemnity, Accident Insurance, Legal Assistance and ID theft
protection, etc.)
Position may be eligible for a discretionary variable incentive
bonus
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.
Keywords: Guidehouse, Sacramento , Data Architect, Other , Sacramento, California
|
Click
here to apply!
|
