This role will support existing SQL databases, SSIS package scheduling and automation to ensure accurate and timely transfer of data. Candidate should become familiar with business requirements and translate them into SQL/SSIS development work for both new and existing functionality.

SQL

• Query and View Creation / Troubleshooting / Optimization (SQL, DAX)
• Stored Procedure Creation / Troubleshooting / Optimization
• Automation Jobs Scheduling and Maintenance
• Performance testing and monitoring
• Ability to review existing queries, views, and stored procedures and quickly understand their purpose
• Documentation of interdependencies and impact analysis

SSIS / Visual Studio

• Data Flow Task (DFT) creation / maintenance / troubleshooting
• Familiar with creating connectors for various sources (DAX, OLE DB, Excel, SharePoint, etc.)
• Check-In process, promoting changes to Git Hub
• Error troubleshooting and resolution

Visualizations (nice to have, but not required)

• Tableau
• Power BI
• Upkeep / refresh of existing dashboards
• Changes to existing visualizations

Position is on-site (Spring, TX). his is onsite only.