Smith & Wesson Brands, Inc
Senior Business Intelligence and Data Engineer
- Compensation
- Not disclosed
- Location
- Maryville, Tennessee, United States
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 1+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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:
- 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:
- 3+ years of hands-on dimensional data modeling experience, including:
- 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.
Full description
Senior Business Intelligence & Data EngineerIn-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: