Power BI Developer

Description Detailed position description: Act as liaison between technology teams and business areas by trouble shooting 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 while understanding 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, Information Systems, Data Analytics or commensurate experience in Power BI dev. 1-3 years of experience in complex development and scripting SQL 1-3 years of experience developing with advanced Power BI tools including DAX, M, & Power Query. 1-3 years of experience with advanced Power BI report development techniques including bookmarking, selection pane, using buttons for page navigation, dynamic measures, and drill-through. 1-3 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. 1-3 years of experience developing dashboard solutions with data visualizations in Microsoft Power BI desktop. 1-3 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 The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)