Air Wisconsin Airlines · 1 day ago
Data and BI Engineer
Appleton, WI
Full-time
Onsite
Senior Level
5+ years expAir Wisconsin Airlines is seeking a Data and BI Engineer to collaborate with business and technical groups to design data solutions that deliver business value. The role involves building ETL pipelines, creating data integration solutions, and ensuring data quality and governance.
AerospaceTravel
Responsibilities
Work closely with business and technical groups to analyze needs, make recommendations, and design solutions that are reliable, flexible, scalable, and cost‑effective
Drive new technology assessments and adoption to deliver business value
Design, build, and run ETL pipelines (SSIS/T‑SQL) to ingest, transform, and deliver data from enterprise systems
Design and deliver data integration solutions between internal applications and external partner platforms (REST APIs, SFTP and file exchanges, change data capture (CDC))
Engineer data marts and staging layers using dimensional modeling (star/snowflake, conformed dimensions) to feed semantic models
Drive data quality, including data quality rules, data cleansing, and exception handling
Use Azure DevOps for version control, pull‑request reviews, work‑item tracking, and CI/CD of database/SSIS/SSAS artifacts
Design, build, and maintain SSAS semantic models—Multidimensional cubes and Tabular models, MDX/DAX
Implement partitions, aggregations, and processing strategies (full/incremental) and caching to achieve consistent performance
Deliver Excel solutions over SSAS using PivotTables/PivotCharts and cube functions; manage connections/parameters and refresh governance
Publish, version, and distribute Excel templates in Microsoft 365/SharePoint
Deliver SSRS and Power BI solutions as needed
Own run health for pipelines and refreshes: monitoring, alerting, incident response, and post‑incident RCAs with corrective/preventive actions
Partner with Infrastructure/DBA to tune SQL Server (indexing, partitioning, Query Store), plan capacity, and execute backup/restore and DR
Performance optimization (scheduling, dependencies, concurrency) for on‑time data availability and predictable runtimes
Assist contract DBA in database administration including general maintenance, security management and auditing, upgrades, and patch management
Implement secure‑by‑design practices (least‑privilege access, secrets management, encryption) across pipelines, databases, and SSAS
Collaborate with Cybersecurity on remediation and follow incident‑response practices
Keep technical specs, data dictionaries, semantic definitions, refresh cadences, and owners current
Maintain comprehensive lineage and dependency mapping across pipelines, SSAS models, and downstream Excel/reporting assets
Standardize naming conventions, folder structures, and modeling patterns to drive consistency and reuse
Provide guidance to application development teams on database design and performance optimization of application databases
Provide project leadership through scoping, estimating, design reviews, and code reviews; mentor teammates in T‑SQL, SSIS, MDX/DAX, and operational best practices
Qualification
Required
Associate's or Bachelor's degree in Computer Science, Management Information Systems, Data Management, or related field; or equivalent experience
5+ years in data‑warehouse development, data integration, and/or BI delivery using Microsoft technology stack (SSIS, SSAS, SSRS)
Dimensional modeling (star/snowflake) and delivery of conformed data marts used across business domains
Hands‑on SQL Server and T‑SQL expertise
Multidimensional and tabular SSAS experience
Excel‑centric BI over SSAS
Proven data integration work with internal systems and external
Operational mindset: monitoring/alerting, troubleshooting, incident response, and performance tuning
Understanding of secure‑by‑design practices and data handling aligned to internal cybersecurity expectations
Experience documenting requirements into technical specifications and data contracts, with clear lineage and ownership
Practical planning skills: estimating, sequencing, and incremental delivery using agile methodology
Effective communication with both technical and non‑technical stakeholders; collaborative approach with Infrastructure/DBA teams
Preferred
Airline industry experience
Power BI and Microsoft Fabric
SQL Server administration
Formal training in data modeling (3NF and Star Schema)
Experience with predictive/advanced analytics
Understanding of network infrastructure, storage, and virtualization as they pertain to BI/data platforms
Scripting for ETL/automation in .NET (C#) and/or Python
Company
Air Wisconsin Airlines
Air Wisconsin Airlines performs flying services for united airlines.
201-500 employees
H1B Sponsorship
Air Wisconsin Airlines has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (8)
2023 (4)
2022 (6)
2021 (2)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Rob Binns
President & CEO
Liam Mackay
Chief Financial Officer
Recent News
Seattle TechFlash
2025-09-10
2025-09-09
Company data provided by crunchbase