Intermediate Business Intelligence Developer Jobs

Knowledge of database management principles and experience working with SQL/MySQL databases

Develop strategies for data modeling, design, transport, and implementation to meet requirements for metadata management, operational data stores and ELT/ETL environments

Research modern technologies, data modeling methods and information management systems and recommend changes to company data architectures

Design relational databases to support business enterprise applications and physical data modeling according to business requirements

Understand ad-hoc data requirements and convert it into reporting deliverables

Contribute to a team environment where all team members consistently experience a sense of belonging and inclusion

Experience with data modeling, data structures, and metadata management

Required Knowledge, Skills, and Abilities:

Excellent SQL skills and experience with writing and troubleshooting complex T-SQL queries, views, and stored procedures

Use your T-SQL skills to extract and manipulate data to support data analysis and reporting

Stay up to date with the latest trends and advancements in BI and recommend solutions to improve the organization's BI capabilities.

5+ years of experience in a Power BI/Tableau Developer, or similar data-related role, developing sophisticated solutions and uncovering actionable insights

Achieve certification in vendor’s application as required

Microsoft BI certification is considered an asset

3 plus years’ experience in SQL Server 2019

Ability to lead and/or participate in requirement gathering sessions, document user requirements and translate them into useful solutions;

Experience developing indicators and associated documentation;

Experience in maintaining proper data governance best practices

100% remote in Quebec with occasional travel on Thursdays to the client's office in Montreal.

4 or more BI development experience: SQL, ETL, SSIS, Azure Synapse

Knowledge of administration of the Power BI platform

We are in the process of converting to Cloud technologies.

Deliver important and large-scale projects;

Develop BI best practices within the organization;

Effective organizational, time management and planning skills

Adhere to IT project management standards and procedures, tracking and documenting the various tasks accordingly.

Gather and document requirements, problems, and opportunities for key reporting needs.

Assist BI Lead with development of reporting solutions within Power BI, and aid business teams in refining requirements.

Accommodate evolving requirements, risks and issues while meeting targets within reasonable timelines.

Minimum 5 years of experience as a Business Intelligence Analyst/Developer, Data Analyst or report developer.

SQL and database management (e.g., work with DB objects, creating tables, views, stored procedures, functions, optimization).

Flexible health benefits and wellness program.

Collaborate with cross-functional teams on the development and maintenance of analytics products and solutions.

Create and maintain ETL (Extract, Transform, Load) process to ensure data accuracy and consistency.

Perform data wrangling, data profiling, cleansing and validation to ensure data quality.

Develop, monitor, and troubleshoot data integration and data product processes ensuring quality, performance, and accuracy.

Bachelor's Degree or acceptable combination of equivalent experience.

Excellent development skills and ability to retrieve data from different relational databases

Strong knowledge of MS Excel and data integration programming

Experience with testing user-facing applications

Knowledge of AMS systems: FIS, HRIS or similar SAP-based data administration systems

Working knowledge of API layer, HTML, HTTP REST API, and web development and integration

Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions using Power BI

Collaborate with stakeholders to gather requirements and create insightful reports, dashboards, and visualizations using Power BI.

3+ years of experience as a Business Intelligence and Analytics Developer, with a strong focus on Power BI

Certification in Power BI preferred

Knowledge of SQL, data querying, and scripting languages

Experience in establishing and managing a BI Center of Excellence, with expertise in Power BI implementation and data governance

Report/present findings and data-driven recommendations to the leadership and management team.

Support any data analytics requests from Supply Management

Three (3) years' working experience within the last 4 years in the business intelligence and analytics analyst role including experience in:

Previous work experience in the pubic sector or large organizations.

Intermediate Business Intelligence and Analytics Analyst Responsibilities

Intermediate Business Intelligence and Analytics Analyst Must Have Skills:

University degree with related experience in Computer Science, Management or related field

Experience managing/ leading large BI projects or processes with limited oversight from manager.

Experience in translating business requirements into effective Business Intelligence solutions.

