• Senior Data Modeler/ Data Architect-with Healthcare (Payer exp)

    Job Location(s) US-National | US-National
    Posted Date 7 minutes ago(1/24/2020 9:07 AM)
    Job ID
    # of Openings
    Technology Experts - Architect
  • Overview



    At Perficient you’ll deliver mission-critical technology and business solutions to Fortune 500 companies and some of the most recognized brands on the planet. And you’ll do it with cutting-edge technologies, thanks to our close partnerships with the world’s biggest vendors. Our network of offices across North America, as well as locations in India and China, will give you the opportunity to spread your wings, too.


    We’re proud to be publicly recognized as a “Top Workplace” year after year. This is due, in no small part, to our entrepreneurial attitude and collaborative spirit that sets us apart and keeps our colleagues impassioned, driven, and fulfilled.


    Perficient is on a mission to help the Healthcare industry take advantage of modern data and analytics architectures, tools, and patterns to improve the quality and affordability of care. This is an excellent opportunity for the right individual to assist Perficient and its customers to grow the capabilities necessary to improve care through better use of data and information, and in the process take their career to the next level.


    We are looking for an experienced Data Modeler with specific experience modeling Healthcare Payer data patterns.  


    Perficient currently has a career opportunity for a Senior Data Architect/Data Modeler with Healthcare Payer Experience.


    Job Overview

    We are looking for a senior data modeler to analyze Healthcare business and data requirements, and model data structures to enable the technical solution and implementation within a Healthcare Payer organization. This position will involve working as a senior member of an implementation team working on large, complex and industry leading projects.  Perficient is looking for enthusiastic leaders who enjoy solving tough industry and technical problems and building tools which enable Perficient’s customers to elevate the efficiency and effectiveness of Healthcare delivery within the United States. 


    Perficient’s data and analytics consultants provide technical solution design, as well as technical implementation guidance and leadership, and are laser focused on providing innovative solutions to solve our customers’ most challenging business and technical needs. As a senior member of the Perficient team, you will collaborate with some of the best talent in the industry to create and implement innovative high quality solutions. This role is considered part of the Business Unit Leadership team and may mentor junior architects and /or development team members.




    • Collaborate with Healthcare Provider business and data SMEs to profile source system data and perform logical mapping of source data into target data warehouse models, based on the existing business process and data/reporting requirements.
    • Create conceptual and logical data models, typically for the purpose of extending an existing 3NF or Conformed Dimensional Model, and to define and implement custom data marts.
    • Drive data analysis and modeling efforts (conceptual, logical and physical models), either as the lead modeler, sole modeler, or as member of a team of data modelers/architects, as appropriate given the specific project situation and team makeup.
    • Assist in the architecture, design and development of overall Data Warehouse and ETL architecture definition, vision, and supporting artifacts required to communicate the vision and design.
    • Establish, communicate and enforce best practices and standards
    • Mentor and provide oversight to less senior members of the team




    • Prior experience working as a data analyst and modeler in a data warehouse, data lake, or operational data store environment; 7+ years experience.
    • 5+ years recent experience working as a data analyst and modeler, including experience creating complex relational (3NF) models and dimensional models (Star, Snowflakes)
    • 4+ years of recent experience working with Healthcare Payer (preferred) or Provider data, specifically with healthcare claims, membership, enrollment and clinical data is preferred
    • Experience performing data discovery, analysis and profiling
    • Experience creating logical source-to-target mappings which can be used by data integration engineers to develop batch and services based data pipelines to populate an enterprise data warehouse, data lake, or otherwise
    • Very strong sql query language skills.
    • Business and technical requirements elicitation, analysis and elaboration a plus.
    • Excellent verbal and written communication skills.
    • Strong consulting and customer relationship skills
    • Consultants located in the greater San Francisco, CA  area with the ability to work on site in downtown San Francisco in a daily basis are preferred.
    • Create/Author/Edit architecture documents, design documents, data flow diagrams, and system Run Books, and drive reviews for these deliverables as well as development work products, jobs/pipelines and mappings.
    • Define and ensure compliance to best practices, including driving and participating in design and code review sessions and process.
    • Participate in QA strategy and planning and play a role in the defect triage and prioritization process.
    • As a leader, train and mentor PRFT and customer resources as necessary throughout project execution.
    • Play a technical SME/lead role for architectural assessment, strategy and roadmap projects.


    Significant Experience working with the following tools

    • Erwin or IBM InfoSphere Data Architect
    • Top tier data analysis and profiling tools (IBM Information Analyzer or equivalent)
    • Very strong sql query language skills
    • SQL interpreters: Toad, Embarcadero, or equivalent


    More about Perficient

    Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work. 


    Perficient is the leading digital transformation consulting firm serving Global 2000 and enterprise customers throughout North America. With unparalleled information technology, data & analytics, management consulting and creative capabilities, Perficient delivers vision, execution and value with outstanding data & analytics, digital experience, business optimization and industry solutions; Perficient’s Health Sciences industry practice is the largest industry focus area within Perficient.


    Our work enables clients to improve productivity and competitiveness; grow and strengthen relationships with customers, suppliers and partners; and reduce costs.  Perficient's professionals serve clients from a network of offices across North America and offshore locations in India and China. Traded on the Nasdaq Global Select Market, Perficient is a member of the Russell 2000 index and the S&P SmallCap 600 index.


    Perficient is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national, origin, disability status, protected veteran status, or any other characteristic protected by law.


    Disclaimer:  The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification.  Management retains the discretion to add or change the duties of the position at any time. 




    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed