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 is responsible for developing and maintaining data sources and dashboards, ensuring high performance and reliability across both front-end and back-end systems. This role requires collaboration with cross-functional teams to deliver secure and efficient analytics applications, leveraging scripting languages and dashboard design tools. The ideal candidate will have a strong background in database development, dimensional data modeling, and analytics design principles.

Responsibilities

• Develop and maintain data sources and dashboards across both the front-end and back-end.
• Build and optimize data structures while ensuring data integrity and system architecture.
• Implement and optimize database architectures for secure and efficient data storage and retrieval.
• Retrieve and shape data using scripting languages like SQL, Power M Query, and DAX.
• Develop responsive and user-friendly dashboards using analytics software design tools like Power BI Desktop.
• Control data access within a multi-tenant analytics architecture through Row-Level Security.
• Collaborate with developers, product owners, and QA engineers to implement feature requirements.
• Ensure smooth integration between front-end and back-end systems.
• Optimize front-end and back-end scripts for performance, scalability, and security.
• Monitor and troubleshoot system performance, identifying bottlenecks and implementing solutions.
• Conduct thorough testing of data components and coordinate deployment efforts with DevOps.
• Leverage Generative AI tools to streamline development processes and improve application functionality.

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 and attention to detail.
• Experience working in agile development environments.

Nice-to-haves

• Experience with Generative AI tools to enhance development workflows.

Benefits

• Bonus eligibility as part of the total compensation package.