Data Analyst

Position Description

POSITION OVERVIEW:

The Data Analyst is responsible for the full life cycle of data analytics including requirements gathering, analysis design, data collection and cleaning, performing analysis, and reporting findings. This position will support the Portfolio Management Office (PMO) at the Engineering Department and report to the Division Manager of PMO. The candidate is expected to analyze data using a variety of tools and data sources, including QuickBase, Power BI, Paginated Reporting (SSRS), Python, SQL, Excel formulas, as well as commercial cloud platforms such as Snowflake, Power BI's Cloud Services (e.g., Data Flows and Dataverse) and Amazon Redshift - respectively.

JOB DUTIES:

• Collaborate to build scalable processes and metrics.

• Extract or mine data from a variety of data sources.

• Process, clean, and validate the integrity of data for analysis.

• Analyze large amounts of information to find patterns and solutions.

• Provide information on analytic results to functional leaders using visualizations including Power BI, data maps etc.

• Present results in a clear manner.

• Propose solutions and strategies to tackle business challenges.

• Liaison with Business and IT teams.

• All other duties and responsibilities as assigned.

Harris County is an Equal Opportunity Employer

https://hrrm.harriscountytx.gov/Pages/EqualEmploymentOpportunityPlan.aspx

If you need special services or accommodations, please call (713) 274-5445 or email ADACoordinator@bmd.hctx.net

This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.

Requirements

Education:

• Bachelor's degree in management Information Systems, Computer Science, Mathematics, Information Technology, or a relevant quantitative field.

Experience:

• A minimum of 5 years of professional experience in Information Systems, Computer Science, Mathematics, Information Technology, or a relevant quantitative field.

Knowledge, Skill & Abilities (KSAs):

• Must have programming experience using Python & SQL.

• Must have good applied statistical skills, including knowledge of statistical tests, distributions, regressions, etc.

• Must have experience with Data Wrangling and be proficient with handling imperfections in data.

• Must possess excellent analytical, problem-solving, and verbal and written communication skills.

• Must possess keen attention to detail and the ability to discern conclusions from aggregated data.

• Must be able to work efficiently and without constant supervision.

• Must possess and understand the importance of customer service skills and professionalism.

• Ability to self-start; assume ownership in setting goals.

• Must possess the ability to learn and understand project management principles and processes.

• Must possess Intermediate or excellent skills with Microsoft products and can interact with computerized systems to manipulate data and create reports.

• Prior experience with writing and analyzing business and system requirement documents that convey complex business analysis and technology solutions.

• Experience in forecasting, financial, and project analysis combined with an understanding of key performance indicators.

NOTE: Qualifying education, experience, knowledge, and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.

Preferences

Education:

• Master's degree in management Information Systems, Computer Science, Mathematics, Information Technology, or a relevant quantitative field.

Experience:

• 8 years of professional experience in Information Systems, Computer Science, Mathematics, Information Technology, or a relevant quantitative field.

Knowledge, Skill & Abilities (KSAs):

• Experience in eBuilder, Tririga, Snowflake, QuickBase, PowerBI, Python & SQL is a plus.

• Experience as a Software as a Service (SaaS) administrator.

• General understanding of engineering and construction terminology.

• Experience with Power BI reporting and other reporting tools is a plus.

• Prior experience with writing and analyzing business and system requirement. documents that convey complex business analysis and technology solutions.

• Experience in forecasting, financial, and project analysis combined with an understanding of key performance indicators.

General Information

Position Type, and Typical Hours of Work:

• Full-Time | Regular | 40 hours per week.

• Hybrid schedule: Three days in the office and two days working from home.

• Subject to early mornings, late evenings, weekends and holidays at times, depending upon the project or workload.

Salary:

• Commensurate with experience, based on 26 pay periods.

Physical Demands and Environmental Exposure:

Most assignments will be performed in an office, meeting, or operations command center environment, but some field work may be required. May be required to work extended work hours during activation of disaster recovery operations for an unspecified length of time (varies based on the extent of the event).

This position requires bending, stooping, and lifting up to 25 lbs., frequent walking, standing, sitting, reaching, and ascending/descending stairs.

The physical demands described here are representative of those that must be met by an employee to perform the essential functions of this job successfully.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

FEATURED BENEFITS:

• Medical, vision, and dental insurance.

• Wellness.

• Professional development opportunity.

• Flexible spending account.

• 457 deferred compensation plans.

• Retirement pension (TCDRS).

• Transportation assistance (Metro Ride Sponsor Program).

• Disability and life insurance.

• Harris County is a Qualified Employer for the Public Service Loan Forgiveness Program (PSLF).

Employment may be contingent on passing a drug screen and meeting other standards.

Due to a high volume of applications positions may close prior to the advertised closing date or at the discretion of the Hiring Department.

BENEFITS

Harris County offers a competitive benefits program, including comprehensive group health and related benefits plan as well as defined benefit retirement plan.

The following list of benefits is offered only to employees in regular (full-time) positions:

• Medical Coverage

• Dental Coverage

• Vision Coverage

• Wellness Plan

• Life Insurance

• Long-term disability

• Employee Assistance Program

• Ten (10) days of vacation each year for the first five (5) years of service

• Accrual rates increase based on years of service

• Eleven (11) County-observed holidays and one (1) floating holiday

• Professional development opportunities

• Dependent Care Reimbursement Plan

• Healthcare Reimbursement Account

• 457 Deferred Compensation Plan

The following benefits are also available to regular (full-time) employment and may be available to part-time employees:

• Retirement Pension (TCDRS)
• Flexible schedule (varies by department)
• Transportation Assistance (Metro RideSponsor Program)

In accordance with the Harris County Personnel Regulations, Group Health and related benefits are subject to amendment or discontinuance at any time. Commissioners Court reserves the right to make benefit modifications on the County's behalf as needed.

For plan details, visit the Harris County benefits website:

https://benefitsathctx.com/

01

Which of the following best describes your highest level of education completed as it relates to this position?

• High School or GED diploma

• Associate Degree

• Bachelor's Degree

• Master's Degree or higher

• None of the above

02

If you selected a degree in response to the previous question, which of the following best describes your major?

• Management Information Systems

• Computer Science

• Mathematics

• Information Technology

• Relevant quantitative field

• Other

03

How many years of experience do you have in Information Systems, Computer Science, Mathematics, Information Technology, or a relevant quantitative field?

• 8 years or more

• 5-7 years

• 2-4 years

• 1 year

• Less than 1 year

• None of the above

04

Please describe your verifiable experience in Information Systems, Computer Science, Mathematics, Information Technology. NOTE: Please DO NOT use "See Resume" (Type N/A if not applicable)]

05

Do you have programming experience using Python & SQL?

• Yes

• No

06

If you answered yes in regard to the previous question, please describe your verifiable experience using Python & SQL. NOTE: Please DO NOT use "See Resume" (Type N/A if not applicable)]

07

Do you have statistical knowledge including knowledge of statistical tests, distributions, regressions, etc?

• Yes

• No

Required Question

Agency Harris County

Address 1111 Fannin St

Ste. 600

Houston, Texas, 77002

Phone 713-274-5445

Website https://www.governmentjobs.com/careers/harriscountytx