Sr. Data Modeler Consultant job in Richmond

Sr. Data Modeler Consultant

City, State: Richmond, VA

Position Overview

Are you searching for a way to make a difference in your community? Do you believe in social entrepreneurship? What if we told you there was a way to go to work and provide for yourself while also giving back to your community? At Impact Makers, a Virginia Business Magazine Best Place to Work, we do just that. Come join our team and be a part of amazing growth, people, and philanthropy.

As a values-based company, taking care of our employees is of the utmost importance to us and our employee benefits package reflects that. We offer employee healthcare benefit premiums 100% paid for, 401(k) with matching, generous vacation, competitive salary and flexibility. Seek Balance is one of our values and Impact Makers embraces the pursuit of balance between work, family, and personal interests. Have Fun & Foster Collaboration are also values we hold dear, and we believe that work can be fun and we aim for our team members to feel like they work with Impact Makers and not for Impact Makers.

We are looking for a Sr. Data Modeler consultant who aligns business goals, objectives and requirements with decisions regarding data management and analytics solutions, products and services to join our growing Data Services Practice. Act as a data lead; leverage versatile technical capabilities to drive the development, evolution, and implementation of data warehouses, vaults, marts and cubes. Work with clients to understand data sources, definitions and functions; design data models for warehousing, information delivery, analysis and reporting.

Responsibilities:

• Partner with clients to evaluate current and desired state data warehousing and business analytics capabilities in various industries. Assist with strategies, road maps, processes and products to drive the realization of business value from data lifecycle processes and technology investment.
• Lead client engagements, gather requirements, document business needs and devise conceptual, logical and physical data models for data warehouses, vaults, cubes, marts, lakes etc. Leverage the Data Vault 2.0 methodology for data warehouse design and implementation.
• Provide subject matter expertise in various data management, warehouse, business intelligence and Big Data solutions across multiple industries.
• Assist in the development of project estimates, plans and timetables.

Skills & Qualifications

• Minimum 5 years of data management consulting experience. Possess a client-focused attitude through conversation and documentation.
• 5+ years of experience designing, building and scaling transactional and analytical database and business intelligence solutions.
• 5+ years of experience implementing various solutions within enterprise class database management systems (i.e. Oracle, DB2, Teradata, Microsoft).
• 2+ years of experience implementing Data Vaults using the Data Vault 2.0 methodology.
• Proven knowledge and experience with various data warehousing models such as third normal form, Data Vault 1.02.0, dimensional modeling, star schema, snowflake schema etc.
• Proven knowledge and experience understanding and modeling large enterprise data sources such as enterprise resource planning (ERP), customer relationship management (CRM), financial management, pricing, general ledgers, human resource management (HRM) etc.
• Experience with analytics tools and languages such as Tableau, SSRS, SSAS, Power BI, Cognos, SAS, SQL, R and Python.
• Experience with master data management, data governance, data security and data quality frameworks, processes and tools.
• Exposure to designing and architecting Cloud solutions for data and analytical workloads such as warehouses, Big Data, data lakes, real-time streaming and advanced analytics preferred.
• Knowledge and experience working with secured and sensitive data and systems such as PII, HIPAA and CJIS.
• A broad, enterprise-wide view of the business needs and varying degrees of appreciation for data strategy, processes and capabilities and enabling data technologies.
• Demonstrated analytical, problem solving, process improvement and documentation skills. Familiar with structured analysis techniques including context diagrams, data flow diagrams, process modeling, functional decomposition models as well as conceptual, logical and physical data modeling.
• Desire and commitment to continuous learning in data management, architecture, analytics, business intelligence and Cloud.
• Strong communication skills suitable for customer communications by phone, email, and in-person.
• Certifications a plus: Certified Data Vault Professional 2.0; Certified Business Intelligence Professional (CBIP); Certified Data Management Professional (CDPM); Certified Enterprise Data Management Expert; Certified Data Steward; Information Governance Professional; and other certifications provided through various cloud and data-related products such as Oracle, Teradata, AWS, Azure etc.

Keyword Skills: Data Vault 2.0, Data Vault 1.0, data vault, data architecture, enterprise architecture, data delivery architecture, database system, ETL, data warehousing, data security, data modeling, data flows, Cloud, Amazon Web Services, Microsoft Azure, Oracle, DB2, Teradata, SQL Server

About Us

At Impact Makers (!m), we are redefining business. Our passion is doing the right thing to create meaningful change for our clients and our community. We drive change through our teams of exceptional people, motivated by our mission and guided by our values. Achieving success is a different experience with us, by design.

Impact Makers is a unique management and technology consulting firm that contributes 100% of net profits to charities over the life of the company. The company provides services in Management and Technology Consulting, Program and Project Management, Experience Design, Data Management, Governance, Risk and Compliance, and Healthcare and Financial Solutions.
Impact Makers has made the Inc. 5000 List of Fastest Growing Private Companies in America for five consecutive years. The company was named ‘Best for the World’ and ‘Best for Community’ by scoring in the top 10% of B Corporations for the past four years. Consultingmagazine recognized !m as one of their 2017 Seven Small Jewels and the fifth Fastest Growing Firm in 2016. The Initiative for a Competitive Inner City (ICIC) and Fortune magazine recognized Impact Makers for their 2016 and 2015 Inner City 100 awards. Finally, the Richmond Times-Dispatch named Impact Makers to their Top Workplaces lists for the past four years.

 Impact Makers provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Impact Makers complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.