Lead Systems Analyst

Overview

Design, build, and maintain cloud data and analytics platform using Microsoft Fabric.

Key Responsibilities

• onelake management
• data integration
• power bi
• power apps
• power automate
• data pipelines

Tasks

-Implement and manage OneLake as the unified, single logical data lake for the organization -Architect and implement data integration solutions using the Fabric ecosystem, Informatica or FiveTran, including data flows, copy activities, and orchestration -Connect Power BI reports directly to data sources within the Microsoft Fabric environment, including Data Warehouses and Lakehouses -Develop interactive and visually compelling reports and dashboards using Power BI to translate complex data into actionable insights for business stakeholders -Create seamless end-to-end solutions by connecting Power Apps and Power Automate flows to data residing in Microsoft Fabric and other corporate systems -Design, develop, and manage scalable and reliable data pipelines within Microsoft Fabric to ingest, transform, and load data from various source systems (both on-premises and cloud) -Develop and optimize data transformation logic within Data Pipelines and Dataflows Gen2 in Fabric -Provide technical guidance and mentorship to junior team members -Collaborate with business analysts, stakeholders, and other IT teams to understand requirements and deliver high-impact solutions -Design, build, and deploy custom canvas and model-driven apps using Power Apps to enable business users to interact with and act upon data -Automate repetitive business processes and data workflows using Power Automate, integrating various data sources and applications (e.g., SharePoint, Outlook, Excel) -Enforce best practices for data governance, security, and performance tuning across the Power Platform and Fabric landscape -Design and build scalable Power BI data models, write efficient DAX calculations, and implement row-level security (RLS) -Manage and orchestrate data workflows within the Fabric platform, ensuring efficient and timely data processing

Requirements

• power bi
• power automate
• microsoft fabric
• sql
• 7+ years
• bachelor's

What You Bring

-Strong understanding of data warehousing concepts, ETL/ELT processes, and data modeling -Experience with Power Automate for creating cloud flows and automating business processes -Our postings are typically open a minimum of 5 days and an average of 44 days. -Visa sponsorship is not offered for this position. -Expert-level proficiency in Power BI, including data modeling, DAX, and report development -7+ years of hands-on experience in data engineering, business intelligence, or a similar role -Demonstrate expertise in Microsoft Fabric, with hands-on experience building and managing data pipelines using tools such as Informatica, SSIS, and FiveTran -Must be currently legally authorized to work in the U.S. without sponsorship for employment visa status (e.g., H1B status, 0-1, TN, CPT, OPT, etc.). We are unable to sponsor or take over sponsorship of an employment Visa at this time. -Proficiency in SQL for data querying and manipulation -Excellent problem-solving skills and the ability to work independently on multiple complex projects -Hands-on experience with Power Apps for building custom applications -Bachelor's degree preferred

People Also Searched For

Benefits

-Dental plan -No-Cost mental health tool and concierge with extensive work-life resources -Adoption Assistance -Medical and prescription drug plans that includes no additional cost vision coverage -401k retirement plan with a generous Mortenson match -Tuition reimbursement -Gym Membership Discount Program -Paid time off, holidays, and other paid leaves -Employer paid Life, AD&D, and disability insurance

About Mortenson

-The company has successfully delivered major projects across multiple sectors, from high-rise buildings to complex industrial sites. -Known for its strong focus on sustainability and innovative construction practices, Mortenson has consistently been at the forefront of industry trends. -A standout in the renewable energy sector, Mortenson is involved in developing some of the largest wind and solar projects in North America. -With a history of landmark projects, Mortenson has also worked on sports arenas, data centers, and high-profile government buildings. -The company is not just about bricks and mortar; Mortenson also excels in developing cutting-edge technologies to enhance project efficiency and safety.

Sector Specialisms

Visa Sponsorship

-visa sponsorship is not offered for this position. -candidates must be legally authorized to work in the u.s. without visa sponsorship.