BI/ ETL Developer
Posted on :
10-11-2022
Employer Active
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Posted on :
10-11-2022
Job Description
100% Remote- all contractors will need to be onsite for the first day
Contract Position
BI/ETL Developer to:
- Design database structures, enforce good database practices, create SQL Server Data Tools deployment packages (DACPAC), create and deploy SSIS packages, improve monitoring capability error logging and error recovery capability of ETL jobs, develop reports. Knowledge and experience working with an operational DBA team will be helpful.
- Develop database objects such as tables, views, common table expressions, dynamic SQL, foreign key constraints, and stored procedures.
- Designs logical and physical databases (OLAP and OLTP) or review description of changes to database design.
- Perform SQL query performance tuning, which may include index recommendations or hardware configuration considerations, in addition to query and database design
- Interview and collaborate with non-technical business users to collect requirements
- Proactively address technical production issues
Qualifications:
Experience as a Microsoft SQL Server Developer, Data Warehouse Developer is required
Experience with developing and supporting SSIS and SSRS is required
Experience with Azure DevOps pipelines is required
Knowledge of database standards such as, object definition and naming, T-SQL best practices, etc.
Knowledge of data warehouse design (Kimball and/or Inmon), OLAP and OLTP systems is a plus
Experience with large data sets is desired
Experience with Cognos 10.2 or higher and Framework Manager is a plus
Experience as a Microsoft SQL Server Developer, Data Warehouse Developer is required Experience with developing and supporting SSIS and SSRS is required Experience with Azure DevOps pipelines is required Knowledge of database standards such as, object definition and naming, T-SQL best practices, etc. Knowledge of data warehouse design (Kimball and/or Inmon), OLAP and OLTP systems is a plus Experience with large data sets is desired Experience with Cognos 10.2 or higher and Framework Manager is a plus
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
