NOTE: This individual will be able to telework. However, this individual is required to live within driving distance of Arlington VA so that they are able to come into the office if needed. Schedule TBD by manager.
Education Requirement: MUST have a Degree in Computer Science, Information Technology, Business, or related field.
Primary focus on business intelligence and reporting technologies/methodologies
Perform data manipulation and cleansing to prepare datasets for visualization.
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.
Implement solutions using Microsoft Power BI tool suite and related technologies.
Proficient in the use of Data Analytics Expressions (DAX) and Power Query
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.
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 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
Experienced with features of the Power BI Service and Power BI Premium including establishing gateway refresh schedules and row level security.
Experienced with other Power Platform tools including Power Apps, Power Automate, Dataverse, etc. and integrating them with Power BI solutions.
Capable of providing technical expertise in the diagnosis and resolution of issues and service desk tickets.
Capable of creating datasets and data flows for self-service reporting.
Capable of maintaining, updating, and performance tuning existing BI reports.
Capable of cleaning, examining, and interpreting data in order to develop effective visualizations.
MUST have a Degree in Computer Science, Information Technology, Business, or related field.
Minimum of 4-7 years of progressive experience in business intelligence and/or information management
2+ years of experience with data visualization and implementing high-value solutions; experience performing administrative activities across multi-environment infrastructures.
2+ years of experience working in a client-facing technical role.
Experience developing and administrating PBI dashboards.
Expert knowledge of data management, business intelligence and analytics concepts including:
Extract, transform, load (ETL)
Data warehousing, data marts, data stores, and cubes
Data quality and profiling
Data governance, data management, and metadata management
Data visualization, dashboard design / implementation, reporting, self-service BI, data KPIs, and scorecards
Predictive, prescriptive, and descriptive analytics
Knowledge of the following to facilitate the development of custom visuals:
TypeScript development tools
Scalable Vector Graphics (SVG)
Proficiency in one or more languages like:
Must be able to obtain a Position of Public Trust Clearance – US Citizen or Permanent Resident (Green Card Holder) and must not have traveled outside the US for a combined total of 6 months or more in last 5 years.