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: Chicago, IL
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: **
-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 Types: Full-time, Contract
Pay: $60,000.00 – $70,000.00 per year
Benefits:
- Dental insurance
- Health insurance
- Life insurance
- Professional development assistance
- Relocation assistance
- Vision insurance
Experience level:
- Under 1 year
Schedule:
- 8 hour shift
- Monday to Friday
- No weekends
Education:
- Bachelor’s (Preferred)
Experience:
- SQL: 1 year (Preferred)
Work Location: On the road
Submit CV To All Data Science Job Consultants Across United States For Free
