Business Intelligence Developer

The Business Intelligence Developer is responsible for the analysis, development, implementation, and support of a variety of solutions based in the Microsoft BI tool set including SQL Server Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), and Power BI. This BI Developer will focus on designing, building, and maintaining metadata models, ETL packages, and OLAP cubes. This position is responsible for data reporting, converting business side requests into technical specs, and analyzing/improving existing reports and reporting systems. As an integral member of the IT team, this position is a key role in supporting business and internal IT goals and objectives. The position requires the use of design and technical skills while working closely with the Project Management Organization (PMO), end-users, senior management, related development teams, vendors, and other stakeholders to determine user requirements and solutions.

This is a hybrid position working out of our downtown Minneapolis office.

Duties and Responsibilities:

  1. Develop advanced BI applications using the Microsoft BI stack including SSAS, SSIS, SSRS, T-SQL/SPROCs as well as MDX
  2. Design extensions to our Data Warehouse systems and troubleshoot/resolve system issues
  3. Provide technical design recommendations on the data mart structures that support analytical applications
  4. Design functional specs for BI front end applications including dashboards and reports, considering appropriate data flow and capture
  5. Work closely with end-users in the identification and documentation of business requirements and potential BI solutions to help the user meet requirements; analyze such requirements and prepare specifications
  6. Work closely with the PMO to produce accurate delivery estimates and manage the transition from analysis through design and delivery
  7. Provide training and expertise to business users on utilizing SSAS cubes for their reporting needs
  8. Provide and own the technical details for implementation and maturing of BI solutions
  9. Work independently and with other team members on projects and support activities based on end-user needs, setting day-to-day priorities based on overall goals and direction given by the PMO
  10. Produce deliverables that conform to the company’s code standards
  11. Document solutions with quality technical documentation as well as detailed end user instruction as needed
  12. Keep current on industry trends and technology advancements by maintaining expertise in BI applications
  13. Participate in projects from design and planning through implementation and support
  14. Perform other related business duties assigned by immediate supervisor and/or other management as required

Experience and Necessary Skills:

  1. 5+ years of strong hands-on SQL coding experience for querying and data analysis
  2. 3+ years of report/dashboard design and development experience using the Microsoft BI stack
  3. 3+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers, and user defined functions
  4. 3+ years working knowledge of data and dimensional modeling in a data warehouse environment with OLAP cubes
  5. Strong analytical and quantitative skills required
  6. Comprehensive understanding of BI best practices, relational structures, dimensional data modeling, data warehouse and reporting techniques
  7. Proven ability to learn and adapt to new technologies
  8. Strong problem solving and analytical skills with ability to oversee various projects under deadlines
  9. Must be self-directed with strong verbal and written communication skills
  10. Experience in book publishing preferred

Experience with the following a plus:

  1. Power BI
  2. SharePoint Online
  3. Nintex Online

Tasks and Assignments

  1. SQL Server Reporting, Integration, and Analysis Services (SSRS, SSIS, SSAS)
  2. Familiarity with architecture styles/APIs (REST, RPC)
  3. Knowledge of .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
  4. Development using Visual Studio and Team Foundation Server

BS/BA degree in computer science or related field with coursework in at least two of the following: digital media, web design, computer programming, or equivalent coupled with relevant and progressive professional experience

It is the policy of Lerner Publishing Group to provide equal employment opportunities without regard to race, creed, color, religion, sex, mental or physical disability, age, national origin, marital status, sexual orientation, public assistance, or any other class protected under applicable law. Women, minorities, individuals with disabilities and veterans are encouraged to apply.


Please send resumes or any general employment inquires to:
Joyce Hutchinson
Lerner Publishing Group, Inc.
241 First Ave N
Minneapolis, MN 55401
FAX: 612-204-9208


← Press Room