Data Warehouse Engineer

SUMMARY

Data Warehouse Engineer - Involved in the design, analysis, and development efforts for the Data Warehouse and Business Intelligence projects and resolves complex business problems. Includes modeling, building, and populating the Data Warehouse, as well as providing reporting capabilities.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Assesses business rules; performs source to target data mapping; designs, reviews, implements and optimizes ETL processes.
• Reviews project plans; develops and tests specifications; performs data analysis.
• Provides development support for existing systems; troubleshoots data and/or system issues, builds and extends toolsets.
• Creates and/or maintains batch jobs.
• Creates and maintains online systems and printed documentation.
• Provides data analysis and identifies data-related issues within the Data Warehouse environment, as well as sources systems as needed.
• Provides quality service satisfaction by possessing strong customer service skills.
• Creates and maintains the logical and physical dimensional data models.
• Works within an agile development methodology.
• Participates in peer code reviews.
• Provide feedback to junior data warehouse engineers.
• Effectively manage time by analyzing workload, assign priorities, and maintain focus on productive endeavors.
• Work with limited supervision to complete tasks assigned.
• Engage as a productive and positive member of the data warehouse team.
• Assists in managing projects and processes related to the data warehouse.
• Coaches and reviews work of lower-level data warehouse engineers.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

KNOWLEDGE, SKILLS AND ABILITIES

• Ability to read, analyze and interpret the most complex documents and to read and interpret data schemas, with emphasis on SQL Server Implementations.
• Ability to respond effectively to the most sensitive inquiries or complaints.
• Ability to prepare presentations using original or innovative style, techniques and make persuasive speeches and presentations on controversial or complex topics to top management, public groups and/or board of directors.
• Ability to apply advanced mathematical and statistical concepts to tasks such as frequency distributions, analysis of variance, correlation techniques, sampling theory and factor analysis.
• Ability to apply principles, logical or scientific thinking to a wide range of intellectual and practical problems.
• Ability to deal with a variety of abstract and concrete variables.

EDUCATION AND/OR EXPERIENCE

• Bachelor's Degree from four-year College or University in Computer Science or related technical field required or equivalent combination of education and experience
• 10 plus years experience in data engineering or data warehousing and/or a similar data developing role required
• Experience using Azure Data Factory, Microsoft SSIS, or other leading ETL tools preferred. Experience with Spark, Hadoop, or cloud technologies preferred

ABOUT BRIDGEVIEW

BridgeView is a talent and technology consulting company that helps business leaders build exceptional technology teams and deliver complex projects with confidence.

Since 2005, BridgeView's tenured recruiting team has built a vast network of niche technologists and executive leadership candidates to help our clients solve their most complex talent challenges. Paired with strategic consulting services, BridgeView further delivers project collaboration in the areas of people, process, and technology.

This blended approach allows clients to adjust in real-time to align with their budgets while receiving Big 5 expertise to meet their objectives.

BridgeView. Within Sight.

We are an equal opportunity employer and value diversity. All employment decisions are made due to qualifications, merit, and business need. The successful candidate’s starting salary will be determined based on permissible, non-discriminatory factors such as skills, experience, and geographic location.