UNIVERSAL Technologies is seeking a highly skilled and seasoned Lead Data Modeling Engineer (LDME) for a hybrid position in Albany, NY. Applicants must be able to work 50% onsite in Albany, NY from day one. Applicants must be able to pass a mandatory ITS Security Agreements and Fingerprint-based Background Check and sign an NDA (non-disclosure agreement). Position: The Lead Data Modeling Engineer (LDME) will analyze the current project relational database schema of the client’s legacy claims’ systems and lead all data integration, migration, and conversion activities for the new claims’ systems. WHO WE ARE: UNIVERSAL Technologies, LLC is a Women-Owned (M/WBE) IT solutions and consulting company focused at delivering enterprise systems that significantly improve our clients IT performance. We work across the IT spectrum including Development, Business/Systems/Data Analysis, Project Management, Cyber Security, Network Engineering, and High-Level System Architecture. The pride in the services we provide and the accessibility and flexibility we provide to employees are what make Universal Technologies stand out from the rest! We hope to propel your IT career to the next level and excite our employees with new and challenging projects. WHAT WE OFFER: Our W2 employees can expect the following benefits:
Competitive pay
Health/Dental Insurance
Group Life Insurance
401K
HSA/FSA
Pre-Tax Transportation Program
Generous Paid Time Off/Holiday Policy
MANDATORIES:
Bachelor’s degree or equivalent combination of advanced education, training, and experience will be considered.
Minimum of 8 years of relational database modeling, including conceptual, logical, and physical, in support of the development and successful implementation of at least 2 major application development modernization projects in the role of the Lead Data Modeling Engineer (LDME).
Minimum of 4 years leading, designing, and executing data migration and conversion solutions using ETL tools such as Informatica, including data profiling activities.
Minimum of 4 years implementing information management strategies, including master data management solutions.
Skills in SQL, data profiling, source-to-target data mapping, and scripting are crucial.
Proven track record in system modernizations and all aspects of Data Modeling (e.g. conceptual, logical, physical) and associated data conversion/cleansing/migration activities, including source-to-target mappings.
Strong written and verbal communication skills.
Experience implementing master data management solutions in support of critical business functions.
JOB DUTIES:
Collaborate closely with Business Subject Matter Experts (SMEs) and Business Analysts through the process of detailed business functional requirements elicitation.
Analyze detailed business requirements and business needs to create long-term data strategies.
Analyze the current project relational database schema.
Design and maintain conceptual, logical, and physical relational database models.
Create and implement Master Data Management strategies to eliminate redundant data related to Employer and Claimant entities.
Lead all data integration, migration and conversion activities including a team of data developers who will be responsible for moving and cleansing data from the current client’s system databases to the new databases.
Assess existing legacy databases, develop migration and conversion plans, and execute the data transfer process using data integration (ETL/ELT) tools such as Informatica.
Review and make recommendations to improve existing data quality program.
Perform data profiling and reviewing outcomes with Technical and Business Subject Matter Experts.
Assist with and provide support for teams responsible for data warehouses/marts, replication of the OLTP databases, delivery and ETL systems by determining structural requirements and developing data system schematics.
Develop complete database solutions by designing logical models and defining database physical structure and functional capabilities, security, and recovery specifications.
Create and maintain a data dictionary including element-level technical and business definitions and metadata.
CLIENT’S CURRENT ON-PREM ENVIRONMENT:
Legacy
PowerBuilder version 10.5
Sybase Adaptive Server Enterprise/16.0 SP03 PL04/EBF 27869
.NET MVC and Core
Microsoft SQL Server Data Warehouse
Pentaho
Erwin Data Modeler
Microsoft Azure Gov Cloud (Primary Products):
.NET Core
Angular
Docker
Kubernetes
Service Bus
SQL MI
Azure Data Factory
CI/CD Pipelines
Primary Integrations:
Trumpia (SMS/Email correspondence)
FileNet P8 (Document storage)
NY.GOV ID (backed by OKTA) for user authentication
Printing and Mailing
Office 365
ADFS
UNIVERSAL Technologies is an Equal Opportunity Employer.