Software and Data Engineer

Gridiron IT is seeking a Software and Data Engineer to support a federal program in Washington, DC.
Role Description:
We are implementing a data and analytics solution built on Snowflake and Power BI. The primary source of the data is Microsoft Dataverse via Azure Data Lake Storage Gen2. We are seeking a Software and Data Engineer to work as part of a small team that will be designing and implementing the end-to-end functionality needed, primarily focused on the non-visual (i.e., Power BI presentation) requirements. You ll be working in a collaborative environment with a constantly changing understanding of requirements. You should be prepared to pick-up whatever needs to be done and approach it with a sense of urgency while delivering quality production-ready solutions.
Core Tasks:
Design, implementation, and testing of data transformation code using SQL.
Develop process and scripts using a language such as Python or PowerShell to support data and file operations.
Create and maintain a security model to secure access to a database.
Implement build and release pipelines to automate instantaneously
Technical Skills (Order of Importance):
SQL Development
Python or PowerShell Development
Creation and execution of unit tests for SQL code
Data model and data warehousing concepts
Snowflake
Git source control (clone, branch, commit, push, etc.)
Build and release pipeline development using Azure DevOps or GitHub Enterprise
Power BI (or similar tool such as Tableau) is helpful