Will initially be mostly work from home, but some trips into the Dallas office are expected in the near future, and will likely be 3-4 days onsite by early next year.
Required Skills:
8+ years of SQL Development experience
5+ years of ETL development experience (SSIS or similar)
Strong Data Modeling experience
Proficient with Source control tools
Ability to be highly productive working remotely with little oversight
Proficient working in an Agile environment
Preferred Skills:
Strong T-SQL including Unit testing experience
Alteryx, Tableau, or similar
BIML experience
C# or Web API experience related to building SSIS solutions
OLAP or Tabular Data Models
Service Broker or other message queue experience specifically building SSIS solutions around them
Responsibilities:
Azure Data development for Data Hub and Data warehouse environments. The tasks performed include working on new development, bugs, enhancements, troubleshooting activities, configuring environments, suggesting process improvements, and completing documentation.
Provide development using Azure Synapse, Data Factory, Azure SQL tables as well as T-SQL, SSIS, SSAS, SSRS, and SQL Server and associated skillsets. Will also likely use Source Control tools, C#, Alteryx/Tableau experience on an as needed basis.
Design, write code, debug, perform system and applications testing, and support the operations team with builds to QA and production release in the Data Hub and Data warehouse environments.
Unit test functionality developed, check against business requirements and adhere to guidelines and best practices.