Senior BI Architect | Data Warehousing & Analytics

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