- Analysis skills
- Azure
- SQL
- SSIS
- PowerShell
Overview:
Summary:
The senior database developer will be in a unique position to work directly with business users and directors to understand business problems, design solutions, and develop processes and tools in the data warehouse to achieve those solutions. He/she will build out the data environment to provide valuable business solutions to multiple departments across the company. SMC is looking to significantly improve processes and technologies, and the senior database developer will be critical to that growth and improvement.
Responsibilities:
Primary Duties:
Build out the SMC data warehouse with efficiency, high data integrity, and optimal usefulness to business users
Work directly with business analysts and directors to develop solutions and communicate to ensure development meets expectations.
Work directly with outside vendors to build data integrations and file transfer processes, utilizing encryption technologies
Assist in transitioning the data environment to Azure cloud services
Build ETL processes utilizing SSIS, PowerShell, Python, C#, and other tools
Utilize SQL views, stored procedures, functions, triggers, and other utilities and tools
Work with business users to promote best practices for queries and data consumption
Education & Experience:
STEM or business degree preferred
Must have both strong analytical and communication skills
Must be able to handle and prioritize simultaneous tasks from multiple departments
Minimum three (3) years in IT, analytics, or related field
Schedule:
This position is full-time, typical hours are 8-5. Some travel may be required.
INDHP