Data Architect​/Data Modeling Consultant

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

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.

• 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.

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…