Data Modeler and Analytics Specialist - Federal Advisory

Job Family:

Management Consulting

Travel Required:

Up to 10%

Clearance Required:

Ability to Obtain Public Trust

What You Will Do:

• Interpret, analyze, and iterate on existing client data documentation such as ERD’s, data flow diagrams, data dictionaries, metadata schemas, data transfer control documents, etc

• Autonomously generate clear, actionable data-centric documentation (see above) that enables self-guided implementation of new system and data asset enhancements

• Guide development of and contribute to critical stage gate documentation, designed to meet client standards for migrating data into a unified data lake

• Support data discovery exercises designed to isolate specific sets of data for migration and ETL jobs; complete essential documentation stemming from these exercises

• Facilitate the planning and migration of data into client’s new data lake, including the design and application of best practices around ETL’s, data quality standards, metadata requirements, etc

• Design, define requirements for, and test new data visualizations for the client’s public facing data portal

• Translate end user needs relating to exploration and analysis of collection level data sets into technical requirements for display data models, functional requirements for search, and impactful governance resources

• Navigate and perform essential functions in client’s enterprise data governance tool

• Prepare presentations that translate planning and delivery work into digestible client insights.  Design and present materials for both internal and client meetings

• Understand, support, and drive the planning and documentation of business requirements into clear hand-off documents for the implementation vendor

• Understand and support planning of data standards to ensure consistency and quality in client data sets

• Interface with client leadership and support meetings with stakeholders, defining their data-centric needs to drive towards future data governance solutions

• Work hand-in-hand with client IT resources to plan data centric solutions

• Act as an Education data subject matter expert, applying that expertise to data-centric activities such as analytics, data management, systems documentation analysis, data processing, and ETL operations

• Build out data lineages and data flows as a key governance resource

• Review and support the development of data definition documents key to the preparation, execution, and QA testing for data migration jobs

• Review the substance and format of Jira tickets and work with implementation vendor as necessary to ensure that key functionality gets implemented to client requirements and program objectives are met 

• Track implementation vendor Jira tickets throughout the agile delivery lifecycle, from conception to testing 

• Support administrative activities and perform segment engagement tasks for the team 

What You Will Need:

• Bachelor's degree is required

• Minimum THREE (3) years of experience synthesizing client needs into business requirements

• Develop MS Office resources including PowerPoints, Word documents, and Excel spreadsheets 

• Ability to work overtime required on occasion

• Excellent communication and collaboration skills within a cross functional team

• Ability to translate complex technical concepts for non-fluent audiences and support client learning

What Would Be Nice To Have:

• Exercise an educational background in data-centric fields such as analytics, data management, systems analysis, data processing and operations

• Experience with agile program/project management 

• Experience working directly with client stakeholders 

• Experience with Jira 

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

• 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

• Student Loan PayDown

• Tuition Reimbursement, Personal Development & Learning Opportunities

• Skills Development & Certifications

• Employee Referral Program

• Corporate Sponsored Events & Community Outreach

• Emergency Back-Up Childcare Program

• Mobility Stipend

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.