Senior Data Architect

Overview

Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Senior Data Architect to play a key role within a high-impact technical services team.

 

At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including:

• Highly competitive pay rates
• Local support staff for responsive, personal service
• Comprehensive benefits package, including:
  • Medical insurance (with employer cost sharing)
  • Life insurance
  • A 401(K) plan with company match
  • Flexible spending through a cafeteria plan

Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks.

 

Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Responsibilities

The client requires the services of a Senior Data Architect will be responsible for designing, developing, and maintaining the data architecture that supports enterprise reporting, analytics, and business intelligence needs. This role ensures that data structures, reporting models, and integration patterns are scalable, reliable, and aligned with business requirements. The architect will collaborate closely with enterprise architects, business stakeholders, data engineers, report developers, and IT leadership to deliver high‑quality reporting solutions that drive informed decision‑making.

 

The ideal candidate brings strong analytical skills, experience working with legacy systems, and a solid understanding of modern data platforms, reporting tools, and integration patterns.

 

Responsibilities:

Design and maintain reporting data models, including fact and dimension structures, semantic layers, and reporting datasets. Define and document data architecture standards, best practices, and governance guidelines. Ensure data models support business KPIs, operational reporting, dashboards, and advanced analytics. Partner with enterprise architects and data engineering teams to design efficient ETL/ELT pipelines and data integration workflows. Translate business requirements into scalable reporting data structures and data flows.

 

Other responsibilities include partnering with cross‑functional teams (IT, business, data governance, reporting teams) to align on data strategy and architecture. Provide guidance and mentorship to report developers and analysts on data modeling and best practices.

 

Essential Job Duties

• Lead the design of scalable data solutions that support future growth and modernization initiatives.
• Collaborate with reporting teams to ensure consistent definitions, calculations, and metrics across the organization.
• Support the creation of reusable data assets for BI tools such as Power BI, or similar platforms.
• Work closely with business units and mainframe team to understand reporting needs, KPI definitions, and analytical goals.
• Ensure data accuracy, consistency, and integrity across reporting environments.
• Establish and enforce data governance standards, including naming conventions, metadata, and documentation.
• Support compliance with security, privacy, and regulatory requirements.
• Troubleshoot complex data issues and provide architectural direction for resolution.

**Location of job: Remote**

Qualifications

Minimum (Required):

Years

Skills/Experience

8+

Strong experience in data modeling (star schema, snowflake schema, semantic modeling).

8+

Ability to translate business requirements into technical data structures.

8+

Skill with Microsoft Office tools, particularly with Word, Excel, Power Point, Visio, and SharePoint

8+

Ability to interpret data models, data dictionaries, and technical documentation.

6+

Hands‑on experience with enterprise reporting platforms (e.g., Power BI, Tableau, SSRS).

6+

Familiarity with KPI design, business metrics, and analytical methodologies.

6+

Experience in working in fast-paced and ever-changing environments; achieving project’s deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to