Back to jobs

Senior Business Intelligence and Data Engineer

Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Working pattern needs review — work setting source
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.
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Design and implement ingestion pipelines from SQL, files, APIs and SaaS apps into Fabric

  • Build transformation logic in notebooks using Python, Pandas and Spark where needed

  • Create and maintain pipelines in Azure Data Factory and Fabric orchestration

  • Design and maintain enterprise data warehouse models

  • Prepare data models that align with real BI and semantic model usage

From the employer’s posting
Design and implement data ingestion pipelines to move data from source systems (SQL, files, APIs, SaaS apps) into Microsoft Fabric
Build transformation logic using notebooks and modern approaches (Python, Pandas, Spark where applicable).
Create and maintain pipelines using Azure Data Factory (ADF) and/or Fabric-native orchestration patterns as appropriate.
Design and maintain enterprise data warehouse models
Collaborate with report developers/analysts by ensuring data models align with real BI usage patterns.

What you’ll bring

All qualifications

Core experience

  • 3+ years of professional experience in BI, data engineering, or data warehouse development in an enterprise environment.
  • 2+ years of experience designing and implementing ETL/ELT pipelines.
  • 3+ years of hands-on dimensional data modeling experience, including:
  • 1+ years of experience developing data transformations using notebooks.
  • 2+ years of hands-on experience with T‑SQL, including:
  • 1+ years of experience building data pipelines using Azure Data Factory (ADF) or a comparable orchestration tool.

Preferred experience

  • Bachelor’s degree in Computer Science, Engineering, or a related field preferred.
Qualification wording
3+ years of professional experience in BI, data engineering, or data warehouse development in an enterprise environment.
2+ years of experience designing and implementing ETL/ELT pipelines.
3+ years of hands-on dimensional data modeling experience, including:
1+ years of experience developing data transformations using notebooks.
2+ years of hands-on experience with T‑SQL, including:
1+ years of experience building data pipelines using Azure Data Factory (ADF) or a comparable orchestration tool.
Bachelor’s degree in Computer Science, Engineering, or a related field preferred.
Education & alternatives
- Must be able to work independently with minimal supervision. - Bachelor’s degree in Computer Science, Engineering, or a related field preferred. PHYSICAL DEMANDS:
Apply at Smith & Wesson Brands

Posting record

Report an error

Open 5 monthsWe first saw this posting 158 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 16, 2026158 days ago
Recorded sightings
307
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 158

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

Smith & Wesson Brands is hiring

1 open job

  • No new data jobs since June
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Power BI
  • Spark
  • SSIS
  • Hugging Face
  • pandas
  • PyTorch
  • TensorFlow
Where the posting names them
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.
- 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:
- 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:
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.
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.
- 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.
- 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).
- 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).
- 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:
- 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.
- TensorFlow, PyTorch, Hugging Face - SSIS experience (nice-to-have, not required). - Experience with Microsoft Fabric components (Lakehouse, Warehouse, pipelines, notebooks, shortcuts, etc.).
- Nice to have skills: - TensorFlow, PyTorch, Hugging Face - SSIS experience (nice-to-have, not required).

Your next step

Complete your application on myjobs.adp.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

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 11/5/2026

About Smith & Wesson Brands

People
About 46 in 2026, up 2% from the year before.Annual report (SEC Form 10-K)
Company
Listed as SWBI.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Maryville, TN, USA

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

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.