• Designs and implements business intelligence and extract, transform, and load (ETL) solutions using programming, performance tuning, data modeling. • Create databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of the business's databases. • Serves as a liaison between the Database Administration department and development teams. • Learn area's direct flow; and how it affects surrounding systems and operational areas. • Architect, design, construct, test, tune, deploy, and support Data Integration solutions for various data management systems. • Contribute to the team's knowledge base with useful information such as adopted standards, procedure documentation, problem resolution advice, etc. • Participate in the promotion of SQL Server best practices • Collaborate with other technology teams and architects to define and develop solutions. • Research and experiment with emerging Data Integration technologies and tools. • Work with the team to establish and reinforce disciplined software development, processes, standards, and error recovery procedures are deployed; ensuring a high degree of data quality. • Support Enterprise database clustering, mirroring, replication among other SQL Server technologies. • Develop, write and implement processing requirements and post implementation review • Facilitate and/or create new procedures and processes that support advancing technologies or capabilities • Design & Implement Extract, Transform, and Load (ETL) solutions utilizing SSIS • Apply data mining rules • Create logic, system, and program flows for complex systems, including interfaces and metadata • Write and execute unit test plans. Track and resolve any processing issues. • Implement and maintain operational and disaster-recovery procedures. • Participate in the review of code and/or systems for proper design standards, content and functionality. • Participate in all aspects of the Systems Development Life Cycle • Analyze files and map data from one system to another • Adhere to established source control versioning policies and procedures • Meet timeliness and accuracy goals. • Communicate status of work assignments to stakeholders and management. • Responsible for technical and production support documentation in accordance with department standards and industry best practices. • Maintain current knowledge on new developments in technology-related industries • Participate in corporate quality and data governance programs • The position requires a full-time work schedule. Full-time is defined as working at least 40 hours per week, plus any additional hours as requested or as needed to meet business requirements.
REQUIRED COMPETENCIES 1. Required Job Skills • Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones • Intermediate PC proficiency in spreadsheet, database and word processing software • Advanced knowledge of business intelligence, programming, and data analysis sotfware • Intermediate knowledge of Microsoft SQL databases and database administration • Intermediate proficiency in T-SQL, NZ-SQL, PostgreSQL, NoSQL, Hadoop, data tuning, enterprise data modeling and schema change management. • Working technical knowledge of current software protocols and Internet standards to the extent that they apply to database administration. • Excellent database troubleshooting skills • Working technical knowledge of PowerShell. • Strong object-oriented design and analysis skills • Experience consuming, organizing and analyzing JSON and XML messages as data. 2. Required Professional Competencies • Knowledge of agile development practices • Strong analytical skills to support independent and effective decisions • Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints. • Perserverance in the face of resistance or setbacks. • Effective interpersonal skills and ability to maintain positive working relationship with others. • Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts. • Systems research and analysis. Ability to write and present business intelligence documentation • Demonstrate the ability to stay current on global threats and vulnerabilities. • Maintain confidentiality and privacy 3. Required Leadership Experience and Competencies • Build synergy with a diverse team in an ever changing environment. PREFERRED COMPETENCIES 1. Preferred Job Skills • Advanced knowledge of Data Integration • Advanced proficiency with relational technologies that supplement RDBMS tool sets • Advanced knowledge of Microsoft Applications and Suites, Windows Server, and Microsoft SQL databases. • Advanced knowledge of decision support systems • Advanced knowledge of Netezza administration • Advanced proficiency in TalenD Open Studio or Profisee Maestro Enterprise Data Warehouse (EDW) tools. • Minimum 1-2 Year Experience on Cloud computing, Azure preferable. • Experience supporting Spark-R and R • Intermediate knowledge in Python scripting • Knowledge of any of the common Hadoop Tools; such as, NIFI, Hive, Pig, Oozie, HBase, Flume, Sqoop, Yarn MapRecdce, Ambari, Spark, Java, Python, • Proficiency with agile development practices • Experience collecting and storing data from Restful API's 2. Preferred Professional Competencies • Advanced systems research and analysis expertise • Solid technical ability and problem solving skills 3. Preferred Leadership Experience and Competencies • Experience and knowledge in participating in a highly collaborative scrum team. • Experience in developing, maintaining and enhancing big data solutions. • Demonstrated experience and patience in mentoring and sharing knowledge with peers.