Data Warehouse Developer
Job ID : 35077
Job Title : Data Warehouse Developer
Location : Chicago, IL
Comapny Name : codesbright
Job Type : Full-Time, Part-Time, Contract, Training
Industry : Information Technology
Salary : $85000 - $95000 per year
Work Authorization : ["OPT","CPT","Entry Level","F1","H4","L1","H1 Visa","TN Permit Holder","Green Card Holder","Canadian Citizen","All EAD","US Citizen"]
No. of Positions : I have ongoing need to fill this role
Posted on : 10-16-2023
Required Skills : Unit Testing, Debugging, Data Flow Diagramming.
Benefits : Medical Insurance, Dental Insurance, Vision Insurance, 401K, Life Insurance
Job Description :
Qualifications:
- Bachelor’s Degree in Computer Science.
- 1+ years of Insurance and/or Commercial Auto Insurance experience preferred.
- 2+ years of experience in Microsoft SQL Server development, Microsoft SSAS, SSRS, and SSIS development.
- Data warehouse development, implementation and operation of Star schema, Relational and Dimensional model, Cube development and Analytics; Experience building and maintaining reports - SSRS, Excel-based, Power BI.
Responsiblties:
- Develop and maintain Oracle PL/SQL packages and scripts to maintain daily operation of data loading from servers and ETL process.
- Develop and maintain reports and daily data feeds to other city agencies.
- Monitor and maintain real-time and overnight data processing schedules.
- Understanding existing ETL Workflows. Modifying/re-architect ETL workflows.
- Develop data models and ER diagrams for existing and new databases.
- Design, develop, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
- Work with the business users and internal teams in designing and delivering correct, high-quality data.
- Provide technical support and production support to all the data warehouse projects.
Key Skills:
- Data Marts.
- Cubes.
- ETL.
- Quality Assurance/Quality Control.
- Software Development Lifecycle Management.
- Unit Testing.
- Debugging.
- Data Flow Diagramming.
Company Details :
Company Information hidden please Login to view details