Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Data Architect

Remote: 
Full Remote
Contract: 
Full time
Salary: 
90 - 130K yearly
Experience: 
Senior (5-10 years)
Work from: 
Maryland (USA), United States

Offer summary

Qualifications:

Master's degree in computer science or related field, 8 years of technology delivery experience, 7 years focused on database architecture and design, Expert level knowledge of T-SQL and data modeling, Experience with API/web service implementation.

Key responsabilities:

  • Manage sharing of infectious disease data
  • Improve data quality and public health responses
  • Define and implement long-term technology strategy
  • Oversee expansion of data architecture and performance
  • Create standards and best practices for ETL development
Barrow Wise Consulting, LLC logo
Barrow Wise Consulting, LLC https://www.barrowwise.com
11 - 50 Employees
About Barrow Wise Consulting, LLC
After gaining more than 20 years of expertise in IT consulting and building strong customer relationships across the private and government sectors, our Founder created Barrow Wise Consulting, LLC in 2012, with a commitment to learning from clients and delivering solutions that reduce costs, improve operational efficiencies, solve business challenges, and increase the value of IT investments. With transformative consulting and engineering solutions, Barrow Wise has helped secure the largest global cyber security program, transform the largest network, and strengthen the government’s most extensive payment system. Today, the Barrow Wise team is known throughout the industry for its innovative, collaborative, and high-performing culture, utilizing in-house labs and exceptional talent to create the unthinkable. The firm invests in industry-leading technology and ISO 9001:2015 Quality Management systems to deliver measurable professional services that make an impact. The Barrow Wise team brings extensive knowledge on artificial intelligence (AI)-backed technology solutions for reducing fraud, waste, and abuse. Utilizing cutting-edge research, Barrow Wise produces advanced customer solutions in the areas of cybersecurity, supply chain risk management, image processing, autonomous systems, and data analytics. Barrow Wise helps organizations establish and implement engineering best practices and real-time AI-powered solutions, benefit from the operational efficiencies and economies of scale, and ensure reliability, reusability, accountability, transparency, and interoperability. As consultants, researchers, developers, and engineers, the Barrow Wise team is dedicated to continuous improvement and to applying emerging technologies to support the global health, finance, government, aerospace, and security sectors.
See more Barrow Wise Consulting, LLC offers

Job description

Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.

Responsibilities

The Data Architect will support Barrow Wise's CPS project and perform the following duties:

  • Enable the management and sharing of infectious disease data between Chicago Public Schools and the Health Department
  • Improvement of data quality (business processes, governance, systems/applications, etc.)
  • Efficiency of public health response to disease outbreaks for Chicago Public School students
  • Define and implement the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms
  • Create standards, design patterns, and best practices for ETL development in an enterprise data warehouse environment
  • Oversee the expansion of existing data architecture and data query performance optimization.
  • Assist with identifying future state architecture (data fabric, active metadata, Data Lake, Data Lakehouse)
  • Perform current state data model assessments/target data models and gap analysis
  • Propose new database architecture and support data migration from an existing Legacy system to a new structure
  • Create source-to-target mapping documents to transform the source data into the target warehouse and test final transformations
  • Maintain and create extensions to ODS
  • Assist in designing the data warehouse and ensure that data is stored and maintained in consistent formats
  • Counsel Analysts and Subject Matter Experts on specific topics to accurately capture existing business rules/principles
  • Establish data modeling naming standards, abbreviations, guidelines, and best practices
  • Develop and maintain conceptual, physical, and logical data models
  • Drive best practice solutions for data in a collaborative environment
  • Provide insight and strategies for data architecture solutions
  • Coordinate with a Solutions Architect to find the best data solution and workflows to support projects
  • Lead architectural design and strategy discussions
  • Utilize various ETL tools, including MS SSIS and Ab Initio
  • Perform ETL transformations between data stored in MS SQL Server Management Studio, Azure SQL Database, Oracle databases, and ServiceNow
  • Utilize scripting languages, Bash, PowerShell, Google Script, C#, and Python
  • Perform AppWorx workload automation
  • Perform data profiling and data modeling of both dimensional and non-dimensional data in 3NF
  • Work remotely

An Ideal Candidate Has The Following

  • U.S. Citizenship
  • A Master's degree from an accredited college or university in computer science, data science, engineering, or related field, required 8 years of technology delivery experience with at least 7 years focus on database system architecture and design, including the following is required:
    • Experience producing high-quality Solution architecture and design documents
    • Experience leading projects involving data warehousing, data modeling, and data analysis
    • Hands-on experience in performance tuning techniques
    • Experience with API and web service implementation (REST, API, SOAP API)
    • Experience with Cloud data warehouse technologies (Azure Data Warehouse, Amazon Redshift, Snowflake)
    • Experience with business intelligence tools and technologies such as ETL, Power BI, and Tableau
    • Ability to socialize and communicate the technical architecture and design to business and developers
    • Expertise in BI and data warehousing principles, including data modeling, data quality
    • Extract/transform/load processes as they apply to data preparation for BI/ Analytic solutions
    • Expert level knowledge of T-SQL, Stored Procedures, Data Modeling, Views, and Functions
    • Ability to resolve performance issues
    • Ability to collaborate and excel in complex, cross-functional teams involving data scientists, business analysts, and stakeholders
    • Familiarity with the latest trends in data engineering and data management (APIs, data virtualization,
    • stream data integration, augmented data integration)
    • Familiarity with SQL Server database administration
    • Familiarity with modern ETL integration solutions (SSIS, Ab Initio, Datastage, Informatica, Azure Data
    • Factory)
    • Familiarity with K-12 Education is preferred

    Join the team at Barrow Wise Consulting, LLC, for a fulfilling and engaging experience! Our team is dedicated to providing innovative solutions to our clients in an ethical and diverse work environment. We offer competitive compensation packages, excellent benefits, and opportunities for growth and advancement. Barrow Wise is an equal opportunity, drug-free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT are welcome to apply.

    Our employees stand behind Barrow Wise's core values of integrity, quality, innovation, and diversity. We are confident that Barrow Wise's core values, business model, and team focus create positive career paths for our employees. Barrow Wise will continue to lead the industry in delivering new solutions to clients and persevere until the client is overjoyed.

    Salary: $90000 - $130000 per year

    Job Posted by ApplicantPro

    Required profile

    Experience

    Level of experience: Senior (5-10 years)
    Spoken language(s):
    English
    Check out the description to know which languages are mandatory.

    Hard Skills

    Data ModelingAPI DesignSQL (Programming Language)Data Warehouse SystemsData QualityBusiness Intelligence ToolsDatabase ArchitectureData ArchitecturePerformance TuningK-12 EducationProject Management

    Other Skills

    • Collaboration
    • Creativity
    • Problem Solving
    • Analytical Thinking
    • Verbal Communication Skills
    Are you interested?

    Data Architect Related jobs

    See more Data Architect jobs
    Sign in or sign up with Google or LinkedIn