Job Location: Boston, MA
This is a hybrid opportunity 2/3 days on site in Seaport a week
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)
Submit CV To All Data Science Job Consultants Across United States For Free
