Business Intelligence Developer

The Business Intelligence (BI) Developer is responsible for designing, developing, and maintaining data-driven reporting solutions that support decision making across Cyntergy’s architecture, engineering, construction administration, and business operations teams. This role transforms complex, multi-source data into meaningful dashboards, reports, and visualizations that improve visibility into project performance, financial metrics, resource allocation, and overall operational efficiency.

The BI Developer works closely with leadership and department stakeholders to understand reporting needs and deliver scalable, accurate, and user-friendly analytics solutions that support strategic and day-to-day business decisions., * Design, develop, and maintain Business Intelligence dashboards, reports, and data visualizations to support firm-wide decision-making

• Extract, transform, and analyze data using SQL and other data querying tools
• Develop and maintain data models that ensure consistency, accuracy, and performance of reporting systems
• Collaborate with leadership and department managers to gather requirements and translate business needs into technical reporting solutions
• Support reporting needs related to project performance, workload planning, budgeting, forecasting, and operational metrics
• Identify opportunities to improve data workflows, reporting efficiency, and automation of recurring reporting processes
• Ensure data integrity across multiple systems and resolve discrepancies as needed
• Document reporting structures, data sources, and BI processes for internal use
• Provide ongoing support and enhancements to existing reports and dashboards as business needs evolve, The Business Intelligence Developer plays a critical role in advancing Cyntergy’s data capabilities by improving visibility into projects, people, and performance. This position enables leadership and teams to make more informed, efficient, and strategic decisions through reliable, accessible, and well-designed reporting systems.

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Business, or related field preferred
• 2-5+ years of experience in business intelligence, data analytics, or a related role

Technical Skills

• Strong proficiency in SQL and relational databases
• Experience with BI tools such as Power BI, Tableau, or similar platforms
• Strong Excel skills, including data analysis and reporting functions
• Experience working with data models and transforming raw data into structured reporting formats
• Familiarity with data warehousing concepts and ETL processes preferred

Preferred Experience

• Experience in architecture, engineering, construction, or professional services environment
• Understanding of project-based financials, resource planning, or workload tracking
• Experience integrating data from multiple business systems
• Smartsheet experience highly preferred

Core Competencies

• Strong analytical and problem-solving skills
• Attention to detail and commitment to data accuracy
• Ability to translate complex data into clear, actionable insights
• Strong communication skills with the ability to work across technical and non-technical teams
• Self-starter with the ability to manage multiple priorities and deadlines
• Collaborative mindset with a focus on supporting organizational goals