Senior Development and Data Analyst – Financial Systems (Job 3018204)
Boca Raton, FL
Category: Accounting & Finance
Office Location: Boca Raton, FL
Workstyle: A hybrid schedule where employees work on-site four days per week and remotely one day.
What You’ll Do:
The Senior Development and Data Analyst will provide support for ongoing solutions development, data strategies, end-to-end data integrations, and system design improvements for all of ADT’s Planning, PCM, EDM, Dodeca, Essbase, and financial systems data hub.
- Creates, update and maintains the library (currently in Microsoft SSIS ETL task) of automation routines for data sources to be used by financial systems tools (EPBCS, PCM, Dodeca, Essbase, EDM).
- Creates data validations for data sets to validate that changes done to the library does not affect the accuracy of existing data.
- Works with the Admin side of the financial systems group to build new data sets that meet the end user requirement.
- Works with the Admin side of the financial systems group the transition of new data sets for the daily execution of the same.
- Provides support and guidance to the admin side of the financial systems group whenever there is a data discrepancy or data challenge.
- Understands ADT’s business and general reporting to be able to deliver the best possible solutions using our EPM tools.
- Creates and maintains documentation of existing processes.
- Provides timelines and level of effort for any development/data project.
- Ensures systems are running efficiently and leads any fixes required to keep systems running.
- Identifies potential system improvements to ensure systems run as efficient as possible.
What You’ll Need:
- Bachelors degree in business or Information Technology. MBA or CPA preferred.
- 5+ plus years of prior related experience is required.
- Experience understanding, communicating, and prioritizing projects.
- Excellent interpersonal, written, and verbal communication skills.
- Resourceful and able to work independently.
- Ability to build rapport, cultivate working relationships, and drive collaboration across business teams.
- Proactive and solution-oriented approach towards business problems and process improvements.
- Ability to manage multiple projects simultaneously and to work well under pressure.
- Strong analytical and problem-solving skills.
- Strong Understanding of Oracle EPM tools.
- Experience with writing SQL code (store procedures in MS SQL, Google’s Big Query and Oracle’s PL SQL).
- Experience with using Microsoft SSIS (ETL packages).
- Experience with data validation between target and source systems.
ADT is an Equal Employment Opportunity (EEO) Employer. We celebrate diversity and are committed to building an inclusive team that represents a variety of backgrounds, perspectives, and skills. ADT strives to ensure every employee and applicant feels valued. Visit us at jobs.adt.com/diversity to learn more.