The Business Intelligence Engineer learns MidFirst Bank's Microsoft Fabric data platform, governed Power BI development standards, and banking data domains while delivering well-defined, closely scoped work items. Success at this level is measured by the quality and consistency of assigned deliverables, the pace of technical skill acquisition, and demonstrated adherence to EBI standards and Enterprise Data Governance policies.
Scope & Decision Authority
▪ Executes discrete, well-defined tasks assigned and reviewed by a Senior, Lead, or the EBI Supervi-sor.
▪ Impact is at the task and report-component level; all work is peer-reviewed prior to promotion be-yond Development workspaces.
▪ No independent production deployment authority.
Core Responsibilities
Data Engineering & Fabric Platform
▪ Builds and modifies simple Dataflows Gen2 and Power Query (M) transformations against curated Lakehouse and Warehouse sources under direction.
▪ Assists with data validation, profiling, and reconciliation tasks (row counts, control totals, source-to-target checks) for pipelines owned by senior engineers.
▪ Learns MidFirst's Fabric workspace structure, environment tiers (Dev/Test/Prod), and the EBI work-space naming and governance policy.
▪ Documents data lineage, refresh schedules, and job dependencies for assigned components.
Power BI Development
▪ Develops report pages and visuals from approved wireframes using the governed MidFirst theme JSON library and Dashboard Standards (correct colorway by business line; brand-compliant use of PMS 021 orange).
▪ Writes basic DAX measures (aggregations, simple time intelligence) with guidance and applies standard formatting, tooltips, and accessibility conventions.
▪ Performs report QA: visual-level testing, slicer/filter behavior, bookmark integrity, and RLS spot checks under supervision.
▪ Maintains existing reports: label updates, minor visual changes, documentation refreshes.
Governance, Quality & Compliance
▪ Follows EBI publishing standards, including overwrite-in-place deployment to preserve report IDs and user bookmarks.
▪ Completes required bank compliance training and learns data classification, GLBA privacy expecta-tions, and least-privilege access practices.
▪ Logs work items, test evidence, and peer-review outcomes in the team's intake and tracking pro-cess.
Collaboration & Growth
▪ Participates in team ceremonies, design reviews, and standards walkthroughs; asks questions early and surfaces blockers promptly.
▪ Pursues Microsoft PL-300 (Power BI Data Analyst) certification within the first 12–18 months.
▪ Shadows senior engineers on stakeholder requirement sessions to learn MidFirst's business lines (Retail, Commercial, MidFirst Private Bank, Mortgage Servicing, MoneyMoments).
Microsoft Fabric Platform & Certification
▪ Navigates the Fabric workspace model and OneLake: item types (Lakehouse, Warehouse, seman-tic model, report, pipeline, notebook, Dataflow Gen2), SQL analytics endpoints, and EBI's Dev/Test/Prod workspace tiers.
▪ Executes and monitors scheduled pipeline runs and dataflow refreshes; triages failures with run his-tory and logs and escalates to the owning engineer.
▪ Queries Lakehouse Delta tables through the SQL analytics endpoint for validation and reconciliation tasks; learns Delta Lake fundamentals (tables, schema evolution, V-Order) and medallion-layer concepts.
▪ Certification path: completes Fabric fundamentals learning paths on Microsoft Learn and attains PL-300 (Power BI Data Analyst) within 12–18 months; begins the DP-600 learning path once PL-300 is achieved.
Minimum Qualifications
▪ Bachelor's degree in Computer Science, Information Systems, Analytics, or related field; or equiva-lent experience (including military technical training).
▪ Foundational SQL and exposure to Power BI or a comparable BI tool (academic, internship, or self-directed).
▪ Familiarity with basic data concepts: relational models, joins, aggregation, data types.
▪ Strong attention to detail and willingness to work within documented standards
Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThis employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Skills Required
- Bachelor’s degree in Computer Science, Information Systems, Analytics, or a related field, or equivalent experience including military technical training
- Foundational SQL experience
- Exposure to Power BI or a comparable business intelligence tool through academic work, internship, or self-directed learning
- Familiarity with relational models, joins, aggregations, and data types
- Strong attention to detail and willingness to work within documented standards
MidFirst Bank Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about MidFirst Bank and has not been reviewed or approved by MidFirst Bank.
-
Healthcare Strength — Health, dental, and vision coverage are available to eligible full‑time and part‑time employees, with company‑paid long‑term disability and an EAP included. Medical plans through Blue Cross Blue Shield and wellness incentives that can lower premiums are highlighted.
-
Retirement Support — A company 401(k) match with a clear formula and a defined vesting schedule provides meaningful retirement support. Eligibility and enrollment timing are specified, reinforcing predictable access to the plan.
-
Leave & Time Off Breadth — Paid vacation, paid sick leave, and paid holidays are emphasized, with a paid community service day also referenced. Time‑off offerings are portrayed as generous across materials.
MidFirst Bank Insights
Similar Jobs
What We Do
MidFirst Bank occupies a rare position within the banking industry. With $41.2 billion in assets, MidFirst Bank is the largest privately owned bank in the country. This combination of size and private ownership provides our customers with a special brand of banking. MidFirst Bank offers a full range of personal, commercial, trust, private banking and mortgage banking products and services. MidFirst is a strong commercial real estate lender and a major servicer of mortgage loans nationally. As a private business ourselves, we understand the unique needs of each business community we serve at each of our locations in Arizona (Phoenix), California (Los Angeles, Orange County, Santa Barbara, San Diego), Colorado (Boulder, Denver, Edwards, Fort Collins), Nevada (Las Vegas), Oklahoma (Oklahoma City, Tulsa, Western Oklahoma), Texas (Dallas, Houston, San Antonio) and Utah (Salt Lake City). Additionally, MidFirst Bank has commercial lending offices in Atlanta, Chicago, Nashville, New York City, Orlando, Raleigh and Southern California. We serve Southern California through 1st Century Bank, a division of MidFirst Bank. We also operate MidFirst Business Credit as a subsidiary of MidFirst Bank. MidFirst Bank provides services that compete with larger banks, while the people and culture truly define the MidFirst Bank difference. MidFirst provides exceptional financial and deeply committed customer service. Team members are loyal in their character, loyal in their personal commitment to customers, and loyal to always doing the right thing. MidFirst customers can always count on working with thoughtful, intelligent, honest professionals who are true to their financial goals. MidFirst Bank is a strong supporter of the communities they serve, investing time and money in important educational, charitable and civic organizations. Copyright © 2025 MidFirst Bank. All rights reserved. Member FDIC. Equal Housing Lender.
