Data Analyst

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Data Analyst to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

**Location of job: Onsite**

Responsibilities

Responsible for analyzing, assessing, and documenting diverse data from its source through many complex transformations to all applications that consume the data to assist the Data Management and Support (DMS) Team with continuous improvement in its mission to the agency. Additionally, the individual will identify the issues from the profiling, follow up with the business, document the business rules, and assist with the processes involved around continuous improvement of the quality of the data and other capabilities of the DMS Team. Strong skills to identify and resolve data issues and effectively apply the broad range of professional concepts, practices, and methods in moderately complex and diverse circumstances. Work is performed under moderate supervision of the Data Management and Support Team Lead with moderate latitude for the use of initiative and independent judgement.

Duties and Responsibilities

Essential Functions:

• Expand and continuously refine the data quality program.
• Ensures adherence to the data quality programs and standards.
• Ensures that the data quality corrective action plan is thoroughly documented.
• Promote the importance and awareness of an enterprise data quality program.
• Leverages data management knowledge to define and maintain data quality, reference data, and meta-data processes.
• Participates in the development of data quality rules, thresholds, and standard/quality expectations for data elements that support critical business processes.
• Continuously execute and monitor the Data Quality Lifecycle on a daily basis.
• Profiles data for statistical analysis and assessment of data to document the effectiveness of data quality controls and identifies improvement opportunities.
• Identifies and implements best practices and tools based on the business needs.
• Implement controls to mitigate data quality risks including continuously monitoring data quality results, reports and dashboards.
• Impeccable oral and written communication skills are essential for effectively interacting with data users, managers, and other stakeholders. Complies with all applicable agency policies and procedures, including safety and standards of conduct.
• Performs other duties as assigned

Essential Work Behaviors:

• Communicates respectfully and works harmoniously with all co-workers, customers, and vendors.
• Provides exceptional customer service.
• Is flexible; able to work under pressure and able to adapt to change; and able to work on multiple problems and tasks.
• Takes initiative to prevent and solve problems

Qualifications

Minimum (Required):

• Bachelor’s degree in computer science, engineering, statistics, economics, finance, library science, or related business field
• 3 years experience creating functional and technical documentation, business glossaries, and diagrams, that communicates the desired message to business and technical audiences.
• 3 years experience working with enterprise grade databases- preferably SQL Server and Oracle.
• 3 years experience developing and writing complex SQL scripts/queries-preferably Oracle and SQL Server.
• 2 years experience within the last 5 years developing data quality rules, thresholds, and standard metrics/quality-expectations for data elements that support critical business processes.
• 2 years experience within the last 5 years with an enterprise grade data quality tool such as Alteryx Data Quality, SAS Data Quality, etc.
• 2 years experience within the last 5 years in the Data Quality field developing and implementing best practices and tools based on the business needs.
• Leads and participates in discussions with cross-functional teams.

Preferred (Optional):

• 3 years experience working with complex Excel functions, including but not limited to VLookUp, Macros, Pivot Tables, etc.
• 2 years experience with Microsoft SQL Server BI Stack (RDMS, SSIS, SSRS)
• Experience or familiarity with Alteryx & Tableau.
• Experience or familiarity with Benefits Administration, Pension Administration, and Payroll oriented data in the PeopleSoft HRMS package or similar package.