Data Modeler

Title: Systems Analyst/Data Modeller

Location or Remote: Onsite - 1819 Main St, Sarasota, FL 34236

Salary: 110-125K. + Bonus structure.

Job Summary

Systems Analyst is a key analytical resource group that is a part of Enterprise Applications team driven to identify, define, develop and deliver innovative solutions that are in alignment with the organization goals. They play a crucial role in ensuring that the technological systems and infrastructure within our organization are efficient, effective, and aligned with business objectives. Their primary responsibilities include:

The IT Systems Analyst is tasked with improving process capabilities, functional & technical requirements, design, and deliverables, while maintaining and improving quality standards. As such the IT Systems Analyst role is responsible for the analysis, design and development of the necessary requirements, technical specifications, and process artifacts to support development efforts for a specific business unit(s). The IT Systems Analyst focuses on the technical aspects of IT systems, including design, integration, implementation, and troubleshooting. They are concerned with ensuring that the technical infrastructure meets the functional and non-functional requirements of the organization.

Essential Duties and Responsibilities

General Analytical & Design Duties

• Understands how to use technology to competitive advantage and to solve business issues – focusing on design and implementation of data modeling solutions to streamline and support enterprise information management.
• Develops and maintains a thorough understanding of business operations, identifying opportunities for operational efficiency through automation and effective utilization of reporting & analytics tools critical for all business areas (e.g., Marketing, Sales, Distribution, Manufacturing, Finance, Human Resources).
• Assists in technical delivery management and relationship management to identifying options for potential solutions and assessing them for both technical and business suitability.
• Works collaboratively with IT and the Business resources, assesses people, process, and technology current states, working to evaluate tradeoffs between usability and performance needs, and then utilize outcomes to develop requirements, use cases and user stories according to standard templates, using natural language.
• Provides thorough understanding of how to interpret customer business needs; elicits requirements using interviews/requirements workshops, conducts document analysis, surveys, site visits, plus task and workflow analysis.
• Establishes partnerships to conduct/perform decision analysis (options vetting with pros/cons assessed and outlined).
• Critically evaluates information gathered from multiple sources, reconciles conflicts in information gathered, decomposes high-level information into details, abstracts up from low-level information to a general understanding, and distinguishes user requests from the underlying true needs and then transfers the same knowledge to development team.
• Partners with knowledge management leads within Boar’s Head to ensure and maintain consistency on Standard Operating Procedures and formal Work Instructions that outline use of several enterprise-wide applications (Ex. Oracle ERP, Oracle Business Intelligence, Tableau, QMS, LIMS, MES, etc.) utilized in business processes.

Systems Analysis Specific duties

• Requirement Gathering
• System Design and Analysis:
• Design and analyze IT systems,
• Identify and develop process improvements and data validation rules to enforce company data policies and procedures
• Developing and assisting with implementation of data strategies and developing physical data models to support corporate data strategies
• Adept at creating conceptual data models and data flows using Visio and/or other more advanced visual modeling tools (i.e. Data Modeling and Visualization)
• System Integration: Oversee the integration of different systems and applications, ensuring seamless communication and data flow between them.
• Testing and Quality Assurance:
• Develop test plans and perform testing to ensure that systems meet quality standards and functional requirements.
• Partners with QA and Business teams in end-to-end integrated systems testing
• Develop, test, and deploy customizations, custom objects, new functionality based on evolving business requirements.
• Document system requirements, specifications, processes, and procedures to ensure that they are well-understood by stakeholders and team members.
• Document the lineage, usage, compliance, business logic, quality, access, risk, and value of all data assets for assigned data sets in accordance with BH policies and processes.
• Provide technical training materials to ensure systems are maintained and supportable
• Implementation Support: Provide support during the implementation phase, ensuring that systems are properly deployed and configured.
• Troubleshooting and Support: Troubleshoot issues that arise with IT systems, working to resolve them promptly to minimize downtime and disruption.
• Continuous Improvement: Stay updated on emerging technologies and best practices, recommending improvements to enhance the efficiency and effectiveness of IT systems.

Project Management Support

• Assists Technical Delivery Manager(s) in technical strategy analysis and assists Project Manager’s (PM) in refining project plans/objectives for delivering technical solutions according to best practice methodologies and IT process standards.
• Develops and maintains necessary project documentation in accordance with best practices and within the agreed upon project timelines.
• Partners with the project manager to define change requests for missed requirements and scope change, helping maintain the right focus on defined project constraints (schedule, resources, and scope/quality).

Education and Experience

• A Bachelor's degree in Computer Programming/Engineering, MIS, or related field or equivalent experience.
• A minimum of 3 years of experience in a Systems Analyst and/or Data Modeler role to be considered; to include experience with documenting functional and analytic requirements, functional specifications, use cases/stories, data models, data lineage and data flows.
• Experience with data modeling, data cleansing and database design is a must.
• Strong understanding of data streaming technologies, data aggregation techniques and data wrangling is a significant plus.
• Requires strong technical skills, including knowledge of systems architecture, databases, networking, and programming languages.
• Experience within an Agile centric construct is mandatory (Agile Certifications such as Kanban or Scrum Master are a plus).
• Experience with application performance testing (particularly data streaming performance) is a plus
• Technology and software skills
• Possesses an understanding and solid capabilities in Data Governance and Data Quality management is required.
• Experience with Data Analytics technologies (i.e. Tableau or equivalent) is required.
• Solid working knowledge of SQL (specifically on Oracle dbs) is required.
• Working knowledge of any of the following languages is a plus: Java, R, Python
• Knowledge of data streaming technologies is a plus. Examples: Apache Kafka (or equivalent), Apache Flink (or equivalent), Clickhouse dB (or equivalent columnar db)
• Experience with Atlassian project management tools (JIRA, Confluence) is a significant plus
• Hands on experience and proficiency with the full Microsoft Office Suite, Microsoft Project, Microsoft Visio, SmartDraw.