Entry Level Data Analyst **S

SQL Developer (Training)

·        Help write and optimize in-application SQL statements.

·        Ensure performance, security, and availability of databases.

·        Prepare documentations and specifications.

·        Handle common database procedures such as upgrade, backup, recovery, migration, etc.

·        Write TSQL scripts and objects such as stored procedures, user-defined functions, views, indexes per business requirements.

·        Create ETL SSIS packages to migrate data from OLTP sources to OLAP destinations through available tasks and transformations in SSIS.

·        Design and create user interactive reports in SSRS, Power BI and Tableau.

·        Profile server resource usage, and optimize and tweak as necessary.

·        Collaborate with other team members and stakeholders.

·        Proficiency with SQL and its variation among popular databases

·        Skilled at optimizing large complicated SQL statements

·        Capable of configuring popular database engines and orchestrating clusters as necessary

·        Ability to plan resource requirements from high level specifications

·        Good communication skills

Business Intelligence Developer (Fast track)

Data Analyst – Internship/Entry Level

·        Provides plan with data, reporting and analyses that enable data driven decision making.

·        Provides summary analyses in written and oral presentation settings.

·        Builds database from scratch. And prepares complex presentations.

·        Develops system test cases and documents results, researches system issues and documents findings.

·        Bachelor’s degree in Science, Technology, Engineering or Mathematics

·        Ability to translate business requirements into non-technical, lay terms

·        Understanding of addressing and metadata standards

·        High-level written and verbal communication skills

Junior Data Analyst

·        Managing master data, including creation, updates, and deletion.

·        Managing users and user roles.

·        Provide quality assurance of imported data, working with quality assurance analyst if necessary.

·        Commissioning and decommissioning of data sets.

·        Processing confidential data and information according to guidelines.

·        Helping develop reports and analysis.

·        Managing and designing the reporting environment, including data sources, security, and metadata.

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

·        Supporting initiatives for data integrity and normalization.

·        Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.

·        Generating reports from single or multiple systems.

·        Troubleshooting the reporting database environment and reports.

·        Evaluating changes and updates to source production systems.

·        Training end users on new reports and dashboards.

·        Providing technical expertise on data storage structures, data mining, and data cleansing.

·        Bachelor’s degree in Science, Technology, Engineering or Mathematics

·        1-3 years of work experience as a data analyst or in related field is preferred

·        Ability to work with stakeholders to assess potential risks.

·        Ability to analyze existing tools and databases and provide software solution recommendations.

·        Ability to translate business requirements into non-technical, lay terms.

·        High-level experience in methodologies and processes for managing large scale databases.

·        Demonstrated experience in handling large data sets and relational databases.

·        Understanding of addressing and metadata standards.

·        High-level written and verbal communication skills.