Skip to content

Open nowPosted 355 days ago

Senior Business Intelligence and Data Engineer

Smith & Wesson Brands, Inc30 open roles

Where
Maryville, TN, USA
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior Business Intelligence and Data EngineerSmith & Wesson Brands, Inc · Maryville, TN, USA
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Smith & Wesson Brands, Inc's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.1% of postings close within 7 days. Measured by our own scanner across the market. Smith & Wesson Brands, Inc postings stay open a median of 1 days.

Share of postings closed within
  1. 2.1%1 day
  2. 4.5%3 days
  3. 12.1%7 days
  4. 19.1%14 days
  5. 35.6%30 days
  6. 52.7%60 days
This job: posted 355 days ago

Smith & Wesson Brands, Inc median: 1 days open

The 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 [email protected] for verification.

Updated 8/18/2026

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Smith & Wesson Brands, Inc's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Smith & Wesson Brands, Inc's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Smith & Wesson Brands, Inc's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.