Midland Financial Co.
Sr Power BI Developer
Midland Financial Co., Oklahoma City, Oklahoma, United States, 73116
Detailed position description:
Act as liaison between technology teams and business areas by troubleshooting and translating technical problems related to reports and report data.
Assist business users on functional and data requirements to enhance reports and report data.
Supports business data experts on select data repositories and provides support for project implementations and modifications impacting data repositories.
Follows best practices and guidelines to support dashboards, metrics, scorecards, and reporting solutions providing a high level of customer service with an emphasis on partnership and collaboration.
Assists with investigating, reviewing and analyzing data from multiple internal and external sources to maintain quality and understand the source structures and business relevance of the data.
Performs analysis and design by translating business requirements and developing reporting and dashboard solutions that yield relevant business information in a user-friendly format by collecting, analyzing and leveraging data.
Monitors recurring processes and ensures output accuracy and timely distribution. Responsible for maintenance, documentation, and enhancements of recurring processes and procedures.
Follows best practices in data modeling and source-to-target mapping.
Performs planned maintenance (e.g., application upgrades, releases, enhancements, service packs, etc.) on BI solutions and underlying infrastructure.
Ensures that adequate security procedures are developed and followed.
Attention to detail to deliver a complete and correct solution within deadlines.
Contributes technical knowledge and understanding of applications to training programs, support processes, and operating procedures.
Ability to conduct report demonstrations and training sessions for business units and developers.
Ability to collaborate with BU development team to review data model & report specifications.
Position Requirements:
BS in Computer Science, Accounting, Information Systems, Data Analytics or commensurate Power BI development experience.
3-5 years of experience in complex development and scripting SQL
3-5 years of experience developing with advanced Power BI tools including DAX, M, & Power Query.
3-5 years of experience with advanced Power BI report development techniques including bookmarking, selection pane, using buttons for page navigation, dynamic measures, and drill-through.
3-5 years of experience developing reports, researching, analyzing and problem-solving using end-user tools such as Paginated Reports Builder, Power BI Desktop and Visual Studio.
3-5 years of experience developing dashboard solutions with data visualizations in Microsoft Power BI desktop.
3-5 years of experience using Visual Studio & SSMS to develop Analysis Services Tabular models.
Experience with Microsoft Azure platform and service (Power BI, Azure SQL Data Warehouse, Azure Synapse, Azure Data Factory) including the creation and maintenance of ADF data ingestion pipelines, data quality pipelines, notification pipelines, Azure Logic Apps to refresh data models, and Synapse tables & views.
Experience working with large and complex datasets.
Strong understanding and working experience establishing and maintaining RLS (Row Level Security) in Azure Analysis Services / Power BI tabular models.
Expertise with database and data warehouse designs, data modeling, data performance tuning, data integration, including ETL processes.
Knowledge and applied documentation experience with a variety of industry concepts, methodologies, and frameworks within data warehouse and business intelligence field including requirements, source to target mapping, architecture, and design documentation.
Ability to manage the project lifecycle of report development from data identification, source data mapping, data staging, model development, report development, report publishing & report security.
Prefer familiarity with relational databases with the ability to create calculated members and key performance indicators (KPIs).
Experience with Tabular Editor and DAX Studio preferred.
This is an on-site position in Oklahoma City, you have to reside in this area in order to be considered for this opening.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
#J-18808-Ljbffr
Act as liaison between technology teams and business areas by troubleshooting and translating technical problems related to reports and report data.
Assist business users on functional and data requirements to enhance reports and report data.
Supports business data experts on select data repositories and provides support for project implementations and modifications impacting data repositories.
Follows best practices and guidelines to support dashboards, metrics, scorecards, and reporting solutions providing a high level of customer service with an emphasis on partnership and collaboration.
Assists with investigating, reviewing and analyzing data from multiple internal and external sources to maintain quality and understand the source structures and business relevance of the data.
Performs analysis and design by translating business requirements and developing reporting and dashboard solutions that yield relevant business information in a user-friendly format by collecting, analyzing and leveraging data.
Monitors recurring processes and ensures output accuracy and timely distribution. Responsible for maintenance, documentation, and enhancements of recurring processes and procedures.
Follows best practices in data modeling and source-to-target mapping.
Performs planned maintenance (e.g., application upgrades, releases, enhancements, service packs, etc.) on BI solutions and underlying infrastructure.
Ensures that adequate security procedures are developed and followed.
Attention to detail to deliver a complete and correct solution within deadlines.
Contributes technical knowledge and understanding of applications to training programs, support processes, and operating procedures.
Ability to conduct report demonstrations and training sessions for business units and developers.
Ability to collaborate with BU development team to review data model & report specifications.
Position Requirements:
BS in Computer Science, Accounting, Information Systems, Data Analytics or commensurate Power BI development experience.
3-5 years of experience in complex development and scripting SQL
3-5 years of experience developing with advanced Power BI tools including DAX, M, & Power Query.
3-5 years of experience with advanced Power BI report development techniques including bookmarking, selection pane, using buttons for page navigation, dynamic measures, and drill-through.
3-5 years of experience developing reports, researching, analyzing and problem-solving using end-user tools such as Paginated Reports Builder, Power BI Desktop and Visual Studio.
3-5 years of experience developing dashboard solutions with data visualizations in Microsoft Power BI desktop.
3-5 years of experience using Visual Studio & SSMS to develop Analysis Services Tabular models.
Experience with Microsoft Azure platform and service (Power BI, Azure SQL Data Warehouse, Azure Synapse, Azure Data Factory) including the creation and maintenance of ADF data ingestion pipelines, data quality pipelines, notification pipelines, Azure Logic Apps to refresh data models, and Synapse tables & views.
Experience working with large and complex datasets.
Strong understanding and working experience establishing and maintaining RLS (Row Level Security) in Azure Analysis Services / Power BI tabular models.
Expertise with database and data warehouse designs, data modeling, data performance tuning, data integration, including ETL processes.
Knowledge and applied documentation experience with a variety of industry concepts, methodologies, and frameworks within data warehouse and business intelligence field including requirements, source to target mapping, architecture, and design documentation.
Ability to manage the project lifecycle of report development from data identification, source data mapping, data staging, model development, report development, report publishing & report security.
Prefer familiarity with relational databases with the ability to create calculated members and key performance indicators (KPIs).
Experience with Tabular Editor and DAX Studio preferred.
This is an on-site position in Oklahoma City, you have to reside in this area in order to be considered for this opening.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
#J-18808-Ljbffr