Senior Microsoft Power BI Developer
Apply NowCompany: ECS
Location: Arlington, VA 22204
Description:
ECS is seeking a Senior Microsoft Power BI Developer to work in Arlington, VA.
Responsibilities to include:
Primary focus on business intelligence and reporting technologies/methodologies
Identify data to clean, transform, and load into data models
Create data models, establish relationship cardinality and cross-filter direction, and build complex measures
Visualize data models by creating reports and dashboards
Assist in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies
Partner with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery
Work collaboratively with team members including project managers, solution architects, and business analysts
Degree in Computer Science, Information Technology, Business or related field OR possess a PL-300: Microsoft Power BI Data Analyst Certification or equivalent
8+ years of progressive experience in business intelligence and/or information management
4+ years of experience with data visualization and implementing high-value solutions; experience performing administrative activities across multi-environment infrastructures
5+ years of experience working in a client-facing technical role
Expert knowledge of data management, business intelligence and analytics concepts including:
o Extract, transform, load (ETL)
o Data warehousing, data marts, data stores, and cubes
o Data quality and profiling
o Data governance, data management, and metadata management
o Data visualization, dashboard design / implementation, reporting, self-service BI, data KPIs, and scorecards
o Predictive, prescriptive, and descriptive analytics
Proficiency in one or more languages like:
o SQL
o SAS
o R
o Python
Implement solutions using Microsoft Power BI tool suite and related technologies
Proficient in developing complex of Data Analytics Expressions (DAX) and M (Power) Queries
Experience with developing interactive dashboards -e.g., parameters, actions, navigation -for ease-of-use.
Proficient in creating dataflows or datamarts
Experience with designing composite models
Experience with report builder and developing paginated reports
Experience with applying roles and Row Level Security (RLS) to Reports, Apps and workspaces
Experience integrating customized automated solutions using PowerApps, Power Automate, SharePoint and Dataverse with Power BI
Understand the administrative functions for Power BI, Managing data gateway, usage report etc.
Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting
Develop high performing, reliable, and scalable solutions
Optimize performance on new and existing data models Clearly communicate technical details to business and management staff
Perform data analysis which supports and enhances OIG information management systems and services
Experience with one or more data technologies (e.g., Oracle, SQL Data Warehouse, SQL Server, etc.) and a willingness to learn how to leverage these technologies to improve business intelligence
Author and oversee design documents for approved projects
Develop, publish and, schedule reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools
Provide meaningful feedback and coaching of other team members in the use of Microsoft Power BI and related technologies
Provide insight and recommendations on new and emerging technologies and concepts to OCIO team members
Eager to contribute to a team-oriented environment
Able to work creatively and analytically in a problem-solving environment
Excellent communication and interpersonal skills
Responsibilities to include:
Primary focus on business intelligence and reporting technologies/methodologies
Identify data to clean, transform, and load into data models
Create data models, establish relationship cardinality and cross-filter direction, and build complex measures
Visualize data models by creating reports and dashboards
Assist in the delivery of quality solutions using Microsoft Business Intelligence tools (Power BI) and related technologies
Partner with OIG customers and OCIO technical team members to assist with requirements definitions, solution designs, technical architecture, and delivery
Work collaboratively with team members including project managers, solution architects, and business analysts
Degree in Computer Science, Information Technology, Business or related field OR possess a PL-300: Microsoft Power BI Data Analyst Certification or equivalent
8+ years of progressive experience in business intelligence and/or information management
4+ years of experience with data visualization and implementing high-value solutions; experience performing administrative activities across multi-environment infrastructures
5+ years of experience working in a client-facing technical role
Expert knowledge of data management, business intelligence and analytics concepts including:
o Extract, transform, load (ETL)
o Data warehousing, data marts, data stores, and cubes
o Data quality and profiling
o Data governance, data management, and metadata management
o Data visualization, dashboard design / implementation, reporting, self-service BI, data KPIs, and scorecards
o Predictive, prescriptive, and descriptive analytics
Proficiency in one or more languages like:
o SQL
o SAS
o R
o Python
Implement solutions using Microsoft Power BI tool suite and related technologies
Proficient in developing complex of Data Analytics Expressions (DAX) and M (Power) Queries
Experience with developing interactive dashboards -e.g., parameters, actions, navigation -for ease-of-use.
Proficient in creating dataflows or datamarts
Experience with designing composite models
Experience with report builder and developing paginated reports
Experience with applying roles and Row Level Security (RLS) to Reports, Apps and workspaces
Experience integrating customized automated solutions using PowerApps, Power Automate, SharePoint and Dataverse with Power BI
Understand the administrative functions for Power BI, Managing data gateway, usage report etc.
Leverage database systems including data warehouses, data marts, and models needed for business, financial, and operational analysis and/or reporting
Develop high performing, reliable, and scalable solutions
Optimize performance on new and existing data models Clearly communicate technical details to business and management staff
Perform data analysis which supports and enhances OIG information management systems and services
Experience with one or more data technologies (e.g., Oracle, SQL Data Warehouse, SQL Server, etc.) and a willingness to learn how to leverage these technologies to improve business intelligence
Author and oversee design documents for approved projects
Develop, publish and, schedule reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools
Provide meaningful feedback and coaching of other team members in the use of Microsoft Power BI and related technologies
Provide insight and recommendations on new and emerging technologies and concepts to OCIO team members
Eager to contribute to a team-oriented environment
Able to work creatively and analytically in a problem-solving environment
Excellent communication and interpersonal skills