View Our Website View All Jobs

Senior SQL Server Developer

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.

Job Summary:

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

Qualifications:

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

 

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, .docx, .odt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

150
Human Check*