BI Developer Analyst (Maternity Coverage)

At Flynn its not just a job its a career

12-Month Contract (Maternity Coverage) :

The Business Intelligence (BI) Developer Analyst will take the lead on designing developing implementing and maintaining our data warehouse infrastructure and creating a future vision for BI at Flynn Group of Companies. Were looking for someone who can design build and maintain the full data and analytics technical stack. This includes data warehouse architecture BI application infrastructure and data visualizations (dashboards and reports).

This position will report to Director Applications.

What we offer :

• In-house training and development program
• Very well-equipped on-site gym
• Employee and Family Assistance Program
• Subsidized onsite cafeteria with excellent food choices!
• Free parking and EV Charging facility
• Family Events and Flynn Fest

Key Responsibilities :

Data Analysis & Requirements Gathering : Collaborate with business stakeholders to understand and document reporting needs. Translate these requirements into technical specifications and actionable development and update documentation for all IT Business Intelligence and analytics deliverables. Facilitate workshops collecting and analyzing data from various sources to identify trends patterns and correlations that will support business growth.

Dashboard & Report Development : Design develop and maintain interactive dashboards and reports using PowerBI and Microsoft Fabric.

Ad Hoc Reporting : Develop customized reports and visualizations in response to ad hoc requests providing timely and relevant insights based on immediate business requirements.

Trend Identification : Analyze data and identify trends to provide actionable insights. Propose improvements to existing reports and dashboards based on data-driven findings and user feedback. Complete detailed analysis of data before reporting findings and data-driven recommendations to the leaders and decision makers.

Cloud Database Management : Manage and optimize cloud-hosted databases for effective data retrieval and manipulation. Ensure data accuracy consistency and performance.

CI / CD Implementation : Develop and manage CI / CD pipelines for BI report and dashboard development. Ensure efficient and reliable deployment across development testing and production environments.

Best Practices & Standards : Apply best practices for data warehousing and BI development. Implement standards for data quality security and -own and maintain IT repository of metric definitions ensuring clarity and consistency in partnership with IT Business Analysts. Maintain a security plan for our data and analytics including delivery of role-based access control on all aspects of the system to ensure confidential and sensitive information is protected.

Performance Tuning & Maintenance : Monitor and optimize the performance of BI solutions. Troubleshoot and resolve performance issues and ensure efficient data retrieval and report generation. Partner with IT teams to communicate software upgrades and release data profiling to identify anomalies review and validate incoming data sets.

Documentation & Training : Create and maintain comprehensive documentation including technical specifications user guides and training materials. Provide training and support to end-users as needed. Develop and update documentation for all IT Business Intelligence and analytics deliverables

Cross-Team Collaboration : Work closely with business team SMEs (Finance Operations Manufacturing) IT infrastructure DBAs and other team members to integrate BI solutions into the broader data ecosystem. Actively participate and drive project planning and status meetings related to BI initiatives. Collaborate with various departments and staff members to develop a solid understanding of Flynn business and the metrics that drive performance.

Data Integration : Integrate multiple and new data sources into existing data warehouses. Ensure seamless data flow consistency and accuracy across all integrated and validates data to ensure data integrity and accuracy of data flows to and from the data warehouse as well as between connected apps.

Troubleshooting & Support : Provide support for BI report implementations addressing and resolving issues related to data accuracy report performance and user access. Troubleshoot and debug BI solutions to ensure optimal data quality checks while ensuring data integrity and accuracy across all data sources before implementing findings

What We Are Seeking :

Education : Bachelors degree in Computer Science Information Systems Data Analytics or a related field. Advanced degrees or certifications are a plus.

Experience : Minimum of 3-5 years of experience in BI development.

Technical Skills :

o Expertise in PowerBI and Microsoft Fabric for data visualization and dashboard development.

o Proven experience with cloud-hosted databases (e.g. Azure SQL AWS Redshift Google BigQuery MongoDB).

o Experience with Crystal Reports Python (QlikView / QlikSense Nprinting and Tableau experience is valuable as well)

o Proficiency in SQL and experience with cloud-based data storage solutions.

o Ability to create ad hoc reports and perform detailed data analysis.

o Experience integrating multiple and new data sources into existing data warehouses.

o Familiarity with data warehousing concepts and best practices.

o Experience with CI / CD pipelines and tools (e.g. Azure DevOps GitHub Actions).

o Strong understanding of data modeling ETL processes and data governance.

o Experience with the Microsoft data stack (T-SQL SSMS SSIS VB VBA Access)

Leadership : Ability to provide direction to stakeholders to ensure that solutions are effective and in keeping with the overall IT strategy.

Analytical Skills : Excellent problem-solving abilities with a strong focus on analyzing complex data sets identifying trends and providing actionable recommendations.

Troubleshooting Skills : Proven ability to troubleshoot and resolve issues related to BI solutions including data accuracy performance and implementation challenges.

Communication Skills : Ability to clearly present technical information and insights to non-technical are equally adept at communicating your ideas and vision to C-suite executives as well as operational team members.

Attention to Detail : High level of attention to detail with a commitment to delivering high-quality and accurate BI solutions.

Ownership & Self-Organization : Ability to work in a fast paced multi-project environment with shifting priorities and the ability to reassess and reprioritize competing business needs.

$30 - $42 an hour

#LI-AD1

#LI-LC1

Flynn Group of Companies is the leading trade contractor in North America that works on virtually every aspect of a buildings outer layer including Roofing Glazing Waterproofing and Architectural Metals. The foundation of our award winning success is having the right people on our team.

Disclosure : We use an AI-powered system to initially screen resumes. However all applications / resumes are also reviewed by our team of Human Resources and Talent Acquisition Professionals to ensure a fair and thorough evaluation in determining a candidates potential fit for a role they applied to.

This posting is for an existing vacancy within the organization.

We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.

Required Experience :

IC

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Employment Type : Contract

Experience : years

Vacancy : 1

Monthly Salary Salary : 30 - 42