BI Developer

Censis - Franklin, TN

Full-time - Mid Level

Franklin, TN

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Business Intelligence Developer will be responsible for developing and maintaining data sources and dashboards across both the front-end and back-end. This role requires proficiency in multiple scripting languages as well as a solid understanding of dashboard design software tools. The ideal candidate will collaborate with cross-functional teams to ensure high-quality, secure, and performant analytics applications, with a strong knowledge of dimensional data modeling, databases, and analytics design principles.

Responsibilities

• Develop and maintain data sources and dashboards across both the front-end and back-end, ensuring high performance, scalability, and reliability.
• Build and optimize data structures while ensuring the integrity of the data and system architecture.
• Implement and optimize database architectures, ensuring secure and efficient data storage and retrieval.
• Retrieve and shape data and construct efficient calculations using scripting languages like SQL, Power M Query, and DAX.
• Develop responsive, user-friendly, insightful dashboards using analytics software design tools like Power BI Desktop.
• Control data access within a multi-tenant analytics architecture through features like Row-Level Security.
• Work closely with developers, product owners, and QA engineers to implement feature requirements and solve complex development challenges.
• Ensure smooth integration between front-end and back-end systems, leveraging best practices in analytics development.
• Optimize both front-end and back-end scripts for performance, scalability, and security.
• Ensure cross-browser and cross-device compatibility for all dashboard applications.
• Monitor and troubleshoot system performance, identifying bottlenecks and implementing solutions.
• Conduct thorough testing of both front-end and back-end data components.
• Coordinate deployment efforts with DevOps and ensure that updates are efficiently rolled out to production environments.
• Use Bitbucket for version control and manage code repositories.
• Leverage Generative AI tools to streamline development processes and improve the functionality and efficiency of applications.

Requirements

• Bachelor's or Master's degree in Data Analytics, Computer Science, or a related field.
• 5+ years of experience in database development and dimensional data modeling.
• 3+ years of experience with dashboard and analytics development.
• Proficiency in data scripting languages including SQL, Power M Query, and DAX.
• Strong knowledge of database management systems (e.g., MySQL, SQL Server).
• Experience with SaaS development and embedded analytics architectures.
• Knowledge of cloud platforms and microservices architecture (e.g., AWS, Azure, Power BI Service).
• Experience with version control systems like Bitbucket.
• Strong problem-solving skills, attention to detail, and ability to manage multiple tasks and projects simultaneously.
• Experience working in agile development environments.
• Excellent communication and collaboration skills.

Nice-to-haves

• Experience with Generative AI tools to enhance development workflows.

Benefits

• This position is also eligible for bonus as part of the total compensation package.