Data Architect / Data Modeling Consultant

Intratek Computer INC; Town of Texas (WI); On-site; USD 55,000 - 96,000; Part time

Benefits offered by this job

Medical benefits

Paid vacation

Paid holidays

Job summary

Intratek Computer, Inc. is seeking an experienced BI Analyst to support enterprise-wide data modeling and analytics initiatives. This role focuses on designing scalable data warehouses, data lakes, and data marts, aligned with BI strategies using Tableau, Power BI, and Dataiku.

You will collaborate with cross-functional teams to support analytics, reporting, and data governance in cloud and on-prem environments. Strong SQL/PL-SQL and agile methods are required.

Qualifications

• Strong understanding of enterprise Data Warehousing architectures and data modeling methodologies.
• Hands-on experience with Star Schemas, Snowflake Schemas, Slowly Changing Dimensions (SCD), Aggregation Techniques.
• Experience designing and maintaining enterprise data warehouses, data marts, and data lakes.
• Strong experience with business intelligence and analytics platforms including Tableau, Tableau Desktop, Tableau Cloud, Power BI, Dataiku.
• Experience delivering enterprise data analytics and warehousing solutions within cloud-based environments.
• Strong understanding of Agile/Scrum software development methodologies.
• Advanced SQL and PL/SQL development experience including Stored Procedures, Triggers, Oracle Functions, Partitioning.
• Experience creating logical and physical data models for enterprise analytics platforms.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design, develop, and maintain enterprise data models supporting data warehouses, data lakes, and data marts.
• Support enterprise-wide medallion architecture initiatives and large-scale analytics programs.
• Develop logical and physical data models aligned with enterprise business intelligence strategies.
• Analyze and evaluate enterprise data environments including metadata, repository structures, and database architecture.
• Create and maintain enterprise BI solutions utilizing tools such as Tableau, Power BI, and related analytics platforms.
• Develop and support ETL routines, SQL scripts, stored procedures, triggers, and database functions.
• Participate in architecture planning, business analysis, and enterprise analytics initiatives as a subject matter expert.
• Collaborate with Business Analysts, Database Administrators, System Administrators, and QA teams to support development and deployment efforts.
• Assist with requirements gathering, documentation, planning, budgeting, and monitoring processes for business systems applications.
• Analyze statistical and operational data to identify trends, patterns, and relationships among multiple data sources.
• Support enterprise analytics and reporting solutions utilizing Agile/Scrum development methodologies.
• Test, tune, and optimize enterprise data warehouse and analytics solutions for production environments.

Skills

Enterprise Data Warehousing

Data Modeling

Star Schemas

Snowflake Schemas

SCD

Aggregation Techniques

Agile/Scrum

Advanced SQL/PL-SQL

Oracle Functions

Partitioning

Tools

Tableau

Tableau Desktop

Tableau Cloud

Power BI

Dataiku

Oracle

Job description

Intratek Computer, Inc., an Irvine, California based company, was founded and incorporated in 1989 as a computer service, support, and networking firm to provide state-of-the-art customized information technology solutions for Federal, State and County agencies, as well as leading private commercial accounts. We have comprehensive experience providing IT support services, including hardware and software support, maintenance and repair, programming, professional staffing, networking, web design and development, and helpdesk implementation and management.

We are seeking a BI Analyst to help us in Dallas Fort Worth, TX.

• BI Analyst
• Onsite in Dallas Fort Worth, TX
• Monday – Friday, 8:00 AM – 5:00 PM
• 12+ months contract
• Pay rate depends on experience
• Start ASAP
• Medical benefits
• Paid vacation
• Paid holidays

Position Overview

Intratek Computer, Inc. is seeking an experienced BI Analyst to support enterprise-wide data modeling and analytics initiatives. This role will focus on designing and supporting scalable enterprise data warehouse and medallion architecture environments supporting large-scale Capital Expenditure projects and analytics programs.

The ideal candidate will have strong expertise in enterprise data architecture, data warehousing methodologies, cloud analytics environments, and business intelligence platforms. This individual will collaborate with cross-functional teams to develop scalable analytical infrastructures supporting enterprise reporting, analytics, and data governance initiatives.

Key Responsibilities

• Design, develop, and maintain enterprise data models supporting data warehouses, data lakes, and data marts.
• Support enterprise-wide medallion architecture initiatives and large-scale analytics programs.
• Develop logical and physical data models aligned with enterprise business intelligence strategies.
• Analyze and evaluate enterprise data environments including metadata, repository structures, and database architecture.
• Create and maintain enterprise BI solutions utilizing tools such as Tableau, Power BI, and related analytics platforms.
• Develop and support ETL routines, SQL scripts, stored procedures, triggers, and database functions.
• Participate in architecture planning, business analysis, and enterprise analytics initiatives as a subject matter expert.
• Collaborate with Business Analysts, Database Administrators, System Administrators, and QA teams to support development and deployment efforts.
• Assist with requirements gathering, documentation, planning, budgeting, and monitoring processes for business systems applications.
• Analyze statistical and operational data to identify trends, patterns, and relationships among multiple data sources.
• Support enterprise analytics and reporting solutions utilizing Agile/Scrum development methodologies.
• Test, tune, and optimize enterprise data warehouse and analytics solutions for production environments.

Required Qualifications

Strong understanding of enterprise Data Warehousing architectures and data modeling methodologies.

Hands‑on experience with:

• Star Schemas
• Snowflake Schemas
• Slowly Changing Dimensions (SCD)
• Aggregation Techniques

Experience designing and maintaining enterprise data warehouses, data marts, and data lakes.

Strong experience with business intelligence and analytics platforms including:

• Tableau
• Tableau Desktop
• Tableau Cloud
• Power BI
• Dataiku

Experience delivering enterprise data analytics and warehousing solutions within cloud-based environments.

Strong understanding of Agile/Scrum software development methodologies.

Advanced SQL and PL/SQL development experience including:

• Stored Procedures
• Triggers
• Oracle Functions
• Partitioning

Experience creating logical and physical data models for enterprise analytics platforms.

Strong analytical, problem‑solving, and communication skills.

Preferred Qualifications

Experience supporting large‑scale enterprise analytics or CapEx programs.

Experience with enterprise data governance and metadata management initiatives.

Experience supporting enterprise reporting and analytics environments in production settings.

Public sector or transportation industry experience is a plus.

Technical Environment

• Enterprise Data Warehousing
• Data Lakes / Data Marts
• Tableau / Power BI / Dataiku
• SQL / PL‑SQL / Oracle
• ETL DevelopmentCloud Analytics Platforms
• Agile / Scrum Methodologies
• Enterprise Analytics & Reporting

Veterans Preference

Special preference will be given returning war veterans when hiring new employees in an attempt to recognize their service, sacrifice, and skills

Equal Opportunity Employer

Intratek Computer Inc. is an equal opportunity employer. “All qualified applicants will receive consideration for employment without regard to their race, religion, ancestry, national origin, sex, sexual orientation, age, disability, marital status, domestic partner status, or medical condition.”