The Senior Data Engineer is a full time, onsite position in our Lakewood, CO office. This position is responsible for database design, data analysis, ETL processes associated with daily business processes, integration and maintenance of enterprise applications. The Senior Data Engineer will also be responsible for general administration and support of application databases and database servers. This Senior Data Engineer will also have the opportunity to work with Entity framework to convert stored procedures to .NET C# entity framework modules.
What You Will Do in This Role
- Database design and modeling
- Development of ETL processes, in Microsoft Azure, related to the development and integration of enterprise applications
- Maintain the SQL Database DDL, DML, and permissions in a Visual Studio Database Project
- Setup, administration and operation of databases and database servers
- Develop stored procedures, views, and functions to support application functionality and reporting needs
- Maintain and Extend Entity framework ORM from existing SQL stored procedures.
- Collaborate as a member of the application development team
- Participate in business process analysis and requirements definition
- Provide database support and direction to other teams and team members
- Create and maintain data documentation and knowledge base articles
- Diagnose and troubleshoot database performance and scalability issues
- Evaluate and recommend automation based improvements
- Evaluate and make change recommendations of current Active Directory Roles and Users related to Azure DB’s
- Other duties as assigned
Required Experience, Skills & Abilities
- 10+ years of IT and business/industry work experience
- 10+ years of database development experience
- Advanced knowledge of Microsoft SQL Server
- Advanced DDL and DML experience
- Advanced knowledge of data backup, recovery, security, integrity
- Experience migrating logic from Stored Procedures to C# using Entity Framework
- Proficiency with database design and modeling
- Excellent analytical and communication skills
- Strong troubleshooting skills
- Ability to interface with internal customers at all levels of the organization
Preferred skills
- Setup, administration and operation of databases and database servers
- Ad Hoc report development
- Azure certifications
- Application development experience
- Application integration experience
- Experience deploying Azure SQL database changes via dacpac using Azure DevOps
...