IT Junior Business Intelligence Developer

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.  

RESPONSIBILITIES:

• 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

REQUIRED QUALIFICATIONS:

• 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

DESIRED QUALIFICATIONS:

• 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