Senior Data Architect

    • Full Time, Part Time, Accepts corp to corp applications, Contract: Independent, W2

    Job Description

    Job Title: Senior Data Architect

    Job Location: Remote

    Job Duration: Long-Term Contract

    Interview: Virtual


    • Analyze business requirements and convert them into technical specifications, encompassing data streams, integrations, transformations, databases, data lakes, data warehouses, and data products.
    • Develop the framework, standards, and principles for the data architecture, including modeling, metadata, reference data, master data, and security within the PA LDS environment.
    • Establish a reference architecture as a guide for creating and enhancing data systems.
    • Define end-to-end data process flows, covering data origins, organizational data flow and functions, data management, and data transition.
    • Implement procedures to ensure data accuracy, quality, timeliness, availability, and accessibility.
    • Create and implement data management processes and procedures.
    • Collaborate with internal teams to formulate and execute data strategies, build models, and understand stakeholder needs and objectives.
    • Design and develop application programming interfaces (APIs) for data retrieval.
    • Deploy complex data environments that meet functional and non-functional requirements of various business areas.
    • Identify, design, and implement process improvements, including automation, optimized data delivery, and scalable infrastructure redesign.
    • Design the infrastructure necessary for efficient extraction, transformation, and loading of data from diverse sources using SQL and 'big data' technologies.


    • Bachelor's Degree in Computer Science or related field of study, with a minimum of 10+ years of experience in data/database roles, including 5+ years as a Data Architect.
    • Strong expertise in cloud-based data services on AWS, such as ECT, Glue, EMR, RDS, and Redshift, with 2-3 years of practical experience.
    • Proficiency in real-time data streaming technologies like Storm, Spark-Streaming, Kafka, or similar.
    • Solid data management skills for efficient and cost-effective data collection, storage, and utilization.
    • Knowledge of system development life cycle, project management methodologies, and requirements, design, and testing techniques.
    • Familiarity with established and emerging data management and reporting technologies, including columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data.
    • Advanced SQL skills and experience working with relational databases, query authoring, and familiarity with diverse database systems.
    • Experience in building and optimizing 'big data' pipelines, architectures, and datasets.
    • Proficiency in root cause analysis to address specific business questions and identify areas for improvement.
    • Strong project management and organizational abilities.
    • Experience collaborating with cross-functional teams in a dynamic environment.
    • 5+ years of experience as a Data Architect, with a degree in Computer Science, Statistics, Informatics, Information Systems, or a related quantitative field.
    • Hands-on experience with big data tools such as Hadoop, Spark, Kafka, etc.
    • Knowledge of artificial intelligence and machine learning (AI/ML) for developing scalable systems to handle large datasets.
    • Proficiency in data modeling tools like ERWin or Visio for visualizing metadata and database schemas.
    • Familiarity with relational SQL and NoSQL databases, including Oracle, MS SQL Server, Postgres, Cassandra, etc.
    • Experience with data pipeline and workflow management tools like Azkaban, Luigi, Airflow, etc.
    • Exposure to data integration services solutions from vendors such as Informatica, MuleSoft, Talend, TIBCO, etc.
    • Familiarity with cloud-based data services, particularly AWS (EC2, Glue, EMR, RDS, Redshift, etc.).
    • Knowledge of stream-processing systems like Storm, Spark-Streaming, Kafka, etc.
    • Proficiency in object-oriented/object function scripting languages, such as Python, R, Java, C++, Scala, etc.