Mortenson ยท 7 hours ago
Lead Systems Analyst | Mortenson
Minneapolis, MN
Full-time
Hybrid
Senior Level, Lead/Staff
$122K/yr - $182K/yr
7+ years expMortenson is a top builder, developer, and EPC company specializing in various markets including sports and renewable energy. The Lead Systems Analyst will play a critical role in designing and maintaining a cloud-based data and analytics platform, leveraging Microsoft Fabric and related tools to create data solutions that enhance business intelligence.
Commercial Real EstateConstructionReal Estate
No H1B
U.S. Citizen Only
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
Qualification
Required
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
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
Preferred
Bachelor's degree preferred
Expert-level proficiency in Power BI, including data modeling, DAX, and report development (preferred)
Experience with Power Automate for creating cloud flows and automating business processes (preferred)
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
Company
Mortenson
Mortenson is a U.S.-based, top-25 builder, developer and provider of energy and engineering services committed to helping organizations move their strategies forward.
5001-10000 employees
Funding
Current Stage
Late StageLeadership Team
Will Adams
VR Developer
Recent News
Government Technology US
2025-10-25
2025-09-25
Seattle TechFlash
2025-08-07
Company data provided by crunchbase