Ascendion Group - Miami, FL
posted 2 months ago
About Ascendion: Ascendion is a full-service digital engineering solutions company that specializes in creating and managing software platforms and products designed to drive growth and deliver engaging experiences for both consumers and employees. With a workforce of over 6,000 professionals, Ascendion operates globally, providing engineering, cloud, data, experience design, and talent solutions that accelerate transformation for enterprise clients. The company is headquartered in New Jersey and prides itself on its unique culture that fosters opportunity, inclusion, and partnership. Ascendion is committed to engineering the next generation of technology, empowering its employees to build innovative solutions for leading brands and tackle complex challenges while continuously learning and developing their skills. About the Role: The BI Fullstack Developer/Engineer position requires proven experience in Business Intelligence (BI) full-stack development, particularly with a strong background in SQL Server Reporting Services (SSRS) report development and Microsoft Business Intelligence (MSBI). The ideal candidate will possess in-depth knowledge of SQL Server and Snowflake, including their syntax, data structures, and query optimization techniques. Proficiency in scripting languages such as Python and PowerShell is essential for automation and data manipulation tasks. The role demands strong SQL skills for developing, tuning, and debugging complex SQL applications, along with excellent analytical and problem-solving abilities to address migration challenges effectively. The BI Developer will work collaboratively within a team environment, engaging with stakeholders to manage client expectations and meet project deadlines in an agile setting. Responsibilities include hands-on work in data analytics, cloud computing, data warehousing, and data modeling. The candidate will be responsible for converting embedded T-SQL scripts within SSRS reports to Snowflake-compatible syntax, repointing database connections, creating source-to-target mapping documentation, and rigorously testing migrated reports to ensure business logic preservation. Additionally, the role involves maintaining UI consistency and applying best practices for query optimization to enhance report performance. The successful candidate will also utilize Ascendion's A.AVA-Insights Governance accelerator to streamline the migration process, ensuring a smooth transition to Snowflake.