Job Details

s a Data warehouse architect, you will work on a client site to support the requirements,

design, and solution selection for management and financial data warehouse solutions. You will participate in and may lead requirements, design, and validation focus groups with crossfunctional client teams. You will be responsible for developing or contributing to meeting materials and documenting results and outputs. You will perform data analysis and data modelling for complex systems in a rapid paced client setting. Future phases may include designing and building ETL solutions to extract, cleanse, transform, and deliver data to a data warehouse, as well as identifying necessary integrations or messaging solutions between primary business systems.

The systems environment includes, but is not limited to, the following:

SAP (FI and MM)
Related and third-party financial analysis and modeling tools, including complex excelbased financial models
Sensor and telemetry data for renewable energy assets

Our expectations
Work within a team to develop requirements and design documentation for data warehouse solutions for clients
Collect and design data warehouse and ETL solutions using Microsoft and other technologies
Develop meeting materials and system documentation in conjunction with other team members
Participate in and lead, in whole or in part, client requirements and design focus group sessions
Develop short lists of candidate data warehouse solutions based on client requirements
Develop recommendations for solutions and participate in developing business case and implementation planning information, as needed
Perform other ad hoc duties as reasonably expected
Contribute to standards and process improvements
Strong client-facing and teamwork skills
Strong analytical skills and attention to detail
Ability to work independently and produce results at set milestones
Excellent written and verbal communication skills

Technical skills in the following:
Microsoft SQL Server 2012 and above
Microsoft SQL Server Integration Services
PostgreSQL
Strong SQL development skills
C#.NET, ASP.NET, or other traditional coding is a bonus

Experience
Extensive experience in the Microsoft BI Tool-stack on Data Warehousing projects
Hands-on experience in delivering data warehouse solutions
A strong database knowledge and experience, including maintenance, optimization, trouble-shooting
Bachelor’s degree in computer science or equivalent work experience
Minimum 7 years’ experience in a consulting or advanced technology environment
Familiarity and experience in energy solutions, especially renewable energy, a plus