• Enterprise Data Architect

    Posted Date 1 month ago(1 month ago)
    Requisition ID
    Position Type
    Temporary Full-Time
    Job Locations
    US-NV-Las Vegas
  • About Us

    PCM is one of the fastest-growing value added direct marketers of technology solutions for business, government and educational institutions as well as consumers. We’ve built an environment that is fast-paced, growing and continually changing with the needs of industry. Our rapid growth and expansion has created numerous career and advancement opportunities. 


    Providing IT solutions nationally since 1987, PCM, Inc. is an industry recognized, publicly traded, value-added direct marketer of technology products, services and solutions to businesses, government, education, and individual consumers. Fully accredited and authorized by major manufacturers including HP, Apple, Cisco, Microsoft, Dell, and 1500 others, PCM offers product and service solutions through field sales, call center, and eCommerce venues. With annual sales of $1.5B+ , 3000 employees and over 400,000 products available, PCM delights in serving small, medium and enterprise level businesses. 


    Our valued direct client is seeking an Enterprise Data Architect. This is a senior-level data structure developer, lead data infrastructure designer and is fully competent in a defined data delivery discipline or product. This position resolves semi-routine issues involving design, development and database redesign, and is typically assigned to design, retrofit or debug most aspects of a data-related product or major sub component. This person will be responsible for contributing development efforts to multiple systems that are under the core responsibility of the architecture team.


    • Lead the establishment and documentation of technology direction and standards for data platforms, involving all aspects of information access and retrieval, integration, middleware translators, utilities, tools, and languages for use by information technology groups. Communicate the benefits and advocate the use of enterprise wide data architecture and standard platforms, products and tools to senior management, business area staff and technical staff.
    • Analyze the current state innovation, product development and manufacturing operating model, including organizational constructs, business processes, systems, information and data
    • Analyze, design and implement new/improved operational capabilities in our master data architecture.
    • Defines and achieves the strategy roadmap for the enterprise; including data modeling, implementation and data management for our enterprise data warehouse and advanced data analytic systems.
    • Evangelize Data Governance and value of accurate master data and metadata.
    • Develops and implements strategies for data warehouse following industry best practice (Kimball), creating conceptual, logical and physical models.
    • Expert in data warehousing principles utilizing fact and dimension tables, star and snowflake schema data modeling and data normalization preferred.
    • Provide support to enterprise data infrastructure management and analysts throughout the project cycle to ensure development of efficient data systems utilizing established standards, procedures and methodologies (i.e. design reviews, architect reviews).
    • Drive the execution of data architecture using industry best practices. Specifically - Provide technical and architectural guidance to teams across all platforms and infrastructures, including promoting adherence to design standards and methodologies.
    • Applies extensive knowledge of business drivers, technology strategy, architecture goals and infrastructure to develop and deliver clear, comprehensive data, technical and product architectures. Reviews and ensures major data designs are consistent, maintainable, flexible and cost effective.
    • Investigates and forecasts market trends to define the technical information strategy direction and recommends innovations that anticipate the future direction of the business, its drivers and technology strategy.
    • Recommend emerging technological solutions to increase market share and reduce operational costs.
    • Conduct systems architecture studies of new and existing data infrastructure; develop tactical plans to address short-term deficiencies in current data architecture.
    • Review project plans and technical documents to ensure consistency, accuracy and compliance with enterprise data architecture.
    • Define implementation plan for new technologies.
    • Mentor team members on new technology and database best practices.


    • Must be at least 21 years of age.
    • Bachelor’s Degree preferred in a related discipline, or equivalent in academic institution; significant applied experience or a combination of education and experience may be substituted.
    • 4+ years of professional data architecture development experience.
    • At least 8 years of hands-on database development using any SQL/query language/toolset in engineering solutions.
    • In-depth hands-on understanding of data design methodologies, data architecture principles, Data modeling and interrelation of various enterprise data or Business Intelligence-related solutions.
    • 3+ years using SQL tools: Server Management Studio and Business Intelligence Development Studio, or equivalent toolsets.
    • 3+ years experience using SSIS, or equivalent extraction/transformation tools
    • 4+ years experience developing and optimizing SQL procedures and DB structures.
    • Must have an understanding of principles of Extract Load and Transform (ETL) processes.
    • Must have Working knowledge of database physical and logical design.
    • Development skills with SQL Server databases/ TSQL in a high transaction volume environment.
    • Knowledge of SQL Server internals.
    • ITIL V3 Awareness Training preferred.
    • Proven ability to lead an mentor 1-2 junior engineers in design, development and deployment.
    • Must be able to obtain/maintain any necessary licenses and/or certifications.



    Why work for Us?

    Our Client Offers:

    If you want to work in a challenging, performance-based environment and be rewarded for your efforts, then our client is the place to build your career.


    Competitive base salary, 401K with a company match, medical/dental benefits and paid time off.   


    We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.


    Disclaimer: PCM extends offers of employment only to qualified candidates who have applied for a position using our official application through our career site, iCims.  Please be on alert for possible fraudulent offers of employment or "phishing" actions that may come from individuals or entities impersonating PCM.  PCM will not solicit money or banking information from applicants.  Once employment has been confirmed and as part of the onboarding process, new hires will receive instructions from PCM to set up their direct deposit information from our payroll department.


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

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.