Principal Architect (Data Architecture)

Endava; Northern (KY); Hybrid; USD 160,000 - 240,000; Full time

Benefits offered by this job

Healthcare benefits (Medical, Dental,视

401(k) with employer match

Flexible spending accounts

Job summary

Endava is seeking an experienced Data Architect to design and oversee data platforms that empower business intelligence and advanced analytics. You will collaborate with technical leads, developers, and client teams to deliver robust data solutions.

The role requires deep expertise in data modeling, warehousing, and complex SQL across cloud and on-prem environments. You will drive architectural discussions and present solutions to diverse audiences, ensuring client value and delivery excellence.

Qualifications

• Bachelor’s degree or equivalent experience.
• Strong experience designing data architectures for BI/Analytics.
• Experience with data modeling, mapping, and data pipelines.
• Proficiency with SQL and both relational/non-relational databases.

Responsibilities

• Meet with stakeholders to establish scope, goals, and requirements.
• Translate business requirements into technical specifications for data consumption.
• Recommend data platforms to meet needs and ensure scalability.
• Develop data mappings, diagrams, models, and data flows for devs and testers.
• Deploy and troubleshoot data pipelines across on-prem and cloud environments.

Skills

Data architecture

Data modeling

SQL

Data pipelines

Data warehousing

BI analytics

Communication skills

Stakeholder presentations

Education

Bachelor’s Degree or equivalent experience

Tools

TFS

Microsoft SQL Server

Power BI

Azure Data Factory

Azure SQL

AWS

Redshift

Job description

• Compensation: USD 160000 - USD 240000 - yearly

Company Description

Technology is our how. And people are our why. For over two decades, we have been harnessing technology to drive meaningful change.

By combining world-class engineering, industry expertise and a people-centric mindset, we consult and partner with leading brands from various industries to create dynamic platforms and intelligent digital experiences that drive innovation and transform businesses.

From prototype to real-world impact - be part of a global shift by doing work that matters.

Job Description

Our data team has expertise across engineering, analysis, architecture, modeling, machine learning, artificial intelligence, and data science. This discipline is responsible for transforming raw data into actionable insights, building robust data infrastructures, and enabling data-driven decision-making and innovation through advanced analytics and predictive modeling.

In this role, you will work closely with technical leads, fellow developers, our client solutions team, and client stakeholders. You will be part of agile/scrum ceremonies and will work as a contributor within these ceremonies.

Our data architects are strong consultants, who are just as comfortable talking through solutions with clients as they are at coding. As a Data Architect you must value collaboration and working cross functionally to make the greatest impact for our clients and fellow team members.

Responsibilities:

• Meet and coordinate with internal and external stakeholders to establish project scope, system goals, and requirements
• Help translate business requirements into technical specifications for data consumption and use
• Provide guidance on appropriate data platform(s) (repository, database, etc.) to meet requirements
• Develop, analyze, prioritize, and organize requirement specifications, data mapping, diagrams, data models and flowcharts for developers and testers to follow
• Help deploy and troubleshoot application data pipelines across various architectural environments that will vary by client from legacy to modern including application servers, queues, API gateways, databases, etc. or cloud-based equivalents

Qualifications

Qualifications

Typically has 5+ years of experience with varied technical experience in designing/developing data pipelines and data stores

• Demonstrated experience designing data architecture(s) for Business Intelligence/Analytical usage
• Understanding of data modeling and data mapping
• Experience with Data Warehouse and Data Mart
• Experience with TFS, Microsoft SQL Server, Microsoft SSIS, Power BI
• Extensive experience with SQL
• Extensive experience with relational and non-relational database technologies (Oracle, MS SQL Server, GraphQL, DynamoDB, MongoDB, PostgresSQL, Redis, ElastiCache, etc).
• Experience with a variety of data systems and performance tuning approaches
• Knowledge of a variety of architectural principles like hub and spoke, bus, event driven software architectures, etc.
• Working knowledge of Data Science technology stacks
• Working knowledge of BI data analytical products
• Excellent verbal and written communication skills
• Ability to present technical solutions to both technical and non-technical audiences.
• Strong ability to review existing codebases/processes and refactor for improvement vs starting over
• Professional presence
• Bachelor’s Degree or equivalent experience
• Desired Qualifications
• Consulting experience
• Working knowledge of Big data on cloud platforms (Azure Data Factory, Azure SQL, AWS, RDS Oracle, or RedShift)
• Python or Powershell scripting experience

Additional Information

Success Profile

The ideal candidate is:

• A strong communicator who can confidently engage clients and lead architectural discussions.
• Comfortable operating in ambiguous environments and helping shape solutions from early discovery through delivery.
• Equally effective in strategic advisory conversations and detailed technical architecture work.
• Passionate about modern data platforms, AI, and emerging technologies.
• Able to balance technical depth with business outcomes and client value.

Additional Employee Requirements

• Participation in both internal meetings and external meetings via video calls, as necessary.
• Ability to go into corporate or client offices to work onsite, as necessary.
• Prolonged periods of remaining stationary at a desk and working on a computer, as necessary.
• Ability to bend, kneel, crouch, and reach overhead, as necessary.
• Hand-eye coordination necessary to operate computers and various pieces of office equipment, as necessary.
• Vision abilities including close vision, toleration of fluorescent lighting, and adjusting focus, as necessary.
• For positions that require business travel and/or event attendance, ability to lift 25 lbs, as necessary.
• For positions that require business travel and/or event attendance, a valid driver’s license and acceptable driving record are required, as driving is an essential job function.

If requested, reasonable accommodations will be made to enable employees requiring accommodations to perform the essential functions of their jobs, absent undue hardship.

USA Benefits (Full time roles only, does not apply to contractor positions)

• Robust healthcare and benefits including Medical, Dental, vision, Disability coverage, and various other benefit options
• Flexible Spending Accounts (Medical, Transit, and Dependent Care)
• Employer Paid Life Insurance and AD&D Coverages
• Health Savings account paired with our low-cost High Deductible Medical Plan
• 401(k) Safe Harbor Retirement plan with employer match with immediately vest

At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know.