Lead Systems Analyst

Mortenson • Minneapolis, MN

36d • $121,600 - $182,400 • Remote

About The Position

We are seeking a highly skilled and motivated Lead Systems Analyst to join our dynamic team. In this role, you will be at the forefront of designing, building, and maintaining our cloud-based data and analytics platform. Your primary focus will be leveraging Microsoft Fabric and related tools including Informatica, FiveTran, and SSIS to create robust data pipelines and end-to-end data solutions that automate workflows, build applications, and provide deep business intelligence.

Requirements

• 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
• Expert-level proficiency in Power BI, including data modeling, DAX, and report development
• Experience with Power Automate for creating cloud flows and automating business processes
• Hands-on experience with Power Apps for building custom applications
• Strong understanding of data warehousing concepts, ETL/ELT processes, and data modeling
• Proficiency in SQL for data querying and manipulation
• Excellent problem-solving skills and the ability to work independently on multiple complex projects

Responsibilities

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Construction of Buildings
• Number of Employees: 5,001-10,000 employees