Offer summary

Qualifications:

Bachelor’s degree in computer science or related field, 5+ years of experience in Data Warehouse design using SQL Server or Oracle, Experience with Tableau and integrating data engineering assets, Strong critical thinking, communication, and collaboration skills.

Key responsabilities:

Design, code, test, and deploy new data warehouse features following standards

Collaborate with stakeholders for planned deployments and enhancements

Analyze query performance and troubleshoot production support issues

Perform data extraction, transformation, technical analysis, and integrations

Job description

Job Summary
The Data Warehouse Engineer plays a critical role in building and supporting Enterprise Data Warehouse to deliver strategic business value to the organization. The Data Warehouse Engineer is responsible for designing and developing enterprise applications utilizing primary technologies such as SQLServer, Bigdata, and moving from on premise to cloud infrastructure. This is a collaborative position that will partner with both technical and non-technical colleagues to support growth strategy, innovative mindset, and commitment to quality.

Responsibilities

Design, code, test, and deploy new data warehouse features.
Ensure that the established standards are followed for application architecture, development, documentation and deployment.
Actively participate in code walkthroughs/inspections to ensure consistency and quality.
Follow the established software development methodology
Collaborate with stakeholders and other departments to plan and deploy new data warehouse releases or product enhancements.
Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries.
Troubleshoot production support issues in the application environments.
Extract data from disparate sources and transform into internal formats for loading into our platform.
Perform technical analysis and requirements definition with our partners on service integrations.
Travel requirements: None
Perform other duties and responsibilities as required, assigned, or requested.

Qualifications

Bachelor’s degree in computer science or related technical field
At least 5 years of experience with Data Warehouse design and development of data structures and ETL processes in MS SQL Server or Oracle environment
At least 2 years of experience with Tableau solution development, and integration with existing architecture and data engineering assets.
Experience with architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems is a big plus
Understanding of quality assurance and data quality principals as applied to an ETL architecture is a plus
Critical thinking abilities to take complex, ambiguous, abstract requirements and break them into smaller components, patterns, views and features
Strong ability to communicate technical and data concepts to non-technical audiences, and business concepts to technical audiences
Ability to collaborate with other team members in the execution of large-scale projects

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

Required profile