Data Analyst

Job Description

• Data Analyst

Description:

We are looking for a Data Analyst to join our data team. This is a hands - on technical role. Experience with Shell Script and SQL (T - SQL/PostgreSQL/OracleSQL) is essential. The data analyst will follow an agile iterative development methodology with a focus on innovation, data quality, user value, and robust data analysis.

Job Responsibilities:

• Build and test metrics using SQL data - stores.

• Build, test and deploy reports and interactive dashboard, leveraging the same metrics.

• Focus on visualization for effective report generation, revealing a clear data story.

• Process, cleanse, and verify data - integrity for analysis.

• Work closely with the USA team to collect and process data on the web crawler software.

• Build analysis reports for various tests and production runs on the web crawler software.

• Interpret data and analyze results using statistical techniques, and provide ongoing reports.

• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

• Acquire data from primary or secondary data sources and maintain databases/data systems.

• Identify, analyze, and interpret trends or patterns in complex data sets.

• Filter and clean data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.

• Work with management to prioritize business and information needs.

• Locate and define new process improvement opportunities.

Job Requirements:

• Strong T - SQL OR PostgreSQL OR Oracle SQL Skills.

• Strong Microsoft Office Skills especially Word and Excel

• Experience with scripting Language: Shell

• Skilled at queries, report writing and presenting findings.

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate a significant amount of information with attention to detail and accuracy.

• Ability to write comprehensive reports.

• Processing confidential data and information according to guidelines.

• Supporting the data warehouse in identifying and revising reporting requirements.

• Supporting initiatives for data integrity and normalization.

• Providing technical expertise in data storage structures, data mining, and data cleansing.

• Identify areas to increase the efficiency and automation of processes.

• Monitor and audit data quality.

• Ability to deal with high - volume data under tight deadlines.

• Create data dashboards, graphs, and visualizations.

• Strong verbal and written communication skills.

• Ability to work with little or no supervision.

• Ability to work calmly under pressure.

• Ability to work as a strong team player

Education Experience:

• Bachelor s Degree in Computer Science or related field.

• Minimum 3 - 5 years of work experience as a Data Analyst.

Other Attributes:

• Knowledge of data processing, database programming, and data analytics.

• Robust data analysis domain knowledge.

• Ability to understand various data structures and common methods in data transformation.

• Knowledge of scripting languages such as Python, Shell/Sed/Awk.

• Exceptional problem solving and data analysis skills.

• A high degree of reliability, flexibility, and adaptability while working under pressure.

• Strong verbal and written communication skills.

• Detail - oriented with excellent follow - up skills.

About Astegic:

Astegic, founded in 2003, is a woman - owned SBA certified 8a firm that has successfully achieved both SEO CMMI ML2 and ISO - 9001 - 2008 certifications. Astegic provides enterprise - level technology solutions and integrations, meeting enterprise business challenges with cutting - edge technology, for both government and commercial sectors. Our knowledgeable staff of over 150 software engineers, management consultants, IT specialists, and analysts is armed with the technology and expertise to improve and extend your existing enterprise solutions.

,

Keyskills :
reporting sql atastructures testmetrics datamining datacollection dataquality shellscript dataintegrity microsoftexcel stronganalyticalskills dataanalysis dataprocessing problemsolving dataanalytics officeskills computerscience customerre