Careerlink Login
Back to Search New Search

Data Warehouse Developer

Coverys Omaha, NE
Save

Job Description

The Data Warehouse Developer is responsible for designing, developing, maintaining, monitoring and extending the data warehouse and analytics architecture to meet the enterprise’s business analysis and reporting needs.  He/she partners with architects and business units to fashion out the technical vision for applications in the Enterprise Data Warehouse.

 

Position Purpose & Objective / Focus

The job responsibilities of the Data Warehouse Developer include assisting in the gathering of business requirements and creating architectural designs. It involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from different source systems.

The Data Warehouse Developer will provide support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other suitable source systems.

He/she will be part of the team to review, analyze, modify, and create ETLs, utilizing Talend and SSIS, testing, debugging, integration and implementation processes. His/her tasks will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

This position involves the delivering of data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how.

 

Essential Duties & Responsibilities

  • Handles complex duties within the database warehousing function
  • Provides analytical support and consultation on projects to ensure appropriate design, implementation, testing, and documentation
  • Develops and maintains an enterprise data warehouse system and corresponding data marts
  • Ensures quality of data through the configuration and audit of the data warehouse
  • Troubleshoots and adjusts existing data warehouse applications
  • Assists in establishing development standards
  • Researches and assesses new data warehouse applications
  • Mentors and guides less experienced team members.
  • Provides support and consultation to ensure system and business requirements are documented and understood during the design and development phase

 

Education, Requirements & Competencies

  • Bachelor’s degree in an analytical related field, including information technology, science, or engineering discipline.
  • Minimum 5 years' business intelligence / data warehouse (BI/DW) development experience; Kimball data warehousing methodology preferred; delivering solutions for the insurance industry is a plus.
  • Minimum 5 years' experience using SQL Server 2012 or higher.  Experience with Snowflake Data Warehouse and SnowSQL is preferred.
  • Minimum 3 years' experience Talend Studio or Microsoft SQL Server Integration Services (SSIS) 2008R2 or higher is preferred.
  • Minimum 3 years' experience with SSRS and SSAS development, dimensional models, SQL, views and stored procedure development. Experience can be concurrent. 
  • Mature self-starter and independent individual with ability to work with minimal supervision.
  • Strong analytical, problem solving, and conceptual skills with ability to work across business areas.
  • Strong interpersonal skills with the ability to develop rapport with team members and business partners; a team player.
  • Strong verbal and written communication skills, with an ability to express business concepts in technical terms, and complex technical solutions in business terms.
  • Team focused, with recognition that there are multiple right answers and collaboration leads to solutions that build acceptance and support within the team and with business partners
  • All candidates must be eligible to work in the US without sponsorship or restriction.

 

Coverys is an equal-opportunity employer. Coverys’ job openings are open to all without regard to race, color, national origin, gender, gender identity, religion, age, height, weight, disability, political beliefs, sexual orientation, marital status, family status, or veteran status.

Job Details

Date Posted March 6, 2020
Date Closes April 5, 2020
Address 11605 Miracle Hills Drive
Located In Omaha, NE
Job Type Full-time Employee
Hours 37.5 hours per week
SOC Category 15-1081.00 Network Systems and Data Communications Analysts
Zipcode 68154
Name Coverys
Address 11605 Miracle Hills Dr Suite 200
City, State and Zip Omaha, NE 68154-4467

This job offers the following benefits

  • 401(k) Retirement Savings Plan
  • College Savings Plan
  • Dependent-Care Spending Accounts
  • Flexible Spending Accounts
  • Health-Care Spending Accounts
  • Accidental Death and Dismemberment
  • Dental
  • Employee Assistance Program (EAP)
  • Life Insurance
  • Long-Term Disability
  • Maternity / Paternity / Family Leave
  • Medical
  • Prescription Drug Plan
  • Salary Continuation
  • Short-Term Disability
  • Vision
  • Voluntary Life Insurance
  • Bereavement Pay
  • Employee Referral Program
  • Paid Holidays
  • Paid Vacations
  • Sick Leave
  • Tuition Reimbursement
  • Bonus Plan
  • Merit Increases

This job requires the following skills

  • Data Warehouse
  • Database / Data Warehousing
  • Database Analyst
  • Database Creation
  • Database Security
  • Microsoft SQL Server
  • Microsoft SQL Server Integration Services

Course(s) relevant to the skills listed for this position

At a Glance
Enjoy these benefits
  • 401(k) Retirement Savings Plan
  • College Savings Plan
  • Dependent-Care Spending Accounts
  • Flexible Spending Accounts
  • Health-Care Spending Accounts
  • And More ...
Location