Data Architect

VTS3 Corp.; Trenton (NJ); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

$500 Referral Fee Program

Job summary

VTS3 Corp. based in Trenton, NJ, is hiring a Business Intelligence Data Architect Consultant to enhance enterprise BI solutions for the Opioid project. This role demands a strong background in database architecture and BI technologies.

The candidate should possess at least three years of experience in BI, specifically with SQL and related database platforms, and must be authorized to work in the U.S. without sponsorship. The position offers opportunities for overtime and a referral fee program.

Qualifications

• At least 3 years of experience in Business Intelligence technology.
• Expertise in BI-related data architecture and integration.
• Ability to construct interactive dashboard and reports.
• Understands common data quality issues.

Responsibilities

• Determine database structural requirements by analyzing operations.
• Develop database solutions by designing proposed system.
• Setting strategies for unique data‑handling needs.
• Deliver health indicators using best‑practice standards.

Skills

Business Intelligence data architecture

Data modeling and presentation

ETL technologies

Microsoft AZURE services

SQL databases

Education

Bachelor Degree in Computer Science, Statistics, Applied Math or related field

Tools

SQL Server

Power BI

Cognos

Tableau

Job description

VTS3 is a Veteran-owned and operated company which provides full-service Recruiting, Talent Search, Staffing, and IT Professional Services. For more information visit www.vts3.com.

Job Description

Our client currently has a job opening for a Business Intelligence Data Architect Consultant. This role will leverage the value of database assets throughout the organization by participating on the Opioid project teams to identify, develop, and deliver enterprise BI solutions. This role reports to the Principal Investigator, who is responsible for ensuring that data capture, transformation, modeling, reporting, dashboarding, and analytics are designed, built, and working in harmony to meet the requirements of the DDPI. Database Architect The Data Architect will design the architecture for big data to be used for the Departments Opioid project, lays the foundation for additional data sources and performs additional duties related to the Department's overall dissemination of health indicators through a carefully designed and friendly dashboard platform.

Responsibilities

• Determines database structural requirements by analyzing the Departments operations, applications used and /or needed, and programming; reviewing objectives with clients; evaluating current systems.
• Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back‑up, and recovery specifications.
• Designing data architectures which includes data integration methodology, schema structures, segmentation needs
• Defining data management which includes data source identification, transformation, and migration planning
• Setting strategies for unique data‑handling needs including encryption, localization, role authorization
• Implementing and ensuring completeness of technical delivery which includes coordinating with systems staff to provide technical components, automate processes, and deliver Business Intelligence (BI) solutions
• Delivering health indicators which includes best‑practice standards, specifications, requirements, and population health value

This is an hourly position with opportunity for overtime.

All Candidates Must be Authorized to Legally Work in the US Without Sponsorship

Qualifications

Mandatory Qualifications

• At least 3 years of experience in the Business Intelligence technology space:
• Expertise in BI‑related data architecture, integration, modeling, and presentation
• Understands BI‑related features and limitations of common database platforms (SQL Server, Analysis Services, Oracle, DB2, Postgres, others)
• Experience with ETL technologies (SQL Server Integration Services, Data Factory)
• Experience with modeling and presentation technologies (SQL Server Analysis Services, Reporting Services, MicroStrategy, Business Objects, Cognos, Tableau, PowerBI, others)
• At least 1 year of experience in Microsoft AZURE and its related service technologies, including:
  1. Active Directory / Data Factory / Data Catalog
  2. HDFS / Data Lake Stores / Analytics
  3. SQL Databases / Warehouses / BISM Stack (SSMS, SSDT, SSIS, SSAS, SSRS)
  4. Analysis Services (Tabular Mode / DAX / Cube concepts)
• Able to plan a solution architecture within an existing client environment
• Ability to quickly learn new tools based on conceptual understanding of technology
• Ability to plan and model data integration processes
• Ability to build data models supporting complex objects (KPIs, hierarchies, custom metrics, perspectives, parameters, geospatial, time‑series, ranking, and predictive content)
• Ability to construct intuitively interactive, visually informative dashboards and reports, incorporating appropriately representative graphics, filtering, and sorting methods
• Ability to write documentation that explains complex technical concepts
• Ability to effectively communicate with senior staff leaders
• Understands common data quality issues and can elaborate on their resolution
• At least 5-10 years as a lead/senior data architect with all of the skills listed above
• Bachelor Degree in Computer Science, Statistics, Applied Math or related field

Preferred Skills

• Database Design, Data Maintenance, Database Security, Database Management, Data Analysis, Requirements Analysis, Teamwork, Technical Zeal, Project Management, Presenting Technical Information, Training, Operating Systems
• Master Degree in Computer Science, Statistics, Applied Math or related field

Additional Information

$500 Referral Fee Program

Earn extra cash while helping your friends!

VTS3 will pay you up to $500.00 for each person you refer to us and we place into a contract or full‑time position. If you know someone who's a good candidate for any of our openings, use the "Refer a friend" button on this page and earn extra cash.

• The referral must be made by using the "Refer a friend" button on this page
• The person you refer must be placed within 90 days of being referred
• The person you refer must complete 480 billable hours
• Cannot be someone we already have on our team or are currently working with

VTS3 ONLY works directly with candidates. All candidates registered must be able to legally work in the United States.

By clicking the link above or any third‑party link within this posting, you are leaving this site and going to a third‑party website where the third‑party website's terms and privacy policy apply