Senior Business Intelligence Developer

At Ascensus, technology is more than just a solution. It powers the business that helps millions of people save for what matters—retirement, education, and healthcare. Our technology experts tackle exciting challenges in collaborative teams, but work in an environment where individual and career development is always valued. Technology associates leverage their talents and passion, building new and innovative platforms, creating programs founded in automation in agile frameworks, and driving existing and new markets—all of which supports the rapid growth of a dynamic industry leader.

Section 1: Position Summary

As a Senior Business Intelligence (BI) Developer at Ascensus, you will be working in a high-energy team, using the best engineering practices in the industry today (e.g., unit testing, source control, continuous integration, automation, design patterns). Passion for all aspects of software development is a critical. We are building teams that are empowered to solve the business needs by having a rapid development and deployment pipeline with a focus on automation and releasing software. You will support and receive direction and guidance from the BI Architect and you will provide guidance and direction to BI Developers in the Ascensus Enterprise Information Management (EIM) team.

Section 2: Job Functions, Essential Duties and Responsibilities

• Drive business decisions by providing quantitative and qualitative data analysis and reporting of patterns, insights and trends to decision makers
• BI Design and Development
  • Apply standards and best practices for implementing Ascensus BI tools in support of the EIM vision and reference architecture
  • Assist with EIM project definition and planning
  • Conduct data analysis in support of analytic solutions
  • Create ad hoc reporting solutions and dashboards
  • Capture, develop and document data definitions
  • Ensure compliance with deliverable reporting requirements by performing data quality audits and analysis
  • Implement package deployments and troubleshoot package issues
  • Modify, install and prepare technical documentation for BI applications
  • Create and maintain BI documentation for every System Development Life Cycle (SDLC) phase
  • Participate in creating long term BI application support model.
• Collect, aggregate and analyze data from multiple internal and external sources
• Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients.
• Apply standards and best practices for implementing Ascensus BI tools in support of the EIM vision and reference architecture
• BI Analysis
  • Drive business decisions by providing quantitative and qualitative data analysis and reporting of patterns, insights and trends to decision makers
  • Collect, aggregate and analyze data from multiple internal and external sources
  • Produce actionable reports that show key performance indicators
  • Provide analytics and reporting solutions using metrics across multiple business areas
• Assist with EIM project definition and planning
• Implement package deployments and troubleshoot package issues
• Ascensus Information Security
  • Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients.
  • Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always® should be visible in your actions on a day to day basis showing your support of our organizational culture.
• Conduct data analysis in support of analytic solutions
• Ensure compliance with deliverable reporting requirements by performing data quality audits and analysis
• Participate in creating long term BI application support model.
• Create and maintain BI documentation for every System Development Life Cycle (SDLC) phase
• Produce actionable reports that show key performance indicators
• Provide analytics and reporting solutions using metrics across multiple business areas
• Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always® should be visible in your actions on a day to day basis showing your support of our organizational culture.
• Create ad hoc reporting solutions and dashboards
• Capture, develop and document data definitions
• Modify, install and prepare technical documentation for BI applications

Section 3: Experience, Skills, Knowledge Requirements

• Designing/Building tabular models using latest version of SSAS
• Excellent analytical skills
• Administration experience using Power BI
• Must have experience with DAX, Power BI dashboards
• Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents.
• Modeling experience
• • Excellent analytical skills
  • Excellent oral and written communication skills including active listening. Asking appropriate questions, clarifying information and writing clear, concise documents.
  • Must have experience with DAX, Power BI dashboards
  • Designing/Building tabular models using latest version of SSAS
  • Modeling experience
  • Administration experience using Power BI
  • SQL Server latest version
• SQL Server latest version

• SSRS reporting
• Experience with analytic platforms (data mining, predictive modeling) a plus
• 10+ years of relevant experience in business intelligence role, including data warehousing and business intelligence tools, techniques and technology
• Microsoft Certified Business Intelligence in the above required skills
• Experience with Microsoft SSIS
• Preferred knowledge, skills and abilities:
  • 10+ years of relevant experience in business intelligence role, including data warehousing and business intelligence tools, techniques and technology
  • Microsoft Certified Business Intelligence in the above required skills
  • Experience with Microsoft SSIS
  • SSRS reporting
  • Experience with relational databases: Sybase ASE, Oracle, MySQL and others a plus
  • Experience with analytic platforms (data mining, predictive modeling) a plus
• Experience with relational databases: Sybase ASE, Oracle, MySQL and others a plus

The national average salary range for this role is in base pay, $83k-200k exclusive of any bonuses and benefits. This base salary range represents the low and high end of the salary range for this position. Actual salary offered will vary and may be above or below the range based on various factors including but not limited to location, experience, performance, and internal pay alignment. We do not anticipate that candidates hired will begin at the top of the range however, from time to time, it may occur on a case-by-case basis. Other rewards and benefits may include: 401(k) match, Medical, Dental, Vision, Paid-Time-Off, etc. For more information, please visit careers.ascensus.com/#Benefits.