Sr SQL Server Developer
Lime Energy is seeking a Sr SQL Server Developer to work in Business Intelligence. The ideal candidate will be resilient, flexible, understand the dynamics and challenges of an entrepreneurial business, and committed to growing with the company. Lime is a dynamic, fast-paced, demanding, fun and rewarding growing organization. The Business Intelligence Developer is an integral position and demands a highly collaborative approach, positive work ethic and attitude, as well as a high level of commitment. The Sr SQL Server Developer will apply their strong database skills and best practices to the design of current and future Lime Energy Platform Roadmaps.
The Sr SQL Server Developer is responsible for the development, management, and support of the BI data warehouse. This individual will assume ownership of existing processes and packages for the data warehouse and improve upon them as part of a larger effort to build a customer data platform. This includes ownership of data quality in the transformation process, defining quality assurance plans and rules. In addition, the individual, will work within a multi-disciplinary team and support and initiative to build a monitoring and management system for the overall business through the use of KPI’s and data visualization toolsets.
Job Duties & Responsibilities:
Design and implement and improve upon the processes that maintain the data warehouse
Work with senior team members and business stakeholders to understand requirements
Work with multiple technical disciplines, engineering, program design, marketing, sales and strategy and business operations and gain an understanding of how the business operates
Identify and document opportunities to streamline data management and provide feedback to the team and senior managers
Monitor and manage the quality of data in the data warehouse, provide feedback for improvements
Performs other related duties as assigned
Bachelor's degree in Computer Science, Mathematics, Statistics or similar field desired but not required. Experience and expertise will be valued higher than formal education.
Proficient in SQL Server, SQL Server Management Studio, SSIS development and deployment procedures.
Solid experience in the design, development, deployment and support of SSIS packages
Proficient developing SQL Objects: Stored Procedures, Functions, Views, triggers, indexes.
Experience working with complex SQL queries and large complex datasets
Strong knowledge of SQL Server Agent. Scheduling of jobs using dtxs files and thru the Integration Services Catalog
Strong knowledge of database admin tasks: SQL jobs maintenance and monitoring, troubleshooting failures of SSIS packages, database backups, database optimization, indexes, fragmentation
Solid understanding of SSRS and SSAS
Experience with Power BI or other visualization tools highly desired but not required
Basic hardware knowledge of laptops, desktops, servers
2+ years of related experience which demonstrates a skillset that includes the technical and collaborative soft skills
Very strong Microsoft Excel and Office tools knowledge and experience
Experience with one or more modern development languages highly desired (C#, Python, Java, etc)
Willingness to learn new tools, technologies and stays current with market trends