Job Description :
Business Systems Analyst – Data Management
Location: Pasadena, CA/ Burbank, CA/ Oakland, CA/ Remote
Duration: 6-7 months
Description:
Business Systems Analysts study the overall business and information needs of an organization, in order to develop solutions to business and related technology problems.A business Systems Analyst''s role is usually undertaken prior to the system design, building and programming stages of the systems development process. Works closely with clients to identify business needs and the costs and benefits of implementing a computing solution. Construct IT definitions based on identified needs of the organization. Work with other IT experts to address networking and hardware needs. Devise and document a general system design based on the client''s anticipated requirements. Negotiate options with the client.
Required:
5+ years relevant experience, SQL querying via TOAD, Extensive SQL querying involving multiple table joins, 3+ years of Oracle database and data extract and transformation experience, 3+ years of experience reporting in Tableau front end to large databases or data warehouses, 3+ years of decision support experience required, including preparing financial, accounting or government audit reports, SharePoint, SAS, Visual Basic, Advanced Microsoft Office and Bachelor''s degree. Plus:Medicare experience.
Attachment Description:
Business Systems Analyst - HS
This newly created position is responsible for data management, production support, design and development, and associated project management activities related to managing the sales and marketing information systems that support Medicare. This role''s immediate focus will be focused on the Medicare Total Sales Systems (MTSS
Essential Functions:
- Perform data administration, including MTSS data management and data dictionary maintenance
- Maintain and quality check master data files, Medicare plan coverage and zip codes, facilities, users and access privileges, sales events, fulfillment, etc.
- Upload/transmit Medicare data files to third party vendors
- Define exception handling process, and data purge and retention cycles
- Monitor data quality and integrity
- Extract and merge data from various databases as needed for business reporting and analysis
- Serve as consultant to Medicare in interpreting data and refining business and data transformation logic for reporting
- Respond to MTSS end user/client problems, issues, and requests and resolve interface/data extract issues
- Configure and deploy MTSS data/ system updates for implementation & ongoing maintenance
- Coordinate data configuration support with Sales and Marketing Systems team and third-party vendors
- Respond to MTSS end user/client problems, issues, and requests and resolve interface/data extract issues
- Configure and deploy MTSS data/ system updates for implementation & ongoing maintenance
- Assess, prioritize, and resolve regional Medicare requests for data uploads, e.g., marketing and sales campaign changes, prospect lists
- Collaborate with other team members to perform intermediate to advanced system analysis on software vendor releases, newly submitted ideas, and project changes; and identify specific data/system build configuration or work flow changes.
- Recommend, design, and develop system/data solutions, perform financial analysis, document requirements, improve data processing procedures, perform data configuration changes, conduct/support functional and user acceptance testing, debug/troubleshoot, review & write technical documentation that accompany releases
- Research, configure, test and implement new functionality and related database changes to support business needs
- Work with team members, client IT, marketing database and other business teams through development & implementation of MTSS data changes
Basic Qualification:
- 5+ years (60+ months) relevant experience AND Bachelor''s degree -required
- Extensive hands-on SQL querying involving multiple table joins -required
- 3+ years of Oracle database and data extract and transformation experience. -required
- 3+ years of experience reporting in Tableau front end to large databases or data warehouses -required
- 3 or more years of decision support experience required, including preparing financial, accounting or government audit reports. -required
Assets:
- SharePoint 2013 expertise – required
- Working knowledge of TOAD, SAS and Visual Basic required. – required
- Expertise with Microsoft Office Excel, Visio and Powerpoint. -required
- Proficiency with PC-based query and report writing tools such as Tableau; expert knowledge of spreadsheet and database programs, particularly Microsoft Excel and Access, and expert understanding of relational database and data integrity. -required
- Strong communication skills, ability to keep up with technological changes, techniques and improvements, and apply those to current environment, strong customer service focus, and good organizational and time management skills.
- Understanding of sales or financial information systems.
- Problem solving skills including the ability to research and initiate a data extract and report that answers key questions not answerable using known sources.
- History of becoming an expert on data availability and quality, gathering detailed business requirements, and the creativity to develop workable solutions for a wide range of customers.
- Keen ability to keep up with additional data sources and system changes within client.
- Medicare industry knowledge is preferred but not required –plus!