What are the responsibilities and job description for the IT Business Intelligence Analyst & Developer position at City of Groton?
Job Opportunity: IT Business Intelligence Analyst & Developer
Organization: City of Groton & Groton Utilities
Location: Groton, CT (On-site)
Salary Range: $117,000 – $127,000 (Commensurate with experience)
Position Type: Full-Time, Exempt
About the Role
Are you a highly skilled data professional who thrives at the intersection of analytics and backend development? The City of Groton and Groton Utilities are seeking a dynamic IT Business Intelligence Analyst & Developer to lead the full lifecycle of our business intelligence initiatives. In this critical hybrid role, you will do more than just pull data—you will design, architect, and develop the proprietary front-end and back-end applications that power our municipality and public utility. From forecasting operational trends to automating everyday tasks, your technical expertise will directly drive data-driven success for the community.
Key Responsibilities
- System Development: Design, architect, and develop proprietary front-end and back-end business applications, focusing on SQL-based structures and BI platforms like Power BI and MicroStrategy.
- Data Visualization & Reporting: Create high-impact dashboards, reports, and visualizations to support executive summary reporting and organization-wide analytics.
- Analytical Modeling: Perform advanced scenario modeling and forecasting for operational and financial planning.
- Automation: Define and develop innovative solutions to automate everyday tasks and enhance the performance of internal software tools.
- Stakeholder Collaboration: Work directly with internal stakeholders to translate complex business objectives and policy changes into practical, scalable technical specifications.
- Cyber & Data Security: Participate in maintaining stringent cyber policies and standards to ensure the protection of sensitive business and utility data.
Qualifications & Technical Skills
- Education: Bachelor’s degree in Computer Science, Business Analytics, Economics, Finance, or a related quantitative discipline (relevant experience may be considered in lieu of a degree).
- Experience: 3–5 years of hands-on experience in business intelligence and software development.
- Databases: Expert-level proficiency in SQL programming, relational database management, ETL processes, and dimensional data modeling.
- BI Platforms: Strong proficiency in Power BI and other enterprise platforms.
- Programming: Robust skills in C#, JavaScript, and CSS (familiarity with Python, R, or VBA/Macros is a plus).
- Tools: Experience utilizing Visual Studio, Git/Source Control, and Microsoft 365 (Power Automate, Power Apps, Azure Logic Apps).
- Note: Familiarity with governmental or public utility entities is highly preferred.
Why Join Groton Utilities?
Step into a critical role where your data insights and development expertise directly enhance the City of Groton's operations and public utility services. We offer a highly competitive salary range of $117,000 – $127,000 (based on experience), backed by the unparalleled stability and exceptional benefits of municipal employment.
We recognize that our team members are our greatest asset. We provide a robust benefits package designed to support our employees' overall well-being and future, including:
- Premier health, dental, and vision insurance coverage
- Generous paid time off (vacation, sick leave, and holidays)
- Substantial municipal retirement benefits
- A collaborative environment that values professional development
Please visit the City of Groton website for a detailed job description.
The City of Groton is an Equal Opportunity Employer. All successful candidates must successfully pass a national fingerprint-based records check in accordance with CJIS Security Policy.
Pay: $117,000.00 - $127,000.00 per year
Benefits:
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Professional development assistance
- Retirement plan
- Tuition reimbursement
Education:
- Bachelor's (Required)
Experience:
- Business intelligence: 3 years (Required)
- Software development: 3 years (Required)
- SQL Programming: 3 years (Required)
- Analytical thinking: 3 years (Required)
Work Location: In person
Salary : $117,000 - $127,000