Microsoft Power BI Consultant

at  Lucid Technologies Inc

POSITION DESCRIPTION:

• 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.

POSITION REQUIREMENTS:

• 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 and 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

ADDITIONAL REQUIREMENTS:

• 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.

EXPERIENCE:

• 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:
• Dashboards
• TypeScript development tools
• D3 JavaScript libraries
• Scalable Vector Graphics (SVG)

Please refer the Job description for details