1

Bi Data Warehouse Jobs in Tennessee (NOW HIRING)

Solutions Architect

Oak Ridge, TN

$60.25 - $79.25/hr

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

Sr. BI Analyst

Franklin, TN · On-site

$35 - $40/hr

Aftersales Sr. Business Intelligence Analyst - ADAM BI Data Delivery Team 12 Month Contract to Hire ... Strategic data warehouse knowledge & capabilities * Familiarization of scripts using SQL to ...

Solutions Architect

Oak Ridge, TN · On-site

$54.75 - $72/hr

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

Solutions Architect

Oak Ridge, TN · On-site

$54.75 - $72/hr

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

... data warehouse solutions, and curated datasets that support business operations, reporting ... Product Owners, BI teams, Developers, Architects, and business stakeholders Prepare data for ...

New

next page

Showing results 1-20

Bi Data Warehouse information

What is the difference between Bi Data Warehouse vs Data Analyst?

AspectBi Data WarehouseData Analyst
Required CredentialsBachelor's in Computer Science, Data Management, or related field; certifications like Microsoft Certified Data AnalystBachelor's in Statistics, Mathematics, or related field; certifications like Microsoft Certified Data Analyst or Tableau Desktop Specialist
Work EnvironmentData warehouses are used in enterprise IT settings, often involving database management teamsBusiness environments, analyzing data to generate reports and insights
Employer & Industry UsageUsed by organizations managing large-scale data storage and integrationUsed across industries for data interpretation and decision-making

Bi Data Warehouse professionals focus on designing and maintaining data storage systems, while Data Analysts interpret data to support business decisions. Both roles require strong technical skills, but their primary functions differ in data management versus data analysis.

What is a BI data warehouse?

A BI data warehouse is a centralized repository that stores large volumes of integrated data from multiple sources to support business intelligence and analytics. BI professionals use tools like SQL, ETL processes, and reporting software to analyze data and generate insights for decision-making.

What job categories do people searching Bi Data Warehouse jobs in Tennessee look for?

The top searched job categories for Bi Data Warehouse jobs in Tennessee are:

What cities in Tennessee are hiring for Bi Data Warehouse jobs?

Cities in Tennessee with the most Bi Data Warehouse job openings:

Senior Business Intelligence and Data Engineer

Maryville, TN • On-site

Full-time

Re-posted 27 days ago


Job description

Senior Business Intelligence & Data Engineer
In-Office/Non-Remote in Maryville, TN
We are looking for a Modern BI / Data Warehouse Developer who can bridge traditional BI engineering (T-SQL, ETL, SSIS-nice to have) with modern cloud analytics patterns, including building scalable data pipelines into Microsoft Fabric and creating transformations using notebooks (Python/Pandas) and related tooling.
This role focuses on data ingestion, modeling, transformations, and semantic layer readiness. While the role will not be responsible for building production reports, the ideal candidate understands reporting needs well enough to design data models and semantic models that support analytics and self-service BI.
COMPETENCIES AND SKILLS:
  • Strong hands-on experience with T-SQL and relational data modeling.
  • Proven experience building ETL/ELT pipelines and supporting production data workflows.
  • Experience with Azure Data Factory (ADF) or comparable orchestration tools.
  • Experience building transformations using notebooks, including Python and Pandas (and/or Spark-based transformations as needed).
  • Strong understanding of:
  • modern data warehousing
  • dimensional modeling (facts/dimensions, SCDs, conformed dimensions)
  • performance fundamentals (indexes, partitioning concepts, query tuning as applicable)
  • Working knowledge of reporting concepts (requirements, visual performance considerations, data shaping), even if not building reports.
  • Nice to have skills:
  • TensorFlow, PyTorch, Hugging Face
  • SSIS experience (nice-to-have, not required).
  • Experience with Microsoft Fabric components (Lakehouse, Warehouse, pipelines, notebooks, shortcuts, etc.).
  • Familiarity with semantic modeling platforms and patterns (e.g., Power BI semantic models/tabular concepts).
  • Exposure to data governance, cataloging, and lineage practices.
  • Experience with CI/CD for data assets (Git integration, environment promotion).

ESSENTIAL DUTIES AND RESPONSIBILITIES:
  • Design and implement data ingestion pipelines to move data from source systems (SQL, files, APIs, SaaS apps) into Microsoft Fabric (e.g., Lakehouse/Warehouse).
  • Create and maintain pipelines using Azure Data Factory (ADF) and/or Fabric-native orchestration patterns as appropriate.
  • Build transformation logic using notebooks and modern approaches (Python, Pandas, Spark where applicable).
  • Apply best practices for:
    • data quality checks & validations
    • reproducibility (parameterization, modular notebooks, version control)
    • performance optimization (partitioning, pushdown, caching strategies where relevant)
  • Design and maintain enterprise data warehouse models
  • Understand how to prepare data for semantic models and analytics consumption:
  • Collaborate with report developers/analysts by ensuring data models align with real BI usage patterns.
  • Work closely with stakeholders (analysts, app teams, data owners) to translate requirements into scalable pipelines and models.
  • Participate in code reviews, documentation, and operational handoffs.
  • Help establish standards for naming, versioning, environments, and deployment patterns.

QUALIFICATIONS:
  • 3+ years of professional experience in BI, data engineering, or data warehouse development in an enterprise environment.
  • 2+ years of hands-on experience with T-SQL, including:
    • complex joins, window functions, CTEs
    • query optimization and performance tuning
    • building and maintaining transformation logic in SQL
  • 2+ years of experience designing and implementing ETL/ELT pipelines.
  • 1+ years of experience building data pipelines using Azure Data Factory (ADF) or a comparable orchestration tool.
  • 3+ years of experience with modern data warehousing principles, including:
    • layered architectures (raw, curated, consumption)
    • ELT patterns batch and incremental loading strategies
  • 3+ years of hands-on dimensional data modeling experience, including:
    • star and snowflake schemas
    • fact and dimension table design
    • surrogate keys and SCD (Type 1/2) patterns
  • 1+ years of experience developing data transformations using notebooks.
  • Working knowledge of reporting and analytics tools concepts (e.g., how analysts and business users consume data), even if not responsible for building reports directly.
  • Professional communications skills, both verbal and written. Good team player.
  • Manage personal workload and work under tight timeframes.
  • Must be able to work independently with minimal supervision.
  • Bachelor's degree in Computer Science, Engineering, or a related field preferred.

PHYSICAL DEMANDS:
  • Occasional: bending, kneeling, squatting, standing, walking, reaching, overhead reaching, and fine motor skills

WORK ENVIRONMENT:
  • Normal office environment and office lighting
  • Within the Smith & Wesson manufacturing facility employees may be exposed to manufacturing noise, airborne liquid chemicals, fine particulate dust, ambient temperatures, and industrial lighting
  • All employees are required to apply ergonomic correctness to all job tasks

RECRUITING FRAUD ALERT
At Smith & Wesson, your personal information and online safety are our top priorities. Our recruiters will only direct candidates to apply through our official career page www.smith-wesson.com/careers. We will never request payments, financial account details, or sensitive information such as Social Security numbers. If you're unsure about the legitimacy of a message, please contact HRRecruiting@smith-wesson.com for verification.
Updated 8/18/2026