Database Analyst

FCL Dental; Town of Texas, Northern (WI, KY); Hybrid; USD 65,000 - 95,000; Full time

Job summary

FCL Dental is seeking a seasoned Data Analyst to develop, install, maintain, and modify data integration and reporting solutions. You will identify user requirements, analyze data flows, and recommend appropriate applications or modifications.

Responsibilities include investigating user issues, assessing project proposals, participating in the development and testing of applications, transforming client data with SSIS and MySQL, and delivering Crystal Reports and SSRS reports to support decision

Qualifications

• Seasoned Data Analyst with strong SQL skills.
• Experience with ETL processes and data integration.
• Excellent communication with technology partners and users.

Responsibilities

• Investigate user problems and needs, identify their source, and determine possible solutions.
• Analyze user project proposals to identify potential problem areas and recommend optimal approaches.
• Participate in development, implementation, testing of applications software.
• Create data transformations from client data to system formats using SSIS.
• Communicate with clients about data formats and reporting parameters.
• Develop tools and interfaces for application programs and debugging programs.
• Provide system-level support for software and hardware.
• Document programming issues and resolutions for future reference.
• Collaborate with other departments as a software resource.
• Coordinate with third-party vendors on system eligibility files.

Skills

SQL skills

ETL processing

Strong communication

Tools

SSIS

Crystal Reports

SSRS

MySQL

Job description

Develop, install, maintain, and modify application programs, business application programs, or integrated programs. Identify and analyze user requirements and recommend appropriate applications or modifications.

PRIMARY RESPONSIBILITIES

• Investigate user problems and needs, identify their source, and determine possible solutions.
• Analyze user project proposals to include identifying potential problem areas and recommend optimum approaches for project path.
• Participate in the development, implementation, installation, and testing of applications software.
• Create ways to transform data from clients to format that is acceptable to system format. Using SSIS packages to transform data for automation process daily, weekly, or monthly.
• Communicate with clients to discuss format on eligibility files and reporting parameters.
• Contribute through code/algorithm development and other means, for the development of tools and interfaces between application programs and for the development of debugging programs.
• Provide system level support for computer software and computer equipment.
• Participate in the development of training materials and assist in conducting training Investigate, recommend and install new applications.
• Maintain Authorizations and setup workflows for company system communications.
• Document programming problems and resolutions for future reference.
• Assist personnel of other departments as a computer resource and able to work in a team environment.
• Work with a third party vendor regarding issues with current system eligibility file.
• Maintain external website provider search database created with mysql database.
• Handle Public Sector Eligibility file loads and corrections.
• Create and Support Crystal Report and also SSRS implementation
• Other duties as assigned.

REQUIRED SKILLS

• Seasoned Data Analyst with strong SQL Skills
• Understand processing of ETL when creating SSIS packages
• Strong communications skills: work closely with technology partners and system user community