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.
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.
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.