Senior Data Modeler

Job Family *:
Data Engineering & Architecture Consulting
Travel Required *:
Up to 25%
Clearance Required *:
None
What You Will Do *:
- Facilitate design sessions with subject matter experts and business stakeholders to define data requirements and resolve requirements issues
- Elicit and transform business and/or user requirements to logical data requirements needed to create data models
- Perform reverse engineering of physical data models from databases and SQL scripts
- Create data models (e.g., subject area, conceptual, logical, physical, and ERD) to support OLAP architectures
- Create presentations using MS PowerPoint to communicate the data model to non-technical and non-data audiences
- Collaborate with data analysts, database administrators, and other project team members to define and maintain data models
- Define and apply industry best practices in defining data models
- Incorporate metadata into the data model and export for data consumers to better understand the data model
What You Will Need **:
Data Skills:*
- Strong understanding of the data lifecycle
- Strong working knowledge of SQL
- Proven expertise in creating data models (e.g., subject area, conceptual, logical, physical, and ERD) for OLAP architectures
- Proven experience in working with industry-leading data modeling tools such as ERwin
- Working knowledge of data management industry best practices such as DAMA DMBOK, CMMI DMM, EDM Council DCAM
Client Delivery Skills:
- Ability to build solid relationships and become a trusted advisor to clients
- Gain and maintain awareness of the client environment, culture, challenges, and areas for improvement
- Gain and maintain external environmental awareness of legislation, regulations, and policies that may impact the client
- Experience with agile delivery
Core Consulting Skills:
- Ability to support the development of quality client deliverables
- Demonstrate a depth of analysis and critical thinking
- Demonstrates ability to leverage and tailor various industry methodologies and frameworks to the needs of clients
- Track record of success in creating data models for OLAP architectures
- Team player with an energetic attitude
- Strong organizational skills and ability to work collaboratively in a team
- Demonstrates flexibility in prioritizing and completing tasks
- Strong written and oral communication skills
- Experience with project and program management best practices
What Would Be Nice To Have *:
- Experience in a top-tier commercial or public sector consulting firm
- Data Management certification from an industry recognized standards organization
- US Citizen or Green Card holder preferred
- 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.
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); Atlanta, Boston, Tampa, Houston, San Francisco, Denver, Boulder, Durham, Chicago, Washington DC as needed. Client meetings may be required in-person.
This is an exempt level role that may require more than 40 hours of work per week.
Selected Candidate must be able to work Eastern Standard Hours.
The annual salary range for this position is $77,500.00-$155,000.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
- 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.