Top Job Pick: Data Systems Analyst, Data Warehouse / Data Analytics – Broward County, Florida

by SherlockTalent

Apply to this Job

SUMMARY: Designs, develops, implements, and maintains data models, database schemas and database systems. Installs, configures, administers, and maintains databases systems on multiple platforms. Develop, implement, and maintain ETL processes and programs.

This position is for a Data Systems Analyst in our client’s applications development group. The Data Systems Analyst is responsible for understanding and analyzing project requirements to develop flexible and robust Operational and/or Analytical / Dimensional logical and physical data models.

The role requires strong collaboration with application development teams, business teams, and key stakeholders to design robust, scalable, operational, data warehouse, data mart, and/or third party solutions. This position demands a well-organized, action oriented team player with exceptional time management skills to support multiple initiatives simultaneously and in a very fast paced environment. The Data Systems Analyst will participate in all aspects of the software development process including, requirements gathering, designing, coding, unit testing, quality assurance, and deployment documentation. The Data Systems Analyst is expected to work well within a collaborative team of software professionals and have technical group leadership abilities to lead data modeling and data management activities.

DUTIES AND RESPONSIBILITIES: 

• Reviews and analyzes database requirements; develops detailed database design specifications to meet identified requirements in a the database environment.
• Reviews and analyzes user needs; assist to determine equipment and software requirements for solutions to problems.
• Analyze and understand business data requirements to create accurate, extensible, flexible logical data models using modeling tools e.g. ErWin, ER/Studio
• Design and develop logical and physical data models that are consistent with data standards, guidelines, work processes and tools.
• Develop and/or assist with development of data access protocols and methods. Analyzes and develop codes for ETL, database access, modification and construction
• Assists with the development and implementation of database standards and methodologies.
• Responsible for adhering to Data Standards and managing metadata quality and integrity.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
• Supports the development of Enterprise Data Architectures
• Installs, configures, administers, maintains, and tunes databases.
• Perform database backup, recovery, and/or replication as needed.
• Researches, recommends, and implements database and system software upgrades.
• Analyzes and reports on database metrics; administers and controls data resources; monitors and ensures database integrity, security, and performance; and implements tools to improve database performance.
• Interact with business partners to share and direct architecture practices that may affect business solution delivery
• Take an organization-wide view of the business and its data, (e.g. maintain re-usable or enterprise data models) while providing detailed project-specific modeling and analysis support
• Assists in research of data architecture technology industry trends

QUALIFICATIONS: 

• Bachelor’s degree in Computer Science or related discipline. Graduate degree preferred.
• 8+ years of experience in IT systems or applications development
• 5+ years of data modeling; database analysis, design, implementation and administration.
• 3+ years of experience architecting or delivering large scale systems in an enterprise environment on multiple platforms, with a focus on Data Warehousing (building and implementing), Big Data, Cloud Technologies, and/or Advanced Analytical solutions
• Experience in the development, implementation, and management of Enterprise Data Models, Data Architecture Strategies, Delivery Roadmaps, Information Lifecycle Management, and Data Governance capabilities
• Extensive experience building conceptual and physical models
• Familiarity with Windows and Linux/Unix administration. Ability to write shell scripts in Linux.
• Ability to install software on Linux systems and configure Linux OS.
• Experience with data access and database connectivity, the tools and techniques, especially the development experience in web and analytics applications.
• Experience with SQL (SQL Server, MySQL, and/or PostgreSQL) and NoSQL Database Systems.
• Experience with cloud computing, especially with AWS, including Amazon Redshift.
• Advanced knowledge of Data Warehousing and ETL techniques, tools, and best practices
• Extensive experience with dimensional modeling and ETL programming
• Knowledge of reporting and visualization tools and Executive Information systems design and implementation. Experience with Tableau or similar technologies and tools desired.
• Working knowledge of version control techniques and tools. Experience with Git a plus.
• Good understanding of software development methodologies and best practices
• Experience with Scrum or Kanban Agile methodologies a plus
• Commitment to excellence and high standards.
• Excellent verbal and written communication and persuasion skills;
• Ability to collaborate and engage effectively with technical and non-technical resources at all organization levels.
• Strong organizational, problem-solving, and analytical skills with acute attention to detail.
• Ability to work independently and as a member of various teams.
• Proven ability to handle multiple projects and meet deadlines.
• Ability to work on complex projects with general direction and minimal guidance.
• Good judgement with the ability to make timely and sound decisions
• Understanding of security legislation that affects our businesses, including, but not limited to Sarbanes-Oxley, Payment Card Industry regulations, Customer Data Protection regulations and contemporary security legislation activities that may impact future plans.

Top Job Pick: Salesforce Developer – Palm Beach County, Florida

by SherlockTalent

Apply to this job

Summary:

The Salesforce Developer will be part of a Level 3 software engineer support team that will resolve system defects, assists in troubleshooting escalated support issues, and act as a technical Subject Matter Expert for Salesforce.com. This position will work closely with development and quality assurance teams as well as various teams in the Client Services department.

The application developer codes, tests, debugs, documents, and installs both new programs/technologies and changes to existing programs/technologies of a complex nature with assistance of higher level personnel to provide quality IT services to user departments. Maintains and modifies existing applications without supervision as well as under direction from senior staff members.

Candidate Profile:

The successful candidate is someone who encompasses strong problem solving skills while dealing with abstract concepts, systems and ideas. The candidate must possess confidence and able to work in fast-paced hands on environment

Essential Duties and Responsibilities – Other duties may be assigned:

• Collaborates with business analysts and internal clients to troubleshoot incidents and resolve defects in software applications with minimal quality issues.
• Utilizes established development tools, guidelines and conventions to maintain existing software systems by identifying and proactively correcting software defects.
• Partners with project teams on application enhancements including designing, coding, testing, debugging, documentation and installation.
• Analyzes and fixes moderate to complex problems during development. Documents and communicates results appropriately.
• Monitors production programs for expected performance and responds to errors and emergency problems. Provides on call support for all of the team’s applications and batch processes.
• Participates in code reviews to represent reviewed work for adherence to standards and specifications.

Requirements

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education/Experience/Knowledge:

Bachelor’s degree in Computer Science or Information Systems Management from four-year college or university and at least five years related business experience; or equivalent combination of education and experience where two years related experience equals one year of schooling.

Required Skills and Experience:

• Must have experience developing custom applications on the Salesforce.com platform.
• Experience with Salesforce user interface (UI) and data model.
• Experience in development Apex code that will scale to large data sets and custom interfaces using Visualforce.
• Can develop code within the Salesforce interface or the Force.com IDE as required.
• Can deploy secure production-ready applications, has broad understand of Force.com development lifecycle.
• Experience in designing test strategies to ensure adequate quality (e.g., code coverage; application behaviors; scalability environment independence) across Apex classes, triggers and controllers.
• Ability to administer any standard Salesforce applications, develop integrations using the Force.com SOAP and REST APIs, and publish consume Force.com App Exchange packages.
• Experience designing and delivering end-user training and training materials and providing technical support as necessary
• Ability to resolve issues for JitterBit Processes, operations, transformation, mapping, and data source management.
• Some experience of SQL, Server SQL preferred for JitterBit to Salesforce integrations to back-end processes.