Data Architect

7 days ago

Richmond, United States McKesson Full time

The Data Architect will be responsible for providing guidance, maintenance, and deployment to customers in the structure, integration, monitoring, storage, and governance of data.


What Sets you Apart:

  • You will have experience with creating data pipelines and flows to and between business applications and data repositories.
  • You will have a technical and business understanding of approaches to industry leading deployments of Data Lakes, Data Warehouses, Data Marts, and the progression of data from raw/bronze to curated/gold environments with an interest in all tools/technologies including Python, Matillion, Snowflake, Databricks and Azure.
  • Approaches and expertise in high-transaction volume deployments is a requirement. It is beneficial to understand Data Modeling and tabular object model or semantic layer development as well as critical optimization of Microsoft Power BI.
  • You will also support the deployment of our business applications and migrations / integrations with Finance customers as well as the Enterprise market space.
  • You will contribute to the development of unique repeatable offerings as they relate to both horizontal and vertical industry customers.


The candidate must be self-directed and comfortable supporting the data needs of multiple customer types, teams, systems, and products. Excellent written and verbal skills are a requirement with total comfort presenting and defending assessments, designs, approaches, and technology choices. Being naturally curious and technology-focused is a key to success with a desire to explore, understand, and deploy AI/ML models.


As Data Architect you will:

  • Participate in design, development and implementation of architectural deliverables, including components of the assessment and optimization of system design and review of user requirements.
  • Provide technical knowledge and capabilities as a team member and individual contributor.
  • Maintain current and future state architecture.
  • Be responsible for designing, creating, deploying and managing how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as any applications using or processing that data in some way.
  • Assist in designing new architectures and re-designing existing architectures, including data structures and database code. Design and build relational databases.
  • Perform data access analysis design, and archive/recovery design and implementation, especially in a Microsoft SQL Server environment. Able to define, design, and build dimensional databases.
  • Design and implement all database objects including schemas, tables, clusters, indexes, views, sequences, packages and procedures based on system requirements.
  • Contribute to data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. Develop strategies for data acquisitions, archive recovery, and implementation of a database. Translate business needs into long-term architecture solutions.
  • Managing input of various data sources, definition of database architecture, development of database code, construction and maintenance of ETL based processes, design of database reporting, construction of data flow diagrams and creation of documentation manuals.
  • Creating code for database modification, constructing and accessing databases using stored procedures, triggers and functions; assist in developing ETL processes.
  • Participate in multiple projects with competing deadlines.
  • Influence and direct activities of a team related to special initiatives or operations.


Job Specifications

  • Proficiency in using multiple data engineering tools and technologies, like Python, Matillion, Databricks, SQL and cloud-based pipelines.
  • 4+ years of experience in the disciplines associated with data analytics including Finance and Accounting.
  • 4+ years of direct experience in Big Data, Data Warehousing, Data Analytics, and/or Information Management related projects, Snowflake preferred.
  • 2+ years of direct experience in cloud data solution architectures, design and development including ETL, data warehousing, data lakes, and big data.
  • 2+ years of experience using SQL including development of stored procedures, functions, triggers and views.
  • 2+ years of Matillion, Databricks, Python and Snowflake experience.
  • Experience in structuring solutions for high-scale data environments that support high transaction volume and scalable BI-driven data architecture.
  • Knowledge of Data Governance principles.
  • Complete comfort, understanding, and conversancy in articulating the ROI on corporate data initiatives.


Education

  • Bachelor’s degree in Computer Science, Computer Engineering, or Software Engineering.


