The Community Preservation-posted 3 months ago
$88,000 - $110,000/Yr
Full-time • Mid Level
Hybrid • Ny, NY
101-250 employees
Credit Intermediation and Related Activities

As a Power BI & SQL Programmer, you play a key role in supporting and enhancing CPC's Microsoft Power BI environment and Microsoft SQL Server database systems within an Azure environment. You're responsible for the full lifecycle of report and database development-including SQL code creation, report building, testing, deployment, upgrades, and ongoing maintenance. Your day-to-day includes monitoring Power BI operations, creating and maintaining reporting tables, and ensuring optimal report performance. You bring advanced SQL programming skills to the table, writing complex queries, optimizing performance, and developing stored procedures and functions. You also implement both temporary and permanent bug fixes to maintain system reliability and data accuracy. This hands-on technical role is ideal if you thrive in a fast-paced environment and enjoy turning data into meaningful visualizations through Power BI dashboards and Paginated Reports that drive strategic decision-making.

  • Develop, implement and optimize stored procedures and functions using T-SQL
  • Build appropriate and useful database tables and views
  • Analyze existing SQL queries for performance improvements
  • Develop procedures and scripts for data migration
  • Create optimized datasets for Power BI and setup refresh schedules
  • Build reports using Power BI Paginated Reports and create Power BI dashboards
  • Build workflows for power automate to save reports as files on schedule
  • Provide capacity for off-hour code deployment and emergency support for production issues on rare occasions as necessary.
  • Bachelor's degree in Computer Science, Information Systems, or a related discipline required
  • Minimum of 3+ years of dedicated experience with SQL programming Microsoft SQL Server in an enterprise environment
  • Minimum of 3+ years of experience on Power BI building Paginated Reports and Power BI dashboards
  • Strong written and verbal communication.
  • Experience with PowerShell and Python a plus.
  • Knowledge of windows platforms, security concepts, Active Directory Group Policy preferred.
  • Competitive compensation
  • 401(k) retirement plans with employer match
  • Medical, dental, and vision benefits for employees and their dependents
  • Commuter benefits
  • PTO for vacation, personal days, sick leave, holidays, jury duty, bereavement, parental leave, and disability
  • Tuition assistance program
  • Two 'work from anywhere' weeks per year
  • Summer Fridays
  • Collaborative working spaces
  • Service days to support our communities
  • Employee development and engagement events
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service