Knowledge of SharePoint and experience in developing web forms in .Net

Good presentation skills with solid communication capabilities and practices, both oral and written.

Experience coaching, reviewing and delegating work to lower level professionals.

• Proven experience working with MDM software, data management, data quality, data governance

• Project Management experience would be an asset

• Design and develop business criteria reports by leveraging deep ETL skills and database knowledge.

• 8+ years of experience in software industry; strong knowledge of database design, and data warehouse technologies

• Scripting experience in Perl, Powershell or Python

• Hands on experience on .NET C#

Full project management and development life cycle experience

Minimum 3+ years of combined experience in data warehousing/business intelligence/analytics and reporting systems.

Strong knowledge of Fixed Income, Equity and Derivative businesses

Strong ability to analyze user requirements, make recommendations and implement solutions

Strong oral and written communication skills

Strong presentation and interpersonal skills

Possess a university degree in computer science or an approved equivalent combination of education and experience.

Demonstrate a minimum of 3 years of experience in data visualization, analysis, or related fields.

Showcase excellent visual skills, including a solid understanding of design principles such as layout, typography, color, interaction design, and fluency.

Working knowledge of Adobe Illustrator or equivalent software is advantageous.

Experience in designing and developing dynamic dashboards and visual reports using platforms like Tableau, Qlik, or Power BI.

Utilize SQL and Python for data analysis and processing.

Knowledge and experience using shared folders and working with collaborations tools such as Microsoft Teams and SharePoint

Assist with gathering business and information requirements

Provide supporting documentation and knowledge transfer to Client/Ministry/Organization as required

5 years of experience in Business Intelligence

Experience with information technologies such as servers, storage, networks, operating systems, database technologies, security technologies, development tools, and programming languages

Experience with low code platforms such as Microsoft Power Platform

Experience and Skill Set Requirements

Business Intelligence Specialist – Intermediate

Business Intelligence Specialist - Intermediate

Location: 222 Jarvis St., Toronto, Ontario (Hybrid)

Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

•Full project management and development life cycle experience

•Minimum 3+ years of combined experience in data warehousing/business intelligence/analytics and reporting systems.

•Strong knowledge of Fixed Income, Equity and Derivative businesses

•Strong ability to analyze user requirements, make recommendations and implement solutions

•Strong oral and written communication skills

•Strong presentation and interpersonal skills

Working with clients and consultant team to understand and implement their technical requirements.

Bachelor’s degree or equivalent experience in Computer Science, Information Technology, or similar field of study.

3+ years of experience in business analytics development and/or database programming preferred.

Experience in SQL programming (MS SQL, MySQL); Proficiency in writing SQL queries with a solid understanding of database principles

Experience with Power BI or comparable business analytics tools is required.

Demonstrated ability to think critically when developing client solutions considering business processes and software capabilities.

Full project management and development life cycle experience

Minimum 3+ years of combined experience in data warehousing/business intelligence/analytics and reporting systems.

Strong knowledge of Fixed Income, Equity and Derivative businesses

Strong ability to analyze user requirements, make recommendations and implement solutions

Strong oral and written communication skills

Strong presentation and interpersonal skills

Collaborate with key business stakeholders to identify business needs and drive detailed technical requirements.

A minimum of 3+ years of relevant experience.

Excellent business acumen and ability to communicate with both technical developers and business leaders to translate requirements into a development plan.

Excellent organizational, analytical and problem-solving skills.

Advanced experience with a visualization / reporting using MS Power BI.

Excellent skills in data modeling using Analysis Services or Power BI and proficient with DAX language.

Deep understanding of the game development process (either for games or applications of game technology) through education or previous work experience.

Working collaboratively with our founder, project manager, and developers.

Native English skills, with excellent reading comprehension as well as strong speaking and writing skills.

Excellent communication and interpersonal skills.

Being self-organized, able to juggle different tasks, and manage your own time.

Work from our office in Guilford, Connecticut, or remotely from within the US or Canada.