Location

  • Applicants must be local to Richmond, VA area. Team meets on-site occasionally, no weekly requirements.

  • Data Analytics Architect

    1 month ago

    Richmond, United States TalentBurst, an Inc 5000 company Full time

    Title: Data Analytics Systems ArchitectLocation: Richmond, VA 23219 HybridDuration: 12 Month’sJob Description:We are seeking a highly skilled and experienced Data Analytics Systems Architect to join our team. The ideal candidate will have a strong background in data modeling, extensive experience with various databases and technologies, and a deep...

  • Data Analytics Architect

    1 month ago

    richmond, United States TalentBurst, an Inc 5000 company Full time

    Title: Data Analytics Systems ArchitectLocation: Richmond, VA 23219 HybridDuration: 12 Month’sJob Description:We are seeking a highly skilled and experienced Data Analytics Systems Architect to join our team. The ideal candidate will have a strong background in data modeling, extensive experience with various databases and technologies, and a deep...

  • Senior Data Architect

    1 month ago

    richmond, United States Insight Global Full time

    Required Skills & Experience•15+ years' experience in a data warehousing environment with hands-on experience in managing and optimizing large-scale data warehouses •Demonstrated proficiency in key technologies including IBM DataStage, Snowflake, and Data Factory. •Strong knowledge and understanding of Azure concepts, with experience in leveraging...

  • Senior Data Architect

    1 month ago

    Richmond, United States Insight Global Full time

    Required Skills & Experience•15+ years' experience in a data warehousing environment with hands-on experience in managing and optimizing large-scale data warehouses •Demonstrated proficiency in key technologies including IBM DataStage, Snowflake, and Data Factory. •Strong knowledge and understanding of Azure concepts, with experience in leveraging...

  • IT Security Architect IV

    1 week ago

    Richmond, United States SunPlus Data Group, Inc Full time

    Job DescriptionJob DescriptionWe are looking for an IT Security Architect IV to work for the State of Virginia in Richmond, VA.This is expected to be for 12+ monthsHour are M-F 40 hrs week day shiftPay is $70 W2 hourly or $78 per hour 1099Job# 751727**This position is 4 days per week onsite and 1 day remote to start.  Some flexibility may be allowed once...

  • Senior Data Architect

    4 weeks ago

    Richmond, United States Genworth Full time

    At Genworth, we empower families to navigate the aging journey with confidence. We are compassionate, experienced allies for those navigating care with guidance, products, and services that meet families where they are. Further, we are the spouses, children, siblings, friends, and neighbors of those that need care—and we bring those experiences with us to...

  • Enterprise Network Architect

    2 weeks ago

    Richmond, United States SunPlus Data Group, Inc Full time

    Job DescriptionJob DescriptionSunPlus Data Group is looking for an Enterprise Network Architect 4 for the State of VA in Richmond, VA. Candidates ae required to already be local to Richmond, not relocateThis is for 12 months with extensionHours are generally M-F, 40 hrs/weekPay is $100 W2 hourly & $ 110 hr 1099 on contractJob # 745173**This position is...

  • Data Warehouse Architect

    1 month ago

    richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...

  • Data Warehouse Architect

    1 month ago

    Richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...

  • Data Warehouse Architect

    1 month ago

    richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...

  • Data Analytics Systems Architect

    3 weeks ago

    Richmond, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analytics Systems Architect . This is a 12+ Months Contract opportunity with long-term potential and is located in Richmond VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-46409Pay Range: $80 - $90/hour. Employee benefits include, but are not limited to, health...

  • Data Analytics Systems Architect

    3 weeks ago

    richmond, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analytics Systems Architect . This is a 12+ Months Contract opportunity with long-term potential and is located in Richmond VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-46409Pay Range: $80 - $90/hour. Employee benefits include, but are not limited to, health...

  • Data Analytics Architect

    2 weeks ago

    Richmond, VA, United States TalentBurst, an Inc 5000 company Full time

    Title: Data Analytics Systems ArchitectLocation: Richmond, VA 23219 HybridDuration: 12 Month’sJob DescriptionWe are seeking a highly skilled and experienced Data Analytics Systems Architect to join our team. The ideal candidate will have a strong background in data modeling, extensive experience with various databases and technologies, and a deep...

  • Senior Data Architect

    5 days ago

    Richmond, Virginia, 23214, Richmond County, VA, United States Genworth Full time

    At Genworth, we empower families to navigate the aging journey with confidence. We are compassionate, experienced allies for those navigating care with guidance, products, and services that meet families where they are. Further, we are the spouses, children, siblings, friends, and neighbors of those that need care—and we bring those experiences with us to...

  • McKesson | Data Architect | richmond, va

    2 days ago

    richmond, United States McKesson Full time

    The Data Architect will be responsible for providing guidance, maintenance, and deployment to customers in the structure, integration, monitoring, storage, and governance of data.What Sets you Apart:You will have experience with creating data pipelines and flows to and between business applications and data repositories.You will have a technical and business...

  • McKesson | Data Architect | richmond, va

    1 week ago

    richmond, United States McKesson Full time

    The Data Architect will be responsible for providing guidance, maintenance, and deployment to customers in the structure, integration, monitoring, storage, and governance of data.What Sets you Apart:You will have experience with creating data pipelines and flows to and between business applications and data repositories.You will have a technical and business...

  • Lead Data Architect

    5 months ago

    Richmond, United States CapTech Full time

    Company Description CapTech is an award-winning consulting firm that collaborates with clients to achieve what's possible through the power of technology. At CapTech, we're passionate about the work we do and the results we achieve for our clients. From the outset, our founders shared a collective passion to create a consultancy centered on strong...

  • Senior Data Architect

    4 weeks ago

    Richmond, VA, United States Genworth Full time

    At Genworth, we empower families to navigate the aging journey with confidence. We are compassionate, experienced allies for those navigating care with guidance, products, and services that meet families where they are. Further, we are the spouses, children, siblings, friends, and neighbors of those that need care—and we bring those experiences with us to...

  • Data Specialist

    2 weeks ago

    richmond, United States Saxon Global Full time

    We're on the lookout for an experienced Data Analytics Systems Architect in Richmond, VA (Hybrid) to drive impactful data solutions within our organization. If you have a passion for data architecture, a strong technical background, and the ability to create innovative solutions, we'd love to hear from you!Key Responsibilities:Design and lead data analytics...

  • Data Specialist

    2 weeks ago

    Richmond, United States Saxon Global Full time

    We're on the lookout for an experienced Data Analytics Systems Architect in Richmond, VA (Hybrid) to drive impactful data solutions within our organization. If you have a passion for data architecture, a strong technical background, and the ability to create innovative solutions, we'd love to hear from you!Key Responsibilities:Design and lead data analytics...