This resource will be working in performing, designing and implementing ETL solutions to/from SQL server, Dynamicsc CRM (CDS) and a multiplicity of external data sources including but not limited to Power Market Data, Weather Data, Market curves, usage data and telemetry.
The person executing in this position is expected to:
Master TSQL querying and SQL Server:
ETL functionality (SSIS and others)
Store procedure writing
SSRS report development and design
Resource must be capable of optimizing queries and using analysis tools to fine tune behavior.
Develop, maintain and deploy integration solutions to and from non robust systems (like screen scraping or unstructured data sources)
Exposure to unstructured data management tools is desirable (Like SnowFlake™)
Mastery on Power BI dashboard development and deploying
Basic SQL server administration (DBA), disaster recovery and optimization skills.
Familiarity with Azure™ data solutions including Azure SQL and Azure DataLake™
Familiarity with cloud-to-cloud disaster recovery (specifically Azure into Amazon – or similar)
Both Positions Require Fluent English and Spanish bilingual candidates.
Ability and willingness to travel when needed
Experience with Power-related commodities markets and data
Experience with brokerage model
Ability to work at odd schedules as frequently after-hours deployments or patches will be common ground.