IT Business Intelligence Engineer, Sr.

Description

• Lead design and implementation of a modern data lakehouse using Microsoft Fabric and medallion architecture.
• Implement data processing frameworks to transform and cleanse data for downstream analytics and reporting.
• Design and implement multi-source data ingestion strategies, including batch and streaming pipelines.
• Establish and maintain robust metadata management using Microsoft Purview to track lineage, quality, and data governance.
• Optimize Fabric Warehouse queries, Spark jobs, and Power BI report performance through query tuning and semantic model refinement.
• Mentor junior team members.
• Collaborate with analysts and other stakeholders to meet their data needs.
• Maintain professionalism and effective communication.
• Oversee installation of hardware and software.
• Design scalable solutions leveraging Fabric's unified platform (Lakehouses, Data Warehouses, Data Engineering).
• Ensure compliance with data governance policies and industry regulations.
• Integrate cloud-based storage solutions (Azure Data Lake Storage) to ensure seamless scalability and durability.
• Silver Layer: Design and deploy data transformation processes and pipelines for clean, validated datasets.
• Implement change data capture (CDC) and incremental load patterns for efficient data pipeline operations
• Bronze Layer: Implement raw data ingestion via Fabric Data Factory pipelines and Event Streams for real-time data capture from multiple sources.
• Collaborate with users and vendors on issues and application upgrades.
• Create documentation for Fabric data lakehouse architecture, medallion layer design, and data integration processes.
• Collaborate cross-functionally teams to align architecture with bronze, silver, and gold data layer standards.
• Enforce security measures to protect sensitive data within the lakehouse.
• Provide after-hours support as part of the team.
• Monitor and optimize lakehouse performance across all medallion layers.
• Optimize data processing frameworks to transform and cleanse data for downstream analytics and reporting.
• Maintain a regular, dependable attendance and a consistently high level of performance.
• Gold Layer: Develop business-ready data models and semantic layers optimized for Power BI.
• Implement and manage metadata catalogs to enhance data discoverability and usability.
• Support and troubleshoot data issues to maintain data integrity and availability.

Requirements

• Advanced Power BI Development skills: creating performant, user-friendly reports with complex DAX and optimized data models.
• Mastery of Microsoft Fabric platform components: Lakehouse, Data Factory, Notebooks, Data Warehouse, Event Streams, and integration patterns.
• Strong understanding of data governance, security, and compliance.
• Experience managing multiple assignments simultaneously, prioritizing tasks effectively.
• Ability to follow management direction, work with a team, adhere to schedules, focus on details, and comply with work rules.
• Minimum of six (6) years of recent experience in data engineering, big data, data management, Microsoft Fabric, and project planning.
• Skilled in organizing and prioritizing daily work to meet strict deadlines.
• Experience in the full product development life cycle.
• Proven experience with Fabric Data Engineering, Pipelines, Notebooks, Lakehouse technologies and cloud-based storage solutions.
• Must possess and maintain a valid driver’s license and a driving record satisfactory to the company and its insurers (for travel).
• Analytical thinker with ability to apply functional and technical knowledge to resolve problems efficiently.
• Microsoft Azure and/or Fabric certifications are a plus.
• Experience developing and maintaining Power BI reports.
• The employee is regularly required to use hands to type, touch, handle, or feel.The employee is required to talk and hear.The employee is frequently required to stand and reach with hands and arms.The employee is occasionally required to walk and climb or balance.The employee must regularly lift and /or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
• Bachelor's or master's degree from an accredited institution in Computer Science, Management, Information Systems, Business Management, or a related discipline.
• Must be able to perform all essential and marginal functions of the job.
• Established SQL skills in MS SQL and/or Oracle databases.
• MBA or MIS highly preferred.
• Customer service oriented with excellent problem-solving skills in dynamic collaborative settings.
• Strong interpersonal skills with clear verbal and written communication of system requirements.
• The successful candidate will be required to clear a drug screen and a complete background check, including a credit report for certain positions, after an offer has been extended and prior to being employed.
• Formal lead role
• Power BI Data Analyst Associate - Highly Preferred
• Advanced proficiency in MS Office applications (Excel, Word, Access, PowerPoint, Outlook).
• Minimum of eight (8) years overall IT experience.
• Microsoft Certified: Azure Data Engineer Associate - Preferred
• A minimum of eight (8) years of direct work experience in IT or a related discipline may be considered as a substitute for a degree.
• Excellent organizational, time management, and communication skills across all company levels.
• Proven experience in data engineering and designing data Lakehouse architectures using medallion architecture patterns.
• Minimum three (3) years hands-on Microsoft Fabric experience or equivalent Azure data platform technologies.
• Familiarity with modern DevOps practices and tools is a plus.
• Must be able to sit for prolonged periods of time.
• Microsoft Fabric Analytics Engineer Associate - Highly Preferred
• Strong knowledge of data engineering best practices including data quality, testing, performance optimization, and modern data pipeline patterns.
• Experience in effectively communicating business and technical issues to both technical and non-technical audiences.
• Expertise in medallion architecture: designing and implementing bronze, silver, and gold data layers with appropriate transformation logic and data governance.
• Required to carry a cell phone and be available to respond during working and non-working hours.
• Effective multitasking and deadline management skills.
• Ability to work independently with minimal supervision and collaboratively in a team environment emphasizing knowledge sharing.

Benefits

• Minimal safety hazards; general office working conditions.

Training + Development

Interview process

Visa Sponsorship

Security clearance