Data Warehouse Developer

About Our Opportunity

Our Data Warehouse developer is responsible for developing multi-dimensional data models to support analytics and reporting. Coordinates with departmental analysts and enterprise stakeholders to build and curate a collection of data objects that allow business units to optimize delivery via self service reporting, dashboards, and analytics. 

How You Will Spend Your Time

• Designing, developing and modifying multidimensional database structures in support of reporting and analytics. 
• Maintaining data lineage through source-to-target mapping documentation and documenting rules and procedures to transform, process and load data into the data warehouse and data marts.
• Analyzing data quality concerns in the data warehouse in collaboration with application and business process owners.
• Empowering business users by building and maintaining a user-friendly self-service analytics platform.
• Optimizing data models and query performance to maintain up time and agreed upon data refresh timelines.
• Collaborating with business stakeholders to identify data needs and translate them into actionable analytic solutions.
• Adhering to SQL coding standards alongside a healthy and robust peer review process.

Minimum Education & Experience

Bachelor's Degree (or equivalent relevant work experience) in computer science, data sciences or related field. 4 years relevant work experience building, deploying, and supporting Enterprise Data Warehouse capabilities.

Demonstrated experiences typically includes:

• Providing clean, transformed data ready for analysis to other areas in collaboration with our data warehouse architect. 
• Applying software engineering best practices to analytics code (e.g., Version control, testing, continuous integration). 
• Maintaining data documentation and definitions. 

Mental & Physical Requirements

While engaged in this position, team members will routinely sit, use hands for tasks, and communicate orally. Standing or walking is frequently required, while occasional demands include reaching with hands and arms, and lifting or moving up to ten pounds. Vision requirements encompass close and distance vision. The work environment typically has a moderate noise level. This role may entail a blend of mental and physical capabilities, requiring strong mental acuity, problem-solving skills, and occasional physical tasks such as standing, lifting, or extended computer usage. Some roles may require physical or mental requirements related to driving, such as a valid driver's license, and the ability to drive a long-distance. Reasonable accommodations will be considered for individuals as requested.