Financial Systems Analyst

For more than five decades, CTSI a Pavion company 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're 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, centered on the finance and accounting departments. You will gain an in-depth understanding of OneStream’s Enterprise Resource Planning (ERP) system. Essential job functions include the following: driving new additions to the tool’s functionality. Providing consultants who expand the tool’s functionality with instructions for the design, ensuring they are remaining on track, and validating their work. Serving as a liaison between consultants and the users. OneStream is the fastest growing and most highly rated ERP on the market right now. Thus, making the skills you gain in this role invaluable to our organization and the finance world at large.

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.

Financial Systems Analyst Key Tasks:

• Leverage VBA skills to write business rules as new functionality is needed
• Design data source ETLs as new companies are acquired
• Learn the current OneStream platform functionality and become the expert that the accounting team leverages
• Create sample outputs of data and calculations that consultants can leverage to validate their results
• Assist with the rollout of the account reconciliation and other marketplace solutions
• Clean data from several separate companies’ data sources to compile into a single source, automate the cleaning and compiling process, and create data visualizations that generate meaningful actionable insights for the business
• Work directly with finance teams across the organization to determine data-driven solutions to business needs and streamline current business processes
• Produce multiple reports and dashboards on a weekly and monthly basis for use by Senior Leadership team
• Analyze and compile insights from these reports to summarize drivers of KPI and overall performance for leadership
• Create ad hoc analysis as needed

Basic Requirements:

• Undergraduate or graduate degree in Business Administration, Economics, Computer Science, Engineering.
• 1+ years of MS Excel (pivots, lookups, get and transform data functions) and a minimum of intermediate PowerPoint skills
• 6+ months of VBA coding experience (or another coding language)
• 6+ months of SQL coding experience (cross-joins, CTEs, nested joins, window functions, views, data type transformations, etc.) or enroll in a course upon onboarding
• Ability to travel 5% of the year

Preferred:

• Experience with DAX
• Experience working with financial consolidation tools: OneStream, Hyperion Essbase, etc.
• 6+ months of VBA.net experience
• Experience with data visualization tool: Power BI or Tableau (thorough understanding of level-of-detail calculations)
• Background with Oracle databases
• Experience using Python or R for analytics, data science, data cleansing, and automation
• Ability to create professional reports and presentations
• An aptitude and willingness to learn new skills and grow current skills
• Excellent analytical and problem-solving skills
• Ability to understand and analyze data and provide insightful reporting and recommendations
• 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
• Ability to prioritize and focus on outcomes that drive action plans, deliver business value, and enhance revenue
• Highly motivated, takes initiative, and self-driven

Disclaimer: This job description should not be construed to imply that these requirements are the exclusive standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as may be required. The employer has the right to revise this job description at any time. The job description is not be construed as a contract for employment.

CTSI is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.

Job Type: Full-time

Pay: $89,000.00 - $93,000.00 per year

Schedule:

• Monday to Friday

Work Location: Remote

Please Note :
www.bankofmontserrat.ms is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.bankofmontserrat.ms provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.