Data Warehouse Architect

Job Description

Come build, innovate, disrupt, and thrive!

KSTA I.T is actively seeking an Data Warehouse Architect foran immediatecontractengagement with ourgovernmentclient.

Work Location: This position is Hybrid

Job Description:

We Are Seeking a Data Warehouse Architect to support critical reporting and data analysis needs for Child Welfare systems. This position is focused on the development and maintenance of federal reporting, ad-hoc reports, ETL processes, and Business Objects reports that support key child welfare initiatives. The role requires close collaboration with various technical teams to ensure the operational system's database structure aligns with the organizations data warehousing and analytics needs.

Responsibilities:

Collaborate with development teams to ensure the operational system database supports the data warehouse's extraction and reporting requirements.

Design and implement a robust data warehouse model to fulfill analytic and reporting needs.

Continuously refine the data warehouse in response to changes in operational systems.

Provide application development support for business intelligence applications and integrate data warehouse resources with other enterprise applications.

Develop reporting and visualization solutions including dashboards and analytic reports.

Design and manage ETL processes to cleanse and consolidate data from multiple sources into the data warehouse.

Collaborate with federal reporting teams and end users to optimize and improve database queries.

Translate end-user data requirements into actionable reporting solutions.

Conduct training sessions and provide one-on-one support to internal developers and query writers.

Deliver technical support to assist with federal data reporting and ad-hoc queries.

Support the enterprise environment including Teradata Cloud and Business Objects platforms.

Required Skills:

Expertise in data warehouse architecture, modeling, and ETL development.

Strong knowledge of federal Child Welfare reporting standards (e.g., NYTD, AFCARS, NCANDS).

Proficiency in Teradata Cloud version 17.20 or similar enterprise data warehouse platforms.

Experience with SAP Business Objects XI 4.2 or comparable BI tools.

Strong analytical, problem-solving, and communication skills.

Ability to translate user requirements into actionable technical solutions.

Experience working with operational data systems and developing reporting solutions based on complex business logic.

Available Benefits:

Medical Benefits (Platinum level plans available)

Work from home / Hybrid / Onsite options

PTO

Holiday Pay

VTO

401K

Charitable Match

Training reimbursement

About KSTA I.T.:

Our name says it all; KSTA I.T. (Keys-to-I.T.) AND ourpeople are our keys to our success!

KSTA I.T. is a premier Utah-based technical staffing and consulting services firm. We specialize in temporary and permanent placement of Software, Hardware, Network, Cloud, CRM/ERP, Data, End-User support, Web and Executive / leadership-based positions on a full time and consulting basis.

If you're interested in a role where top performance is rewarded, personal time is valued, and excellence is demanded at every level we want to talk to you today!

Where do you want to go? We've got the keys! ~ KSTA I.T.

Full-time

Hybrid remote