For more than five decades, CTSI has earned its reputation for delivering technology innovation to corporations, government sectors, healthcare, educational institutions, houses of worship, and more. As technology rapidly advances, we maintain a thorough understanding of the market and our client’s needs to produce systems that are as captivating as they are informative.

We maintain a highly competitive edge by staffing only the best engineers and technical staff who hold diverse certifications and are required to participate in ongoing training and workforce development. Our advanced level of knowledge and training ensures our clients are getting the most efficient and technologically advanced systems available.

By keeping at the forefront of innovation and training, CTSI will continue to Engage, Inspire, and Deliver.

Our commitment to our customers has provided us the opportunity to grow immensely in recent years. We recently acquired eight new companies in the fire safety, security, and critical workspace solutions industries. Our goal is to create a single trusted business that can satisfy all our customers’ workspace solutions needs.

• We are looking for an amazing, early-career analyst to fill this role
• This position is remote and operates on eastern standard time
• It reports to the Director of Business Intelligence in the finance department

Our landscape makes for a complex data environment that you will be tasked with navigating to help senior leadership. Rapid growth creates synergistic opportunities that can be overlooked without a strong analytics department to sift through the weeds and see the forest for the trees. If data paints a picture that only you can see and you have a passion for putting together a story everyone else can understand, then this may be the role for you.

We are aiming to build a team that will function as an in-house consulting group for upper management. Your work will be project-based and the department you are servicing will be determined by your project. Our project structure promotes variety, and you will always be challenged. You will touch all areas of the organization, gaining a breadth of knowledge and skills along the way. You will learn to take any topic, break it down to the key (mutually exclusive, collectively exhaustive) components, and make meaningful insights that influence business decisions and move the needle. Thus, making you invaluable in any environment.

Responsibilities include producing accurate, timely, and comprehensive reports and analyses to drive strategic decision-making which helps the finance and operations teams maximize revenue and profits. This role will typically be tasked with compiling data from all acquisitions, developing and communicating business insights, and efficiently balancing multiple deadlines on assigned projects.

Performance Analyst Key Tasks:

• Clean and compile data from each company’s data sources, automate the cleaning and compiling process, and create data visualizations that generate meaningful actionable insights for the business
• Produce multiple reports and dashboards on a scheduled basis for use by the senior leadership team
• Effectively outline and communicate insights and drivers from these reports to leadership
• Perform deep-dive analyses of various topics such as accounts receivable, accounts payable, HR, employee performance, and work-in-process job forecast data to find profit-generating opportunities
• Devise new key performance indicators (KPIs) and create tools to measure and present those KPIs to leadership
• Work directly with operations and finance to determine solutions to business needs and streamline current business processes
• Create ad-hoc analysis as needed for senior leadership
• Create professional reports and presentations
• Prioritize and focus on outcomes that drive action plans, deliver business value, and enhance revenue.
• SQL coding skills (cross-joins, CTEs, nested joins, window functions, views, data type transformations, etc.) or enroll in a course upon onboarding

Basic Qualifications:

• Undergraduate in Business Administration, Economics, Computer Science, Engineering or related data analytic field or equivalent certification
• 1+ years of experience SQL coding, academic experience can count towards total years.
• 1+ years of advanced of MS Excel experience using pivots, lookups, get and transform data functions, academic coursework can count towards total years.
• 1+ years of experience using Python or R for analytics, data science, data cleansing, and automation or enroll in a course upon onboarding

Preferred:

• Graduate degree Business Administration, Economics, Computer Science, Engineering or related data analytic field or equivalent certification.
• Minimum of intermediate PowerPoint skills
• Experience with data visualization tool: Power BI or Tableau (thorough understanding of level-of-detail calculations)
• Experience with DAX and/or VBA
• Ability to understand and analyze data and provide insightful reporting and recommendations

Behavioral Characteristics of a Successful Candidate:

• Highly motivated, takes initiative, and self-driven
• An aptitude and willingness to learn new skills and grow current skills
• Excellent analytical and problem-solving skills
• Excellent interpersonal skills and communication skills (verbal and written) with all levels of employees and management
• Organizational skills and the ability to handle multi-tasking and work under pressure to meet deadlines