This position is an important part of the company's financial and analysis activities:

• Design, develop and maintain daily / weekly / monthly processes that pull data from various systems, both internal and external, and loads into the Finance operational data store
• Develop tools and processes related to financial reporting, planning, scenario and sensitivity analysis and strategic financial projections
• Assist the Financial Systems Manager and business directors in understanding the company's performance through timely and insightful analysis

Job Responsibilities:

• Leverage system tools to collect, analyze data and develop various models in support of financial projections and other operational performance trends
• Prepare detail pricing analyses using automated tools (SQL, PowerQuery, Power Bi, etc.) to extract data from the system, manipulating, summarizing and analyzing results for executive and senior management review
• Identify process improvement opportunities within the Finance department to enhance efficiency
• Perform ETL functions in a data warehousing environment
• Design, build and deploy effective SSIS packages
• Translate requirements from the business and various Finance teams into technical code
• UAT latest developments by IT team to ensure compliance with expectations
• Identify and test for bugs and bottlenecks in the ETL solution
• Acts as a business partner on various financial analyses by bringing in business and technical expertise
• Other ad-hoc analyses as required or requested by management

• Strong technical skills required
  • Advance skills on MS Office applications
  • Advance Excel experience required (PowerQuery, Advance formulas, e.g., vlookup, sumif, indirect, index, etc.)
  • Visual Studio, SSIS exposure for management of data flows
  • SQL/DAX experience for use in pulling data and developing reporting
• Demonstrated advanced SQL coding skills as the main mechanism for data extraction and transformation
• Experience designing and building complete ETL/SSIS processes using Visual Studio
• Proficient in how to deploy to and debug a production SSIS environment
• Experience in the identification of data quality
  • Experience on Tableau, Power Query, Power BI and other data analytics tool is desirable
• Ability to understand and modify complex spreadsheets and datasets
• Experience in Corporate Finance and Accounting (Healthcare industry experience a plus) preferred
• Aptitude for problem solving with strong analytical thinking ability
• Strong verbal and written communication skills
• Highly committed, motivated and team oriented personality
• Ability to interact with individuals at all levels of the organization

Education and Experience:

• Bachelor's degree in Finance, Accounting, Business Administration, Statistics, Information Systems or equivalent, required
• Minimum of 5 years related experience