Helm360 | Paid Bootcamp- STEM Entry Level Data Analyst and Visualization | Beaumont, TX | United States | BigDataKB.com | 2023-01-28

Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE

 

Job Location: Beaumont, TX

Job Detail:

Job Description

** The job descriptions will vary depending on the individual project but here are the primary roles you could be working on after bootcamp **

Descriptions of some of them: **

BigDataKB.com Jyotish
BigDataKB.com Jyotish - Career & Life Prediction

-SQL Developer

**Responsibilities

  • Help write and optimize in-application SQL statements.
  • Ensure performance, security, and availability of databases.
  • Prepare documentation 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.

**Qualifications

  • BS or MS of a degree in Computer Science, Information Technology, Engineering or a related field is required
  • 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

  • Maintain, support, and enhance the business intelligence data backend, including data warehouses and data lakes.
  • Build interfaces between the business intelligence systems and other colleges’ information systems to maintain a timely and accurate integration of data.
  • Collaborate and work with data analysts in various departments to ensure that data meets their reporting and analysis need.
  • Provide technical guidance for design and implementation of data governance systems and policy.
  • Work extensively towards SQL Server development in writing core TSQL scripts to implement complex business logic.
  • Develop SSIS packages to implement complex ETL strategies as a part of business requirements for the population of dimensional data structures.
  • Work on creating SSAS cubes and various cube objects such as KPIs (Key Performance Indicators), calculated members, attribute hierarchies, and perspectives.
  • Design eye-catching reports with data from OLTP database, dimensional data structure and OLAP cubes for business reporting purposes.
  • Keep abreast of new business intelligence technologies

**Qualifications

  • BS or MS of a degree in Computer Science, Information Technology, Engineering or a related field is required
  • At least 1 year of experience using Microsoft SQL Server Database, SSIS, SSRS, SSAS is required
  • Experience with other relational databases, BI reporting and data discovery tools are preferred

-Data Analyst/Engineer

**Responsibilities:

  • 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.

**Requirements:

  • 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/Engineer

**Responsibilities:

  • 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 analyses.
  • 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 in data storage structures, data mining, and data cleansing.

**Requirements:

  • Bachelor’s degree in Science, Technology, Engineering or Mathematics
  • 1-3 years of work experience as a data analyst or in a related field is preferred
  • Ability to work with stakeholders to assess potential risks.
  • Ability to analyze existing tools and databases and provide a 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.

Due to the global situation, this internship will be remote until COVID-19.

Job Types: Full-time, Internship, Contract

Pay: $60,000.00 – $70,000.00 per year

COVID-19 considerations:
Due to COVID-19, the internship will be remote

Job Type: Full-time

Salary: $60,000.00 – $70,000.00 per year

Benefits:

  • Dental insurance
  • Health insurance
  • Life insurance
  • Professional development assistance
  • Relocation assistance
  • Vision insurance

Schedule:

  • 8 hour shift
  • No nights

Education:

  • Bachelor’s (Preferred)

Experience:

  • SQL: 1 year (Preferred)

Work Location: On the road

Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free

LEAVE A REPLY

Please enter your comment!
Please enter your name here