Serves as a gatekeeper of the organization’s data. Creates databases, tables, queries, reports, and dashboards by combining data from multiple sources so stakeholders can understand data and use it to make strategic business decisions. Lead the process of collecting and reporting on data to maximize the utility of the Workforce Solutions Management Information System. Common functions of analysts include working with fellow data and systems analysts and user teams to leverage analytical tools, including Microsoft Power BI, and Microsoft SQL Server to collect data, design and create databases, dashboards, alerts, and reports to support business performance

CORE DUTIES AND RESPONSIBILITIES:

• Creates SQL queries to select and work with data from multiple relational databases
• Design and build dashboards, reports, and supporting data tables in Microsoft SQL Server and Microsoft PowerBI
• Publish these dashboards and reports to users
• Identifies and documents process improvement opportunities and creates reports and data tools to take advantage of these opportunities
• Evaluates new data tools for implementation by staff
• Designing and maintaining data systems and databases; this includes fixing coding errors and other data-related problems.
• Mining data from primary and secondary sources, then reorganizing said data in a format that can be easily accessible to the organization.
• Work with management to prioritize business and information needs.
• Collaborating with end users and team members to identify opportunities for improvement.
• Using statistical tools to interpret data sets, paying particular attention to trends, patterns, and predictions using relevant data.
• Using analytical tools to create dashboards with various methods of visualizing data.
• Professionally represents the Agency to career office operators, the Gulf Coast Workforce Board, and Houston-Galveston Area Council staff
• Maintains a mature problem-solving attitude while dealing with interpersonal conflict or time demands
• Ensures department compliance functions are supported with adequate reports
• Establish KPIs to measure the effectiveness of business decisions.
• Performs other duties as may be assigned

Experience

• 1 - 2 years: SharePoint Experience
• 5 - 7 years: Experience with business operations or data management
• 1 - 2 years: Experience working with SQL developing queries for reports and data generation 1–2 years of experience with report-writing tools

Education

• Bachelors or better

• High School or better

Skills

• SQL
• Business Intelligence
• Microsoft Office
• Data Analytics

• Planning & Organizing
• End User Support
• Database Design

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)