IT Business Intelligence Engineer, Sr.

Description

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

Requirements

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

Benefits

• Minimal safety hazards; general office working conditions.

Training + Development

Interview process

Visa Sponsorship

Security clearance