Job Description
CoolSys is the parent company of market-leading operating businesses that provide a full spectrum of best-in-class service experiences and solutions to the retail, commercial, and industrial refrigeration and HVAC industries. Our valued and dedicated employees are at the heart of our continued growth and success. We invite you to be part of that growth!
JOB SUMMARY
The Business Intelligence (BI) Developer lead will be primarily focused on Design, develop, implement, and support highly complex BI applications of strategic or functional importance including, integration with data sources, highly automated data refresh processes, best-in-class data visualizations, dashboards, and reports that communicate critical insights to drive decision making.
ESSENTIAL JOB FUNCTIONS
- Execute roadmap of business focused BI initiatives with a clear understanding of all deliverables and associated deadlines.
- Consult with end users to gather and clarify data and reporting needs for complex business intelligence solutions.
- Design & Develop reports and dashboards on Power BI based on the customer requirement and partnership with various stakeholders.
- Evangelize self-service BI, analytics and reporting as well as the effective use of the Azure Data Lake, PowerBI, and related data & toolsets by the widest possible audience.
- Develop and maintain data management standards, and documentation of current data sources, raw data, data marts, transformations, and report specifications.
- Lead a team comprised of internal and external resources to deliver DW/BI initiatives for the business.
- Oversee data quality including validation, cleansing/scrubbing, ETL methods, etc.
- Formulate and recommend standards for achieving maximum performance and efficiency of the data ecosystem.
- Create and maintain documentation and training materials for end users.
- Experience in architecting and designing technical solutions for Microsoft-centric solutions based on industry standards using (Azure) IaaS, PaaS and SaaS capabilities.
- Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.
- Experience in assessing the requirements for Azure cloud-based solution.
- Solicit and translate business needs into requirements for data objects including metrics, attributes, reports, and dashboards.
- Build data visualization reports and tools for self-service consumption using visualization tools like Power BI.
- Extract, analyze and model relevant data from various data sources.
- Ability to design and build Dashboards on Power BI.
- Develop new techniques to process large data sets, address quantitative problems, and recommend white spaces for experimentation.
- Partner with data engineering teams to improve data assets, quality, metrics, and insights.
- Think outside the box to deliver innovative solutions to core business problems and client needs.
- Draft concise documents communicating results to stakeholders, visualizing data where beneficial to drive decision-making.
KNOWLEDGE, SKILLS & EXPERIENCE REQUIREMENTS
- Bachelor's degree.
- 5+ years' experience in data warehouse/BI architecture, design and development.
- 5+ years' experience with MS SQL OLTP and OLAP database models.
- Expert knowledge of Azure tools and services centered around data and analytics (Data Lake, Data Factory, Azure SQL).
- Excellent understanding of Microsoft Power BI and other Microsoft BI platforms (SSRS, SSAS, etc.).
- Expert in BI Report and Dashboard development.
- Practical knowledge in designing complex SQL Server Integration Services (SSIS) packages.
- Experience understanding database performance and tuning impact.
- Excellent verbal and written communication skills.
- High degree of customer service focus and strong communication skills.
- Strong troubleshooting, problem solving and conceptualization skills.
Pre-employment background screening (criminal, drug screen and DMV) is required for all positions. CoolSys is an EOE/M/F/Vet/Disability employer.
#cool123