IT Junior Business Intelligence Developer

Download Job Description


The Junior BI Developer will be part of a team tasked with supporting current financial applications, while continuing to push new technologies and infrastructure.  The successful candidate will have 1-3 years of experience in SQL development, basic SQL administration,  ETL/ELT development, and some front end BI experience (PowerBI, Tableau, etc).  This position is looking for candidates with interest and curiosity in a wide range of technologies, as you will be exposed to development opportunities across various life-cycles (Database, Integration, Reporting, Advanced Analytics).  The candidate will have direct interaction with end users, helping troubleshoot existing code/applications and building applications from scratch as requirements dictate.   The candidate will also have a direct hand in pushing the business forward as we dive into new future technologies.  


  • Troubleshoot existing SQL code.  Develop new SQL code to meet business requirements.
  • Create ETL/ELT integrations to support both custom applications/data warehouse
  • Support existing/Create Integration Services (SSIS) projects/packages.  Troubleshoot job failures develop appropriate solutions.  
  • Support existing/Create Reporting Services (SSRS) reports.  
  • Support existing Analysis Services (SSAS) instances.
  • Help users troubleshoot BI related issues.  Come up with unique solutions and implement them in a production environment.
  • Develop advanced SQL Queries for implementing application business logic using MS best practices
  • Query performance monitoring and tuning of databases and database server environments
  • Adherence to source control, version management, product release best practices
  • Develop Azure Data Factory pipelines.  Administer Data Factory processes as they go live
  • Development in Python for integration/reporting
  • Documentation of business/technical processes as needed


  • B.S. degree in an information systems discipline or comparable work experience
  • Development experience in SQL (T-SQL/PLSQL)
  • SSIS/Azure Data Factory experience
  • SSRS/PowerBI/Tableau development experience
  • Understanding of how to efficiently model data in both transactional/warehouse environments
  • Demonstrated experience and problem-solving skills to troubleshoot and resolve technical problems
  • Experience in an Agile environment with solid understanding of software development lifecycle
  • Ability to communicate effectively both verbally and in writing
  • Demonstrated ability to work independently in a deadline oriented environment


  • Azure Experience (Highly Desirable)
  • Python development experience (Highly Desirable)
  • Analysis Services (SSAS) experience (Tabular or Multidimensional)

AEW Capital Management is an affirmative action-equal opportunity employer.

Email Resume