Overview: Management Science Associates, Inc. (MSA) is a diversified information management company that for nearly half a century has given market leaders the competitive edge in data management, analytics and technology. We are seeking a highly technical and experienced Senior Software Engineer to lead the continuing development of our Big Data platform and integration infrastructure delivering near real-time, ‘Big Data’ capable business intelligence and analytics products for the CPG industry.
The selected individual’s talents and strategy will be instrumental in leading the development effort of an integrated architecture incorporating a high performance, self-directing and self-checking production environment. Successful candidates must have knowledge and implementation experience with data management techniques to deploy the requisite large-scale analytics infrastructure which meets the high performance, self-scaling, ubiquitously available, and secure data management environment required in today’s data centric world.
This is a very technical and challenging position requiring the ability to work effectively with other functional organizations and accountable for the implemented product portfolio’s performance and quality.
Position Summary: The Senior Engineer’s role is to lead in the design, development, and support of our applications and databases within our Hadoop environment. The selected individual must have knowledge of complex database concepts in order to provide a sound vision, leadership and strategy as well as actively participate in the design, implementation and subsequent operations.
Recommend, architect, design, operate and maintain a data lake that supports large-scale analytics
Ensure the architecture is optimized for large dataset acquisition, analysis, storage, cleansing, transformation and reclamation
Ensure the architecture adheres to enterprise architecture best-practices that meet and exceed security, manageability, scalability, performance, availability, visibility and flexibility requirements
Provide services to internal and external clients in UNIX and Linux environments
Design, install, and maintain complex database systems including data modeling, security, performance, documentation, capacity planning, reporting, and tuning
Lead the designs, development and implementation of database backup and recovery procedures to minimize downtime and ensure recoverability.
Collaborate with Product and Project Management, Architecture, Testing, Quality Assurance, Operations, Client Services, and executive management to ensure the integration efforts meet release schedules, goals, and objectives
Integrate major, complex systems
Develop and execute database migration, change management and configuration management tasks for new releases of MSA products
Provide design on database architecture and API code to support performance and data integrity
Mentor less senior personnel
Requires a four-year degree in Computer Science/Information Technology or equivalent experience
Master’s degree in Business (MBA), Computer Science/Software Engineering or related degree program is preferred
Minimum eight years of Software Engineering work experience including design, implementation, backup and recovery, monitoring, and tuning databases
Minimum five years of enterprise architecture experience and three years working with enterprise data warehousing and business intelligence technologies and solutions
Experience and detailed knowledge of ‘Big Data’ technologies (e.g. Hadoop, Hive, Spark, Redshift, HBase) and large data sets
Experience with relational DBMSs (e.g. Oracle, SQL Server, MySQL, Postgres).
Understands complex and advanced database concepts
Considers business aspects of problems, and recognizes opportunities for expanding business services.
Must be proactive and preventive in problem solving
Strong analytical and troubleshooting skills
Ability to work independently on multiple tasks
Excellent communication and technical skills
Knowledge of relational databases, Structured Query Language (SQL), UNIX, or Linux operating systems
Knowledge of programming or scripting language (KRON, PL/SQL, C Shell)
Advance Knowledge of programming.
Exercise independent judgment in methods, techniques and evaluation criteria for obtaining results
Extremely knowledgeable of industry standards and trends
Required Technical Skills:
Data modeling, architecture, design and implementation
Data Warehousing, Data Marts, Operational Data Stores