Choreo is hiring a
Senior BI Developer in Worldwide

Summary

Choreo is seeking a Senior Business Intelligence Developer to work on their Technology team. The role involves designing, developing, delivering, and maintaining Microsoft tools and features, ensuring daily ETL processes run successfully, and building new PowerBI reporting. The Senior BI Developer will report to the Senior Director of Business Analytics and partner with the Chief Information Officer and Director of Informational Security on a day-to-day basis.

Requirements

• 5+ years experience designing developing business intelligence solutions using PowerBI or similar tool
• 5+ years experience architecting various data models, including relational and star schema
• 5+ years experience implementing various semantic models, including Tabular, Multidimensional, Security Models, Dimensional Structures, and hierarchies
• 5+ years experience developing queries and stored procedures using T-SQL, Python, and Data Analysis Expressions (DAX)
• Experience developing ETL solutions utilizing SSIS, Azure Data Factory, or other enterprise ETL/ELT tools
• Experience in utilizing Azure DevOps or TFS for issue tracking and Git for code versioning
• Familiar and experienced with Microsoft’s Technology EcoSystem (Azure, Dynamics365, Office365 and Power Platforms)
• Skilled in preparing and delivering documentation such as, but not limited to, business and functional requirements, data flow, logical, and physical diagrams
• Undergraduate Degree, preferably in Management Information Systems (MIS), Computer Science (CS) or Information Technology related field of study
• Minimum of 5 years in a corporate environment designing, developing and supporting enterprise information assets, with 3 years of experience in Financial Services/Wealth Management preferred
• Strong analytical skills and experience with the SDLC methodologies such as Waterfall and Agile
• Strong communication, presentation and interpersonal skills amongst key stakeholders
• Ability to work efficiently, effectively, and independently as well as in a team environment to see projects through to conclusion
• Excellent organizational skills with the ability to prioritize multiple tasks, projects, and assignments with the ability to float between multiple projects
• Adheres to industry best practices, quality, standards, framework, and approach for designing and deployment of enterprise digital and reporting assets

Responsibilities

• Design, develop, deliver, and maintain intuitive, engaging, and informative reporting visualization assets
• Design, develop, deliver, and maintain data architecture assets, deliverables, and documentation
• Stay current on all upcoming features and capabilities of relevant technology solutions
• Provide detailed documentation including guidance, training, and solution descriptions to business and technical stakeholders
• Conducts requirements analysis, documents technical specifications, and writes, reviews, and debugs ETL and PowerBI code
• Recommends revisions or enhancements based on user feedback
• Develops and maintains documentation, training, and user manuals for ETL solutions
• Provides support in the event of problems related to reporting results, and troubleshooting issues that arise with data warehouse processes

Benefits

• Competitive salary and bonus plan
• Competitive medical, dental, and vision plans
• Basic life and disability coverage
• 401(k) matching program
• Financial support for approved designations and courses
• Technical, leadership, sales training opportunities
• Unlimited, discretionary time off
• Paid parental leave