Data and BI Engineer

Job Details

Description

Key Responsibilities

Business Collaboration

Work closely with business and technical groups to analyze needs, make recommendations, and design solutions that are reliable, flexible, scalable, and cost‑
Drive new technology assessments and adoption to deliver business value.

Data Engineering & Integration

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.

Semantic Modeling with SSAS

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.

BI Delivery

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

Support, Performance & Reliability

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.

Security, Compliance & Risk 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.

Data Governance & Documentation

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.

Leadership, Mentoring & Cross‑Team Support

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.

Qualifications

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.

Similar jobs

No similar jobs found