October 10, 2016

Financial Systems Analyst

Tyco Fire and Security - Indianapolis, IN

View Job Summary View Job Summary
  • Company
    Tyco Fire and Security Tyco Fire and Security
  • Location
    Indianapolis, IN
  • Job Type
  • Job Classification
    Full Time
  • Experience
    Mid-Career (2 - 15 years)
  • Education
    Bachelors Degree
  • Company Ref #
  • AJE Ref #

Job Description


The primary function of the role is to provide support to the Financial Analytics Manager for financial and operational reporting automation and innovation.
As Tyco Financial Systems Analyst, this position will:

* Create, overhaul, replace automated financial and operational automated reporting systems

* Write VBA code, macros, and SQL queries to extract, manipulate, and distribute data

* Identify existing needs for operational data management and activity tracking, collaborate with key stakeholders to provide solutions

* Work closely with IT and data governance to manage database optimization, leverage and support existing infrastructure, coordinate with concurrent development initiatives

* Support ad-hoc vs. standard reporting process to help determine when repetitive ad-hoc requests should be included as standard reporting

* Replace obsolete Access databases, orchestrate the centralization of cross-functional data in support of expanded operational reporting capability

* Perform other duties as assigned



Education: Bachelors degree in Information Technology, Business (Finance, Accounting), or related field, experience in Finance/Accounting preferred
Experience: 5

* The position requires individuals to have acute focus, personal drive, critical thinking ability, and be able to quickly grasp complicated issues

* Project management ability, identifying key opportunities for data management and reporting improvement, establish and drive improvement initiatives through completion

* Ability to work independently and proactively develop solutions with minimal guidance

* Fluent in VB.NET programming

* Fluent in ASP.NET programming

* Fluent in IIS7 administration & maintenance

* Fluent in MS-SQL Server 2008 R2 administration

* Fluent in SQL

* Fluent in VBA for MS Office Products

* Fluent with creation and maintenance of Microsoft SSIS scripts

* Fluent in Excel and Access

* Fluent with MS Server 2008

* Experience or knowledge of ERP systems