Paid Bootcamp- STEM Entry Level Data Analyst and Visualization
Quick Apply Full-time 1 day ago Full Job Description 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:
-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 The job descriptions will vary depending on the individual project but here are the primary roles you could be working on after bootcamp -SQL Developer Quick Apply.
Estimated Salary: $20 to $28 per hour based on qualifications.
-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 The job descriptions will vary depending on the individual project but here are the primary roles you could be working on after bootcamp -SQL Developer Quick Apply.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
