data analyst ii.
san antonio , texas
posted today
job detailssummary
$80,000 - $95,000 per year
permanent
bachelor degree
category computer and mathematical occupations
reference1053647
job detailsjob summary:Responsible for performing detailed data analysis and identifying trends based on established requirements. Will contribute to the timely delivery of analysis, reports, and visual data analytics. Will create data extraction queries using various tools (SSRS, SSIS, SQL, PowerBi, Aletryx, etc.) to provide accurate presentation of data to drive business decisions.location: San Antonio, Texasjob type: Permanentsalary: $80,000 - 95,000 per yearwork hours: 8am to 4pmeducation: Bachelorsresponsibilities:
Gather and communicate requirements for data collection and metric reporting.
Maintain strict adherence to Standard Operating Procedures (SOPs), regulatory requirements, and all company policies.
Perform routine data entry, analysis, and prepare reports that measure and monitor operational performance.
Participate in continuing education and attend meetings as required.
Creates and utilizes various tools and methods to provide support for production solutions, end users, projects and business leaders on a regular and ad hoc basis.
Implement and manage daily extract, transform, and load processes of data from various system databases.
Ability to work with relational tables/files and data flows. Design and deliver interactive visual analytics solutions.
Partner with data owners to collect, validate and define data usages.
Ensure consistency and quality of data collected from across different master data sources, systems, and solutions.
Assist team members and customers with problem solving related to data/report production to ensure business needs are met without interruption or delay.
Utilize available tools such as SQL, SQL Server Management Studio, power shell scripting, regex, web APIs and AI Tools, Excel, Toad, SSIS, and SSRS.
Translate reporting requests in order to accurately meet the actual information and deadline needs of users.
Educate requestors as to appropriate and desirable parameters to ensure they get the information they need.
Collaborate with end users to gather report requirements and ensure proper testing and validation. Provide support to end users on standardized and ad hoc reports.
Analyze tables in company database to establish knowledge of data for accurate retrieval and use in report writing.
Document and maintain all required report design and configures report system accordingly.
Validate the results of SQL queries with end users, and present the data in an intuitive and visually appealing way, which may include tables, pie charts, bar graphs, or other diagrams.
Define reporting standards to be used to support all enterprise requests.
Support and drive implementation of central data warehouse.
Knowledge of information technology service management concepts and methodologies, business process analysis and reengineering, and project management processes and methodologies.
Must have knowledge of system design and development processes and methodologies relative to data management and report generation.
Must have advanced knowledge of manual and automated process data collection methods.
Must obtain a working knowledge of regulatory/quality requirements and perform within all Standard Operating Procedures (SOPs) and policies.
qualifications:
Experience level: Experienced
Minimum 5 years of experience
Education: Bachelors (required)
skills:
SQL
PowerBI
SSRS
SSIS
Tableau
Aletryx
Data Warehouse
Data AnalysisEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected] offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.