Sales Compliance System Analyst

Are you looking to Optimize your life? Start your exciting path to a rewarding career today!
We are Optimum, a leader in the fast-paced world of connectivity, and we're on the hunt for enthusiastic professionals to join our team! We understand that connectivity isn't just a luxury anymore - it's a necessity that empowers lives, fuels businesses, and drives innovation. A career at Optimum means you'll be enabling progress and enhancing lives by providing reliable, high-speed connectivity solutions that keep the world connected. We owe our success to our amazing product, commitment to our people and the connections we make in every community.
If you are resourceful, collaborative, team-oriented and passionate about delivering consistent excellence, Optimum is the Company for you!
We are Optimum!
Job Summary
The Compliance System Analyst is a multi-faceted role that supports the Company Organization both East and West Residential and Commercial to ensure compliance to the order entry process and Mobile product order entry process. This candidate is responsible to work independently to design and maintain databases utilizing SQL Server or any other design software. Must be able to handle multiple projects and the ability to work under pressure when last minute deadlines arise. Must be able to analyze, automate, organize, choose suitable structures to store this data and maintain queries and reports, as well as deep-dive analysis.
Responsibilities

• Manage file systems and automation of various databases.
• Create and modify tables, views, and indexes according to business requirements.
• Create data conversation system using MYSQL store procedures to load relational content.
• Troubleshoot database related issues in a timely fashion and recommend improvements for performance efficiency.
• Builds and maintains databases. Contributes to data validation of and performs follow-up corrections to ensure accurate data is being displayed in databases.
• Analyze data and develop reports to disseminate to local sales offices, identifying key areas of non-compliance with business rules.
• Makes recommendations and solutions on processes and ploicy based on reporting and business needs.
• Ensure SOX compliance for non-pay business rules, promotional eligibility rules to prevent revune loss for the organization.
• Responsible for staying current with all current and new promotions for all sales channels.
• Responsible for attending weekly compliance meetings to identify trends, new promotions, and rate codes.
• Perform other duties as assigned my manager.

Qualifications

• Minimum 5 years' experience in designing and managing a complex database infrastructure
• 5+ years of experience working on relational databases and writing SQL queries
• Strong understanding of key design principles for data architecture, design, and development
• Mathematical Aptitude required
• Data manipulation expertise involving data extractions, data matching between multiple systems, transformation, cleansing, and loading.
• Creating Macros and VBA a plus
• Proficient in Python, SQL, Microsoft Word, Excel, PowerPoint, Visio, and Tableau
• Experience with cloud patterns such as Google Cloud.
• Degree in Computer Science or related field of study required
• Strong oral and written communication skills
• Time management, problem solving and detail oriented and can work under pressure in a fast pace environment and meet deadlines
• Schedule may include working weekends depending on project deadlines

#LI-SF1
At Optimum, we're fueled by our four core pillars: Taking Ownership, Upholding Transparency, Creating Community, and Demonstrating Expertise. Our commitment to empowering employees to take responsibility and embrace proactive problem-solving underpins Taking Ownership. Upholding Transparency is at the core of our culture, with open and honest communication fostering trust among our dedicated team and loyal customers. Creating Community is more than a goal; it's our daily commitment to fostering an environment of collaboration, innovation, and positivity. Demonstrating expertise is a promise we uphold through continuous learning and engagement with our customers to consistently deliver top-quality products and services. These pillars not only shape our culture but define Optimum as a place of excellence, trustworthiness, and thriving community, and we invite you to be a part of our journey.
If you have the drive to succeed and are ready to embark on a thrilling career, seize this opportunity today, and join our winning team, so together, we'll shape the future of connectivity.
All job descriptions and required skills, qualifications and responsibilities for a particular position are subject to modification by the Company from time to time, in the Company's discretion based on business necessity.
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, national origin, religion, age, disability, sex, sexual orientation, gender identity or protected veteran status, or any other basis protected by applicable federal, state, or local law. The Company provides reasonable accommodations upon request in accordance with applicable requirements.
Optimum collects personal information about its applicants for employment that may include personal identifiers, professional or employment related information, photos, education information and/or protected classifications under federal and state law. This information is collected for employment purposes, including identification, work authorization, FCRA-compliant background screening, human resource administration and compliance with federal, state, and local law.
This position is identified as being performed in/or reporting to company operations in New York State. Salary ranges are supplied in compliance with New York State law. Pay is competitive and based on a number of job-related factors, including skills and experience. The starting pay rate/range at time of hire for this position in the posted location is $77,112.00 - $126,684.00 / year. The rate/Range provided herein is the anticipated pay at the time of hire, and does not reflect future job opportunity.
Applicants for employment with the Company will never be asked to provide money (even if reimbursable) as part of the job application or hiring process. Please review our Fraud FAQ for further details.
Nearest Major Market: Long Island
Nearest Secondary Market: New York CIty