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 Development Cloud Analytics Platforms Agile / Scrum Methodologies Enterprise Analytics & Reporting