Microsoft Power BI Data Analyst Associate certification

Under the direction of the Strategy/Business Development Manager, this position performs complex (journeylevel) computer system analysis work including interacting closely with project management and customers to develop requirements, design, build and maintain custom reports and dashboards. The primary focus for this position will be on development of reports, paginated reports, views and dashboards in a Power BI environment. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Performs additional duties as assigned. Complies with all Agency, Division and Branch rules, regulations, and procedures., All applications must include complete job history information for each period of employment, provided either in the WORK HISTORY SECTION or in the attached RSUM. Please ensure each entry includes:

• Job title,
• Employer name,
• Dates of employment (month/year),
• If employment is less than fulltime status, indicate parttime in the work history section or rsum, and
• Description of duties performed. NOTE: Volunteer experience may be counted toward required experience.

Graduation from an accredited college or university with a Bachelor’s degree.

Experience:

Minimum of three years of fulltime experience creating enterpriselevel reports using business intelligence tools such as Power BI, Tableau, or comparable platforms.

At least one year of handson experience developing reports and interactive dashboards specifically within Microsoft Power BI.

NOTE: Experience may have occurred concurrently.

Licensure:

Must possess or be able to obtain, within 30 days of employment, a valid class ‘C’ Texas driver’s license.

PREFERRED QUALIFICATIONS:

Education:

Graduation from an accredited college or university with an undergraduate or graduate degree in Computer Science or Data Science.

Experience:

Experience in the Microsoft Power BI platform, including Power BI Service, Power BI Report Builder, and Power BI desktop.

Experience integrating Power BI reports into custombuilt web applications with Oracle databases and Dataverse as the data sources

Experience with paginated reports in producing government issued precise placement documents, such as titles, licenses, certificates, etc.

Experience in related Microsoft apps such as PowerApps, Power Automate, RPA, and Power Pages.

Experience with Oracle, SQL, SAS, the Dataverse, data warehousing, and ETL processes.

Two years of the required experience performing Power BI report building is from a Texas government agency., Knowledge of designing and implementing reports with Power BI Desktop, Power BI Service, and Power BI Report Builder.

Knowledge of the various Power BI report types and has clear understanding of their use cases.

Knowledge of Power Query, M code, and DAX.

Knowledge of current technological trends in Power BI, report development and business intelligence.

Knowledge of functional, business and architectural aspects of Power BI components for providing solutions.

Knowledge of Power BI best practices.

Knowledge of Power BI datasets, Apps report packages, Dataflow, Datamart, deployment pipelines, and Workspaces.

Knowledge of how to connect to various data sources.

Knowledge of data management and data governance best practices.

Knowledge of Agile, Iterative and Waterfall project methodologies.

Knowledge of developing applications for compliance with Section 508 of the U.S. Rehabilitation Act.

Skill in the Power BI platform and its capabilities.

Skill in creating various types of Power BI paginated reports, such as precise placement fulfillment paginated reports (certificate cards, title documents, coupons, etc.), table layout detail paginated reports, summary paginated reports, and receipts.

Skill in creating different paginated report implementations and printing options, such as ensuring report compatibility with nonstandard print sizes and OCR font printing and configuring print tasks to select specific paper trays for output; producing PDF and Excel files for output.

Skill in integrating Power BI reports into custombuilt web applications preferably with both Oracle databases and the Dataverse as data sources.

Skill in creating and publishing visually appealing Power BI interactive reports, mobile reports, and dashboards.

Skill in developing ad hoc reports with variable selection criteria and visualizations, such as slicers, charts, graphs, maps, tables, etc.

Skill in designing and developing data models.

Skill in data transformation, data cleanup, data consolidation, etc. using Power Query.

Skill in advanced data transformation tasks using M code.

Skill in creating custom calculations and measures using DAX.

Skill in connecting to a variety of data sources using connectors and creating custom connectors.

Skill in managing realtime and batch fulfillment jobs, including nighttime batch fulfillment that updates databases.

Skill in managing data refresh schedules to ensure uptodate information.

Skill in optimizing data models for faster query performance.

Skill in managing permissions to reports, row level security, and sharing reports with stakeholders.

Skill in using pipelines and version control.

Skill in troubleshooting production issues.

Skill in using MS Excel, Word and Outlook.

Skill in effective verbal and written communication with both technical and nontechnical audiences.

Skill in collaborating with other developers and developing in a multitier environment.

Skill in establishing and maintaining effective work relationships with coworkers and workrelated contacts.

Skill in prioritizing tasks and meeting deadlines.

Ability to work independently with little or no supervision.

Ability to integrate Power BI report technologies and methodologies into an existing application development environment.

Ability to understand and analyze requirements and provide solutions.

Ability to develop reports from ground up including designing database tables, user interfaces, and report delivery.

Ability to choose the right type of visualization for different data types and applications.

Ability to manage data and report delivery ensuring data privacy and compliance with agency policies.

Ability to create documentation and user guides for reports and dashboards.

Ability to provide support and training to endusers.

Ability to implement best practices for improving report performance.

Ability to conduct testing, verification, troubleshoot and performing root cause analysis.

Ability to understand statistical concepts, methods, KPIs and metrics.

Ability to perform detailed work accurately.

Ability to maintain flexibility and work with frequent interruptions and multiple changing priorities.

Ability to follow standards for report and software development.

Ability to perform the steps required of the System Development Life Cycle (SDLC).

Ability to process information logically.

Ability to manage several projects simultaneously.

Ability to participate in Joint Application Development sessions for requirements gathering.

Ability to conduct work activities in accordance with TPWD safety program., Required to pass a national fingerprintbased background check to maintain employment.

Applicants must be legally authorized to work in the United States and maintain that authorization throughout employment.

Must conform to TPWD dress and grooming standards, work rules, and safety standards.

May be required to operate a state vehicle.

Required to travel 5% with possible overnight stays.

Required to work from 8:00 a.m. to 5:00 p.m., Monday through Friday.

Required to work overtime as necessary.

Required to provide afterhours support as needed.