The Community Solution Education System
Data Engineer
The Community Solution Education System, Chicago, Illinois, United States, 60290
Job Description:
Job Title:
Data Engineer
Department:
Information Technology
Job Purpose:
The Data Engineer role is critical in the process of implementing business intelligence solutions for the organization. This includes designing and developing data pipelines, warehouses, and integrations using best practices. The role will ensure the availability and accuracy of consumption and analysis by the organization. The data engineer will need to be familiar with key business applications and processes to assist in executing the organization’s data strategy in a scalable and reliable manner.
Position responsibilities include but are not limited to:
Design & develop standardized reports using SQL Server Reporting Services, TSQL queries, and Stored ProceduresCreate tables, stored procedures, functions, views, and triggers using SQL Server Management StudioPerformance tuning and optimizationCreate data pipelines utilizing ETL and ELT methods from various data sources.Create, maintain, and support data warehouses/martsReport creation and maintenanceAnalyze data to improve processes and assist with defining key metrics.Create and maintain clear documentation of development, processes, and data flows.Create and design dashboards using Power BI & TableauDevelopment of integrations and data pipelines between applicationsRequired Qualifications:
Knowledge and Skills:
Collaborate with business analysts, subject experts, and other team members to determine BI requirements and develop enterprise level solutionsSupport IT staff and business users in the development, usage and troubleshooting of database-driven applicationsRespond quickly to bug fixes and enhancement requestsWork on multiple projects concurrently.Knowledge of extracting data through API/web servicesExcellent analytical, written and verbal communication skillsKnowledge of data warehouse design patternsExperience in data engineering and integration using Azure servicesAdvanced knowledge of SQL BI Tools (SSRS, SSIS, SSAS)Education:
Bachelor's degree in computer science, information technology, or a related field
Experience:
7+ years experience with SSIS package development and SSRS report writingKnowledge of data warehouse design patternsAdvanced knowledge of SQL BI Tools (SSRS, SSIS, SSAS)Experience with a major cloud infrastructure and architecture provider (Azure, Google, AWS)Data warehouse/ Data Mart development experiencePython or R experience a plusKnowledge of extracting data through API/web servicesExperience in education industry a plusExperience with a major BI Platform (Power BI, Tableau, Looker)Working Conditions:
Ability to complete sedentary work for extended periods of time.Ability to operate office equipment including laptop, phone, etc.Compensation & Benefits:
This opportunity is budgeted at $100,000 - 105,000 base compensation. Additional compensation factors may impact total compensation. To learn more about our competitive benefits and additional rewards, including generous paid time-off, medical and dental insurance coverage, life and disability insurance, retirement plan with employer contribution, multiple flexible spending accounts, tuition reimbursement, click the link below.
Career Link
The Community Solution is an Equal Opportunity Employer.#J-18808-Ljbffr
Job Title:
Data Engineer
Department:
Information Technology
Job Purpose:
The Data Engineer role is critical in the process of implementing business intelligence solutions for the organization. This includes designing and developing data pipelines, warehouses, and integrations using best practices. The role will ensure the availability and accuracy of consumption and analysis by the organization. The data engineer will need to be familiar with key business applications and processes to assist in executing the organization’s data strategy in a scalable and reliable manner.
Position responsibilities include but are not limited to:
Design & develop standardized reports using SQL Server Reporting Services, TSQL queries, and Stored ProceduresCreate tables, stored procedures, functions, views, and triggers using SQL Server Management StudioPerformance tuning and optimizationCreate data pipelines utilizing ETL and ELT methods from various data sources.Create, maintain, and support data warehouses/martsReport creation and maintenanceAnalyze data to improve processes and assist with defining key metrics.Create and maintain clear documentation of development, processes, and data flows.Create and design dashboards using Power BI & TableauDevelopment of integrations and data pipelines between applicationsRequired Qualifications:
Knowledge and Skills:
Collaborate with business analysts, subject experts, and other team members to determine BI requirements and develop enterprise level solutionsSupport IT staff and business users in the development, usage and troubleshooting of database-driven applicationsRespond quickly to bug fixes and enhancement requestsWork on multiple projects concurrently.Knowledge of extracting data through API/web servicesExcellent analytical, written and verbal communication skillsKnowledge of data warehouse design patternsExperience in data engineering and integration using Azure servicesAdvanced knowledge of SQL BI Tools (SSRS, SSIS, SSAS)Education:
Bachelor's degree in computer science, information technology, or a related field
Experience:
7+ years experience with SSIS package development and SSRS report writingKnowledge of data warehouse design patternsAdvanced knowledge of SQL BI Tools (SSRS, SSIS, SSAS)Experience with a major cloud infrastructure and architecture provider (Azure, Google, AWS)Data warehouse/ Data Mart development experiencePython or R experience a plusKnowledge of extracting data through API/web servicesExperience in education industry a plusExperience with a major BI Platform (Power BI, Tableau, Looker)Working Conditions:
Ability to complete sedentary work for extended periods of time.Ability to operate office equipment including laptop, phone, etc.Compensation & Benefits:
This opportunity is budgeted at $100,000 - 105,000 base compensation. Additional compensation factors may impact total compensation. To learn more about our competitive benefits and additional rewards, including generous paid time-off, medical and dental insurance coverage, life and disability insurance, retirement plan with employer contribution, multiple flexible spending accounts, tuition reimbursement, click the link below.
Career Link
The Community Solution is an Equal Opportunity Employer.#J-18808-Ljbffr