Apply Now

BI Solutions Architect (Level 5 / 6)

Remote • Posted 22 hours ago • Updated 22 hours ago

Contract W2

Contract Corp To Corp

12 Months

No Travel Required

Remote

$138 - $161/hr

Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

Summary

DivIHN (pronounced “divine”) is a CMMI ML3-certified Technology and Talent solutions firm. Driven by a unique Purpose, Culture, and Value Delivery Model, we enable meaningful connections between talented professionals and forward-thinking organizations. Since our formation in 2002, organizations across commercial and public sectors have been trusting us to help build their teams with exceptional temporary and permanent talent.

Visit us at to learn more and view our open positions.

Please apply or call one of us to learn more

For further inquiries about this opportunity, please contact our Talent Specialist, Amit at .

Title: BI Solutions Architect (Level 5/ 6)
Duration: 12 Months (with possible extensions upto 12 Months)
Location: Remote (Rare visits to the office in Oak Ridge, TN, 37831 required - all expenses paid)

Only W2 candidates are eligible for this position. Third-party or C2C candidates will not be considered.

Summary/Key Areas:

Looking for a senior, hands-on Data/BI Solutions Architect who can work with executives but also personally architect and build the solution. Must have 10-15+ years of Relevant Experience.
The ideal candidate needs strong experience with data/solution architecture, data warehousing and dimensional modeling, ETL/ELT, Power BI/Tableau, SQL, Python, data pipelines, executive dashboards/KPIs, row-level security, and stakeholder requirements gathering. Dynatrace or similar observability experience is a plus.
Think: Source Systems → ETL/ELT → Data Warehouse → Data Models → Power BI/Tableau → Executive Dashboards
They do not want a "PowerPoint architect." They want someone who can define the strategy with executives and then get hands-on with the architecture, SQL/Python, pipelines, and dashboards.

Knowledge, Skillset, and Abilities (KSAs) –

Enterprise Architecture & Business Acumen: Ability to translate high-level business goals and complex system metrics into actionable, executive-ready KPIs and visual strategies.
Data Modeling & Pipeline Orchestration: Advanced knowledge of modeling data (e.g., star schemas, dimensional modeling) tailored specifically for Extract, Load, Transform (ELT) frameworks within modern data warehouses.
BI & Data Visualization Expertise: Expert-level mastery of visualization tools (Power BI, Tableau, or equivalent) with deep knowledge of dashboard UX/UI best practices, row-level security (RLS), and performance tuning for large datasets.
Hands-on Scripting & Coding Capabilities: Proficiency in SQL and scripting languages (such as Python) to develop, debug, and optimize data transformation logic within the ELT layer.
Requirements Gathering & Facilitation: Proven ability to lead cross-functional discovery sessions, facilitate discussions with engineering, IT, and executive stakeholders, and reconcile technical limitations with business desires.

Specific Requirements –

Stakeholder Consultation & Discovery: Facilitate workshops with system engineers, database administrators, and business stakeholders to identify key system metrics, pain points, data sources, and desired dashboard business outcomes.
Architecture & Design: Design the end-to-end data flow architecture—from the source system metrics, through the ETL pipeline, to the data warehouse, and finally to the visualization layer (Power BI/Tableau and Enterprise level tools like Dynatrace, etc..).
ETL Development & Scripting: Perform hands-on scripting, database engineering, and SQL optimization to clean, aggregate, and structure system metrics into highly performance-optimized schemas.
Dashboard Development: Build, publish, and maintain interactive dashboards that track system health, operational performance, and enterprise-aligned metrics.
Security & Access Control: Implement proper data access controls, authentication standards, and row-level security profiles to ensure that metrics are visible only to authorized personnel.
Tool Selection Support: Lead the evaluation, trade-off analysis, and recommendation of the optimal Business Intelligence tools (e.g., comparing Power BI vs. Tableau vs tools like Dynatrace for the specific organization environment).

Specific Deliverables –

Deliverable 1: Business Requirements & Metrics Mapping Document (BRD): A comprehensive document detailing the business goals, stakeholder feedback, defined Key Performance Indicators (KPIs), mapped system metrics, and logical data definitions.
Deliverable 2: End-to-End System Integration & Data Flow Architecture: A technical blueprint illustrating the data journey from source systems, through the ELT staging and transformation zones, to the final visualization analytical models.
Deliverable 3: Data Pipeline/ELT Scripts & Repository: Well-documented, production-grade scripts (SQL, Python, or ETL/ELT tool pipelines) deployed to the project's code repository to orchestrate daily or real-time metric transformations.
Deliverable 4: BI Dashboard Mockups & Wireframes: Architectural UI/UX mockups of the proposed dashboards capturing user interactions, filter schemes, and layout prior to final development.
Deliverable 5: Production-Ready Dashboard Solutions: Interactive BI dashboards published to the designated enterprise environment, successfully connected to the automated ETL backend.
Deliverable 6: System Hand-off, Documentation, & Training Plan: Operational runbooks outlining the data pipeline maintenance, schema details, dashboard metric logic, and a brief walkthrough session/recording for internal administrators.

About us:

DivIHN, the ''IT Asset Performance Services'' organization, provides Professional Consulting, Custom Projects, and Professional Resource Augmentation services to clients in the Mid-West and beyond. The strategic characteristics of the organization are Standardization, Specialization, and Collaboration.

DivIHN is an equal opportunity employer. DivIHN does not and shall not discriminate against any employee or qualified applicant on the basis of race, color, religion (creed), gender, gender expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10109463
Position Id: 11664-3720-1786662756
Posted 22 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

IT Solutions Architect

Remote or Englewood, Colorado

•

Today

Where You'll Work Inspired by faith. Driven by innovation. Powered by humankindness. CommonSpirit Health is building a healthier future for all through its integrated health services. As one of the nation's largest nonprofit Catholic healthcare organizations, CommonSpirit Health delivers more than 20 million patient encounters annually through more than 2,300 clinics, care sites and 137 hospital-based locations, in addition to its home-based services and virtual care offerings. CommonSpirit has

Full-time

Principal Data Architect (Onpl W2)

Remote

•

Today

Visa: Data Modeling Data Design AI Forward Thinking Excellent Comm skills Data Architecture for Transaction Architecture for Consumption Data platforms: No specific need - but candidates should have command over relational databases, No-SQL databases, graph databases, data lakes and lakehouse implementations. Job Description ThePrincipal Architect, Data architecture and Solution Engineering, will be responsible for developing and executing the data strategy at the business unit level that power

Easy Apply

Contract

Technical Architect - Enterprise Data

Remote or Dallas, Texas

•

Today

Company Description Arista Networks is an industry leader in data-driven, client-to-cloud networking for large data center, campus and routing environments. What sets us apart is our relentless pursuit of innovation. We leverage the latest advancements in cloud computing, artificial intelligence, and software-defined networking to provide our clients with a competitive edge in an increasingly interconnected world. Our solutions are designed to not only meet the current demands of the digital la

Full-time

Data Architect

Remote

•

Today

Role Summary We are seeking an experienced Data Architect to define and evolve enterprise data architecture and design scalable, secure, high-performing data solutions aligned with business strategy. The role will shape target-state architecture, platform capabilities, data patterns, and modernization roadmaps across ingestion, storage, transformation, governance, analytics, and AI consumption. The ideal candidate combines deep architecture expertise with strong understanding of Finance, Sales,

Easy Apply

Third Party, Contract

Depends on Experience

Search all similar jobs

Remote jobs at DivIHN Integration Inc.