SQL Server Data Modeler

INT Technologies; Jacksonville (FL); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology firm in Jacksonville, Florida seeks a Data Architect to analyze data requirements and design effective database systems. The role involves developing a flexible data architecture and creating comprehensive reports using SQL Server tools. Candidates should hold a Bachelor's degree in Computer Science or a related field and have expertise in SSIS, SSRS, and SSAS. This position offers the opportunity to work in a dynamic environment, fulfilling various data-related business needs.

Qualifications

• Bachelor's degree in Computer Science or Information Systems (or equivalent).
• Experience with SSIS, SSRS, SSAS, and SQL scripting.
• Strong data modeling and data warehousing design experience.

Responsibilities

• Analyzes data requirements and database schemas.
• Designs and develops database schema to meet system requirements.
• Gathers and analyzes information from business processes.
• Develops database and warehousing designs across platforms.
• Creates reports for clients via Reporting Services/SharePoint.
• Performs other related duties as assigned.

Skills

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

SQL Server Analysis Services (SSAS)

Debugging / development of SQL scripts

Education

Bachelor's degree in Computer Science, Information Systems or equivalent

Tools

SSIS

SSRS

SSAS

SQL scripting

Job description

Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s).

• Designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements.
• Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.
• Develops database and warehousing designs across multiple platforms and computing environments.
• Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.
• Develops reports and provide them to clients via Reporting Services/SharePoint.
• Performs other related duties as assigned.

Qualifications

Top skills/preferences in the role (please include any relevant technologies needed):

Experience with:

• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Debugging / development of SQL scripts
• Bachelor's degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experience

Additional Information

All your information will be kept confidential according to EEO guidelines.

• Please let me know if you might someone to refer or if you are interested for the role.
• Please reply with an updated copy of your resume and preferred time for a call.
• You can call me back at 303.945.3632 .