Database Objects jobs near me - 16 jobs

Be Here. Be Great. Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group's member companies are subsidiaries of American Financial Group. We combine a "small company" culture where your ideas will be heard with "big company" expertise to help you succeed. With over 30 specialty and property and casualty operations, there are always opportunities here to learn and grow. At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best. P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. IT Services can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors. The Quality Assurance team within P&C IT Services is seeking a Data Quality Assurance Lead to work a hybrid schedule out of the Cincinnati office. Scope of Job: Provide Expertise in ETL, Snowflake, Python , test automation in data testing Performs moderately complex test case/procedure development, test management functions and tasks. Performs moderately complex analysis of requirements, test coverage and impact of proposed requirements changes. Conducts peer reviews of test artifacts. Performs work under moderate supervision and ability to lead a small team of employees and contractors May serve as an agile development team member, creating and testing the product increment. Knowledge, Skills and Experience Essential Job Functions and Responsibilities: 8 to 10+ years of experience in ETL testing, BI testing, 3 to 5 years of experience in leading the team Planning, Monitoring and Control of Testing Activities and Tasks. Experience in creating/analyzing simple to complex SQL. Create, design, and execute the test plans and test cases which covers ETL process and Data Warehouse validation Knowledge on Database objects and relational data models. Good understanding of various database technologies (DB2, Teradata, Oracle 10g/11g, SQL server, Big data/Hadoop) Knowledge of any Cloud (MS Azure, IICS, Snowflake) based testing. Should have exposure to Oracle SQL Developer, Toad, Hive, Toad Data point etc., Good exposure to Data automation validation tools like Informatica DVO, Katalon etc. Data automation using Python is good to have. Good exposure in executing Functional, Regression, Integration and E2E testing. Knowledge on Insurance Domain is plus Good exposure to agile testing process, test strategy planning and implementation, test execution monitoring and reporting. Play a major role in championing the importance in quality improvement across all areas of Software Development Lifecycle. Collaborate with Project teams to understand the business use case and build a data testing strategy Lead and Mentor Data QA team members Coordinate UAT in their E2E Testing Work on Continuous improvements on the processes Excellent verbal and written communication skills Experience and desire to work in a Global delivery environment. Business Unit: Property & Casualty IT Services Benefits: Compensation varies by role, position level, and location. Individual pay is influenced by skills, education, training, certifications, experience, and the role's scope and complexity, along with business needs. We offer a competitive Total Rewards package, including medical, dental, and vision plans starting on day one, PTO, paid holidays, commuter benefits, an employee stock purchase plan, education reimbursement, paid parental leave/adoption assistance, and a 401(k) plan with company match. These benefits are available to eligible full-time and part-time employees. Your recruiter can provide more details about our total rewards and specific compensation ranges during the hiring process.

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers. Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services. Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps. USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness. Senior DATA MODELER 6+ Months Columbus, Oh. Need GC,USC,GC-EAD,TN MUST HAVE SKILLS - Create data models from scratch, OLTP, SQL (very complex) and relational Top Three Skills: advanced SQL (join tables, what is an interjoin, group buys, subqueries, windowing functions (analytics)), OLTP (online transactional processing) and relational modeling Job Description: The Data Modeler advises the enterprise application teams on data architecture, relational and dimensional database design and modeling, efficient SQL development, and best practices for the IT data development staff as it relates to data management. The position assists IT staff as well as business partners in profiling and understanding their data. The position must communicate clearly and effectively, collaborating with IT and business teams in order to deliver timely and effective solutions. The Data Modeler is expected to be creative and provide lateral thinking, all the while being proactive in finding solutions to the enterprises data needs. Responsibilities: - Develops and maintains data models (logical and physical) for operational and analytical systems in the Enterprise - Maintains the ERWIN model repository and ensures the models are current - Creates and executes DDL in development environments for any new and/or revised database objects - Works closely and communicates effectively with the IT development staff on providing the best data design solutions for their needs - Documents data mappings for integration development teams. - Works to promote the enterprise's data governance standards - Reviews and Approves requests pertaining to database objects in a timely manner. Additional Information If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on ************.

FirstEnergy at a Glance We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger. FirstEnergy (NYSE: FE) is dedicated to integrity, safety, reliability and operational excellence. Headquartered in Akron, Ohio, FirstEnergy includes one of the nation's largest investor-owned electric systems, more than 24,000 miles of transmission lines that connect the Midwest and Mid-Atlantic regions, and a regulated generating fleet with a total capacity of more than 3,500 megawatts. Preferred work location is Akron, OH This is an open position with FirstEnergy Service Company, a subsidiary of FirstEnergy Corp. [SC00] Members of the OT System Administration team manage the application software to support FirstEnergy's Energy Management System (EMS) and Distribution Management System (DMS). DMS contains two major components Distribution (Dx) SCADA and the Network Management System (NMS) used for advanced applications and Outage Management (OMS). The team focuses on ensuring a world class EMS and DMS system for use by Transmission and Distribution Operations. This position is focused on the administration and development of vendor software platforms (GE/Alstom eterra and Oracle NMS) as well as interfaces to systems. Key skills include vendor management and related system administration, scripting, and development to ensure a cohesive OT Systems landscape built with components from various vendors. Members of this team are expected to specialize in an area, as well as provide general support for the entire OT Systems landscape. System Administrators have a fundamental responsibility to ensure the computing health of the overall OT Systems Landscape. Members of the team must ensure compliance with industry standards and regulatory requirements, including NERC CIP and NJ ICS standards. JOB RESPONSIBILITIES: ALL: Support a diverse OT Systems landscape including a combined EMS/DMS OT Systems Administration team and a combined OT Systems Advanced Applications Team including SCADA Installs, Manages and Tunes complex software applications and mission-critical real-time architecture that supports transmission and distribution operations 24x7x365 with zero downtime - utilizing real-time databases, software and networking technologies and an emphasis on Real-Time Systems (RTS) practices and standards Developing and maintaining integrations between systems and components of systems Understand the structure and design of application databases. Assist with the ETL development as necessary using vendor specific tooling, bulk/batch import/export processes, Perl, Oracle SQL and PL/SQL following RTS best practices. Utilize approved tooling to customize vendor applications and write custom applications using C++, C#, Perl, Python and when necessary Java. Manage, compare, configure, build and debug vendor software that comprises these systems and work with internal, contact and vendor resources to resolve issues and effectuate enhancements to these vendor platforms. Manage the compilation, deployment and testing of patches and software upgrades across numerous environments Perform system security administration tasks. Solve complex problems and troubleshoot functionality for issue identification (including debugging); work in conjunction with other IT personnel across various teams and departments. Manage code, scripts and other artifacts in source control tools to ensure governance and providence of deployed software Develop technical designs specific to the RTS landscape to meet business needs while supporting the overall direction and standards of RTS. Be an active participant in the collaboration of managing and maintaining OT Systems based on IT needs, business requirements and regulatory pressures. Support real-time data acquisition and control of the electrical grid in a reliable and secure manner. Work with enterprise server, storage, networking, datacenter, NOC and desktop teams to deliver robust redundant real-time system and data collection architectures. Standardize on common platforms, integration methodologies, coding languages and tool sets across OT Systems. Develop data queries and reporting solutions to meet customer requirements both internal and external to the team. Execute work to assure on-scope, on-schedule, and landscape compliant deliveries with excellent attention to detail. Excellent communication skills and a desire to clearly communicate in both written and oral mediums to peers on the team and department leadership. Ability and willingness to travel to company sites, work flexible hours, and be available for call-in and after-hours support (7X24 operations). Eager and active participant in training activities - including training activities at remote vendor locations as required by supervision to become proficient in vendor tool sets. Exhibits FE's Core Values & Behaviors EMS: Support the GE (legacy Alstom) eterra Habitat database platform, eterra Archive based Oracle platform, PI Historian and/or LiveData RTI interfaces. Support the GE (legacy Alstom) eterra Platform suite of advanced applications for Transmission electrical system support Support GE (legacy Alstom) eterra Control module running on the EMS Front End Processors (FEP) Support data extraction and transformation through the GE (legacy Alstom) eterra provided tool set as well as PERL scripts. DMS: All EMS items, plus the following: Support GE (legacy Alstom) eterra Distribution module for building electrical models for simulator use Maintain interfaces between FirstEnergy IT systems, including LiveData RTI platform and integrations to the Oracle NMS platform NMS: Manage Oracle Network Management System (NMS) software, including database technologies, schemas, and associated application database administration Develop Oracle database objects, SQL scripts and interfaces using industry standard tools Develop custom applications, including .NET, to augment the overall DMS landscape QUALIFICATIONS Required: Bachelor of Science degree in Computer Science, Information Systems Management, Electrical Engineering, Electrical Engineering Technologies a similar related technical discipline, or commensurate experience. Commensurate experience includes but is not limited to an additional 4 years of professional experience working with EMS/DMS/OMS systems beyond what is required below. For levels 3 and above, required experience from at least one of these two experience categories, higher levels require additional years of experience A minimum of 2 years of experience with GE (legacy Alstom) eterra systems - including but not limited to one or more of the following: eterra Habitat, eterra Platform, eterra Control, eterra Source and associated tools. Experience in the following specific areas is preferred: Experience with GE (legacy Alstom) eterra EMS/DMS system components, software and management principles. Ability to manage PROCMAN, CFGCTRL, NETIO, ISD and associated system configurations, code, and architectures. Experience performing Habitat system builds Experience with hdbrio, hdbimport/export, HabConnect tools Familiarity with eterra database schemas including SCADAMOM and/or ALARM A minimum of 2 years of experience with Oracle NMS systems. Experience in the following specific areas is preferred: Experience developing custom ETL integrations for OMS dashboards Experience developing custom applications for OMS reporting and health Experience with High-Availability zero down time architectures where NMS was deployed A minimum of 4 years architecting, developing, or administrating in a major SCADA vendor's platform that is not the eterra or NMS system: Major vendors shall be determined to be acceptable based on similar data sizes, application complexities and deployment methodologies. Similar technical complexities to the various areas requested shall be able to be explained by applicants. Highly motivated to work independently and productively within a virtual environment (i.e. working with remote co-workers using virtual technologies). Demonstrated ability to work effectively as part of a team. Demonstrated ability to effectively prioritize and plan work, work on multiple concurrent tasks, and meet deadlines. Proven ability to troubleshoot and solve non-routine problems with little or no guidance. Willingness to openly share knowledge with others on the teams. Ability to be on-call 24x7 Preferred: Proven track record of implementing IT software projects or upgrades. Experience with IT general controls which include but are not limited to change management, release management, and cyber security policies and procedures Functional knowledge of Relational Databases Experience with Oracle databases with proven ability to develop SQL Queries, Stored Procedures, Packages, and Views. Proven ability to troubleshoot and solve non-routine problems with little or no guidance. Knowledge in areas such as security, network, integration. Knowledge of dynamic routing protocols such as EIGRP, OSPF, BGP. Knowledge of MPLS transport systems. Working knowledge of IP network communications architectures including routing and switching, DNS, TCP and UDP communications. Knowledge of firewall ruleset management practices. Knowledge in Active Directory integration activities such as multi-domain forests and their interaction with complex applications. Experience with databases, particularly Habitat and/or Oracle. Database replication, partitioning and failover experience preferred. Computer programming or scripting skills such as C++, C# , .NET, Perl Electrical background in Power Systems Engineering or Communications Engineering Experience with DNP3.0 SCADA protocol. Experience with RS232, RS485 communications. Working knowledge of industry standard SCADA Commissioning practices -Direct SCADA design experience, (DNP, RTU configurations, etc) while potentially helpful for this position, does not count as experience in a System Administration Role. Benefits, Compensation & Workforce Diversity At FirstEnergy, employees are key to our success. We depend on their talents to meet the challenges of our changing business environment. We are committed to rewarding individual and team efforts through our total rewards philosophy which includes competitive pay plus incentive compensation, a company-sponsored pension plan, 401(k) savings plan with matching employer contribution, a choice of medical, prescription drug, dental, vision, and life insurance programs, as well as skills development training with tuition reimbursement. Please visit our website at *********************** to learn more about all of our employee rewards programs. FirstEnergy proudly supports workforce diversity. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, or status as a qualified individual with a disability. No recruiters or agencies without a previously signed contract. Unable to sponsor or transfer H-1B visas at this time. Safety Safety is a core value for FirstEnergy and is essential to all of our business activities. We ensure employees have the tools, information, and processes to perform their duties in a manner that assures safety for themselves, their co-workers, our customers and the public. Our goals are to provide a safe work environment, to maintain an accident-free, injury-free workplace, and to promote and maintain public safety. To meet these goals, we dedicate ourselves to achieving world-class safety standards. Position Classification Exempt FirstEnergy Human Resources Team

Job Description At FEI Systems, we create innovative technology solutions to improve the delivery of health and human services because we know when cumbersome administrative processes stand in the way, those who need it most are often left without access to proper care and support. From comprehensive case management software to disaster recovery services and content management information systems used in delivering foreign aid, our solutions are improving the lives of millions of people. We're looking for a database developer who shares our commitment to leveraging technology to make a real impact in the world - a professional who knows, beyond all else, that the quality of our products and services is only as good as the company we keep. Position Overview We are seeking an experienced SQL Server and ETL/Migration Developer to join our agile development team. This role focuses on designing reliable database solutions, developing data integration processes, and collaborating across technical and business teams to deliver high-quality data systems that drive organizational decision-making. Primary Responsibilities Database Design and Administration Coordinate with the Development Manager and System Administrators to design stable, reliable, and scalable databases that meet business requirements. Modify and enhance existing databases to support evolving application needs and performance demands. Implement recovery tactics and database security measures to protect data integrity and ensure business continuity. Data Integration and ETL Development Develop and maintain ETL processes that extract, transform, and load data across various systems and platforms. Create efficient data pipelines that ensure accurate and timely information flow to support analytics and reporting needs. Optimize SQL queries, stored procedures, and database objects for performance and reliability. Collaboration and Best Practices Work closely with software developers to establish and enforce best practices for database storage, organization, and data architecture. Interface effectively between business groups and IT teams to translate requirements into technical solutions. Participate in code reviews, architectural discussions, and technical planning sessions to ensure quality and consistency. Performance Monitoring and Optimization Support the development of KPIs to evaluate and monitor database performance metrics. Analyze system performance and recommend optimizations to improve efficiency and scalability. Evaluate current and emerging database products and services, making recommendations for improvements or new implementations. Agile Development Participation Work within an Agile/Scrum product development process, participating in sprints, stand-ups, and planning sessions. Break down complex database initiatives into manageable tasks that align with sprint goals. Collaborate with cross-functional teams to deliver iterative improvements and new features. Documentation and Support Develop comprehensive technical and functional documentation that complies with audit requirements. Create user guides and training materials to support database users at all organizational levels. Respond to support requests, troubleshoot bugs and issues, and provide timely resolutions to maintain system reliability. Continuous Improvement Apply best engineering practices including architectural paradigms, branching strategies, task management, and thorough testing. Contribute to the team's technical growth through knowledge sharing and mentorship. Demonstrate strong critical thinking and problem-solving skills with a proactive "make it happen" attitude. Required Skills and Qualifications Experience and Education 5+ years of experience as a Database Developer Bachelor's degree in Management Information Systems, Computer Science/Engineering, or related discipline (4+ years of direct industry experience may be substituted) Technical Expertise Proficient in SQL and SQL Server development Knowledge of database recovery tactics and security protocols Understanding of best engineering practices in agile software development Experience with code reviews, version control (branching), task management, documentation, and testing Professional Skills Strong interpersonal skills with proven ability to interface effectively between business groups and IT teams Excellent critical thinking and problem-solving abilities Self-motivated with a "make it happen" attitude and ability to work independently Experience working in Agile/Scrum environments Location: Remote Status: Full-time position with full company benefits NOTICE: EO/AA/VEVRAA/Disabled Employer - Federal Contractor. FEI Systems participates in E-Verify, a federal program that enables employers to verify the identity and employment eligibility of all persons hired to work in the United States by providing the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization. For more information on E-Verify, please contact DHS at **************. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, political affiliation, disability, or genetic information, except where it relates to a bona fide occupational qualification or requirement. FEI Systems creates an Affirmative Action Plan on an annual basis. Pursuant to federal law, the portions of FEI Systems' Affirmative Action Program that relate to Section 503 (Persons with Disabilities) and/or Section 4212 (Protected Veterans), are available for inspection upon request by applicants and employees during FEI Systems' normal business hours.

Job Description An IFS Developer is responsible for designing, developing, customizing, and maintaining solutions within the IFS Applications ERP ecosystem. This technical role requires a deep understanding of business processes as well as strong programming and analytical skills. The developer collaborates with cross-functional teams-including IT, business analysts, and end users-to deliver scalable ERP enhancements that improve business efficiency and innovation. Duties & Responsibilities: Solution Development: Design, develop, and implement customizations, integrations, and extensions within IFS Applications using relevant programming languages and tools such as PL/SQL, IFS Report Designer, and web technologies. System Analysis: Analyze business requirements in collaboration with stakeholders to translate them into effective technical solutions within IFS. Application Support: Provide day-to-day support for IFS Applications, troubleshooting issues, resolving incidents, and ensuring optimal system performance. Enhancements & Upgrades: Lead or participate in projects related to system upgrades, new module implementations, and process improvements. Creation of Custom Pages, Fields, Menus, Tabs and Events. Use Citrix Build Place/Harvest to deploy changes. Base Server Development, Forms Development, Integration Development, Reports Development, Data Migration, Custom Objects, Lobbies, Configurations, User Administration and IAL in IFS. Integration: Develop and maintain integrations between IFS Applications and other business systems using web services, REST/SOAP APIs, and third-party middleware. Documentation: Create and maintain comprehensive technical documentation, including solution designs, modification/change logs, and user guides. Preserve changes in Visual Studio. Quality Assurance: Perform unit testing, participate in user acceptance testing, and ensure all delivered solutions meet business requirements and quality standards. Collaboration: Work closely with business analysts, project managers, and end users to understand business processes and support continuous improvement. Security & Compliance: Implement and monitor system security and ensure solutions comply with relevant data protection and business continuity standards. Training: Deliver training sessions, workshops, or user support as needed to help internal teams maximize their use of IFS Applications. Qualifications & Requirements: Education: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. Technical Proficiency: Experience with IFS Applications ERP, IFS Developer Studio, SQL, PL/SQL, PowerShell and web technologies such as HTML, JavaScript, and XML. Proficiency in Visual Studio. Experience in Oracle database objects: Procedures, Functions, Packages, Triggers, Cursors, Tables, Views, DB links and Complex queries Business Process Knowledge: Familiarity with core business processes such as finance, supply chain, manufacturing, part management, sales, and CRM as they relate to ERP functionality. Problem-Solving: Strong analytical and troubleshooting skills with the ability to resolve complex technical issues. Project Management: Experience managing or working within software development projects, including meeting deadlines and coordinating with multiple stakeholders. Communication: Excellent verbal and written communication skills for effective collaboration and documentation. Adaptability: Ability to quickly learn new technologies and adjust to changing business requirements. Attention to Detail: Commitment to delivering high-quality work and ensuring accuracy in coding, testing, and documentation. At least 5 years of development experience supporting IFS ERP Applications IFS Certification: Formal certification in IFS Applications or related modules. ERP Implementation Experience: Prior involvement in full-cycle ERP implementations, upgrades, or migrations. Integration Expertise: Hands-on experience integrating IFS Applications with other ERP systems or cloud-based solutions. Reporting Tools: Experience with IFS Business Analytics, SSRS, Crystal Reports, and Power BI reporting platforms. Software Development Life Cycle right from inception, requirement specifications, planning, design, testing, implementation, and maintenance. Experience with Microsoft SharePoint Online, Power Apps, and Power Automate (Flow) Practical experience with Microsoft Office Suite (Access, Excel, Outlook, Word) Schedule: Fulltime Standard office hours with flextime Ideally located in PLP's Corporate office - 660 Beta Drive Benefits: 401(k) with a company match equal to 25% of the first 8% of pre-tax dollars contributed by the employee for the first two years Enrollment in company profit sharing after two years Medical, dental & vision insurance, including free preventative care Wellness & Employee Assistance Program (EAP) Health care flexible spending accounts, health savings accounts, & life insurance Paid time off, paid company holidays, and vacation purchase program Short & long-term disability Parental & family leave; military leave Inclusive & welcoming company culture Career development & tuition assistance Student loan debt repayment program Click here for additional information

OPEN JOB: Consultant, Senior Oracle Applications r12 Techno/Functional Developer TYPE: FULL REMOTE contract (must work EAST COAST HOURS) DURATION: 12 months NOTE: US CITIZENS OR GREEN CARD ONLY , NO C2C RESPONSIBILITIES: Analysis and Design Consults with Business Analysts to identify and analyze technology needs and problems. Performs data flow diagramming and/or process modeling (code architecture). Writes technical specifications for application components. Prepares estimates for design, coding and testing. Designs complex software and database objects. Development and Testing Develops new complex features and functions for software applications. Strong understanding of complex cross-platform and cross-application integration techniques. Identifies complex integration and user acceptance test scenarios. Provides programming support through all testing phases and general releases of software. Adheres to department programming standards and methodology. Performs peer and lower level code reviews. Mentor lower level developers Adheres to department programming standards and methodology. Experience working in an “Agile” environment is a plus. Delivery and Installation Prepares pre-release and release process documents including Change Control, contingency and fallback Plans. Assists the Infrastructure group with configuration and deployment of new systems. Production Support Takes ownership of functional issues by identifying underlying problems, analyzing potential solutions and implementing system resolutions, including workarounds. Provides front-line user support related business applications. Work to be performed includes answering, documenting, analyzing, tracking, escalating and responding to application support requests. Participates in functional analysis for production support activities. Applies department change control policies & procedures. Coordinates with other IT departments on integrated system support. Conducts end-user training for supported business applications. Conduct functional analysis for production support activities. Identify complex problems and analyze potential solutions including workarounds. Perform tuning, repairs and/or maintenance to production applications. Work with other IT departments on integrated system support, as required. Administrative Works as a member of a cross-functional, integrated development team. Communicates plans, status and issues to management on a regular basis. Adheres to department standards, policies, procedures and industry best practice Qualifications: Minimum 6 years of experience developing multi-tier applications in a business environment. Minimum 5 years of experience in developing RICE components within Oracle EBS R12 environment Minimum 3 years of experience in developing custom APIs in an on-prem based environment Expert in SQL, PL/SQL Strong tuning experience Expert working with relational databases platforms Oracle EBS R12 experience Working understanding of Graph Database Good understanding of deployment strategies for distributed and multi-tiered applications. Knowledge of Software Development Life Cycle methodologies. Knowledge of relational database concepts and database management systems. Knowledge of the UNIX operating system (especially Linux), and UNIX development tools and environments. Experience developing/deploying application for cloud environment Knowledge of Entertainment industry business practices preferred Advanced knowledge of java. Knowledge of AWS. Working knowledge of UNIX shell scripting. Understanding in as many of the following business processes: P2P, OTC, Project Accounting, Inventory, WIP, BOM If you are interested in pursuing this opportunity, please respond back and include the following: MS WORD Resume Required compensation. Contact information. Availability Upon receipt, I will contact you to schedule a convenient time to discuss the position. Steve Fleischner Recruiting Manager INTERMEDIA GROUP, INC. EMAIL: ************************* LINKEDIN: ********************************************

Job Details Corporate Headquarters - Cleveland, OH $65000.00 Salary/year Description About Us: Midwest Direct was founded in 1982 as a provider of mail presorting operations. Helping companies in a variety of industries with their personalization and direct mail service, our technology has advanced to the point where just one of our machines can sort up to 50,000 pieces per hour! Midwest Direct helps our clients efficiently create and deliver their print, mail and digital messages with the best audience data for targeted and accurate deliverability. When you add in our additional delivery channels, such as email, Informed Delivery, and online advertising, we average over two million messages a day delivered to mailboxes, inboxes and online. We are committed to doing the right thing, the right way, and our culture is guided by four core values: Caring, Teamwork, Creativity, and a Passion for Excellence. These values shape how we collaborate, solve problems, innovate, and serve our clients. As we continue to grow, we are looking for a hardworking, organized, and dedicated individual who shares these principles and is eager to contribute in a supportive, fast-paced environment Midwest Direct is looking for a Junior SQL/Web Developer! **$500 Sign-On Bonus!** Role Overview: This position is primarily an SQL application development role, focused on building and enhancing the internal tools, data workflows, and application logic that support our production and communication systems. While basic web development skills are helpful, the core of this job is SQL-driven application development that powers operational visibility, reporting, automation, and data movement across the company. You will collaborate with senior developers, operations leaders, and technical teams to turn business requirements into functional data applications that help drive performance, quality, and efficiency. Job Duties: Write, test and optimize SQL queries, stored procedures, views and functions to support our operational data systems. Assist in designing and maintaining databases to support new features and operational dashboards. Build and enhance web-based user interfaces or portals (for example internal dashboards, data entry screens, reporting tools) that integrate with SQL data stores. Collaborate with operations, analytics and IT teams to gather requirements, translate them into technical solutions, and deliver. Troubleshoot data and application issues - for example performance bottlenecks, query inefficiencies, data integrity issues. Document database objects, application modules, user workflows and maintain development standards. Participate in code reviews, learn from senior developers, and progressively take on more responsibility. Schedule: Monday through Friday Hybrid flexibility Core Hours: 9AM - 4PM Compensation: $65,000 or higher annually based on experience BENEFITS TO JOINING MIDWEST: - Paid vacation and holidays - Medical, Dental, Vision, & Life Insurance - 401k plans and match - Employee referral bonuses - Public transportation benefit Qualifications/Skills: Strong proficiency with SQL (MySQL, SQL Server, PostgreSQL, etc.). Understanding of query optimization, joins, stored procedures, and data structures. Some experience or coursework in web application development (HTML/CSS, JavaScript, .NET, PHP, Node.js, etc.) Strong analytical mindset, attention to detail, and problem-solving skills. Ability to work collaboratively across multiple departments. Bachelor's degree in Computer Science, Information Systems, or equivalent experience preferred. Excellent communication skills, organization, time management, and willingness to learn. What We Offer: Clear growth path toward full-stack development or advanced data engineering roles. Hybrid work flexibility with hands-on exposure to production operations. Competitive salary and full benefits. Mentorship and professional development. A culture where your work has visible, daily impact

Job Title: Data Engineer Design and develop microservices using Java Spring Boot for fund allocation, trade creation, portfolio rebalancing, and reporting services. Develop and expose RESTful APIs to handle cash movement, investor transactions, lending operations, and compliance alerts. Build a Kafka-based event-driven architecture, allowing asynchronous processing of key financial events (trade initiation, rebalancing signals, shareholder activity). Define and manage Kafka topics and consumer groups for modular and fault-tolerant data pipelines across trade and cash management domains. Conduct performance optimization for backend APIs to reduce latency in NAV (Net Asset Value) computation and high-frequency trade processing. Integrate APIs for Shareholder Activity, Position Lookup, Lending Services, and Warnings, enabling seamless multi-system orchestration. Perform in-depth analysis of legacy SQL stored procedures used in historical reporting and fund accounting. Extract undocumented business logic from complex SQL code and map legacy workflows to modern service-oriented architecture. Devise a migration and integration plan to transition critical stored procedures into microservices or event-driven components in the new system. Collaborate with data architects to restructure legacy database objects for compatibility with new cloud-native and real-time processing systems. Document data lineage, dependencies, and archival strategies to ensure business continuity and regulatory compliance. Build end-to-end UI automation test suites using Cypress and JavaScript to validate trading workflows and investor interactions. Create reusable test modules covering critical workflows including fund rebalancing, portfolio reporting, and user approvals. Integrate Cypress tests into CI/CD pipelines, supporting continuous testing and minimizing defects in production. Coordinate with QA and business stakeholders to translate requirements into test scenarios and acceptance criteria. Requirement: Applicants must have a Master's degree or foreign equivalent in Computer Science, Computer Applications, Information Technology, Engineering (any), or related fields. Travel/relocation required as jobs will be performed at various unanticipated locations throughout the United States.

Senior Oracle APEX Developer IIEmployment Type: Full-Time, Entry-Mid LevelDepartment: Information Technology CGS is hiring a Senior Oracle APEX Developer to support a range of IT services, including software application support, enterprise infrastructure support, service desk, ITSM, deskside support, workstation engineering and maintenance, telecommunications and mobility engineering services, managed print services, Active Directory services, and video conferencing. The ideal candidate will be personable and articulate and will focus on making sure that the customer's needs are met quickly and effectively. The successful candidate will be a self-starter who can work with limited supervision. Excellent communication skills are required to effectively interface with customers to understand requirements and mission needs, and then be able to translate them into actions. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success- Work at the direction of the program manager to support the full lifecycle development of custom Oracle Applications, primarily using the Oracle APEX toolset.- Perform advanced use of Oracle APEX 4.0 and above.- Perform work with Oracle Integrated Development Environments such as Quest Toad and Oracle SQL Developer.- Design and manipulate web content dynamically using JQuery, Ajax, JavaScript, CSS, and HTML.- Create dynamic reports within the Oracle APEX environment. Provide support in the advanced use of Oracle Database products version 11 and above.- Provide support for Oracle database objects - tables, indexes, directories, sequences, triggers, etc.- Provide support with PL/SQL, Java, Windows PowerShell, and Unix shell scripting with familiarity with built-in PLSQL packages and procedures.- Provide support with storage, efficient retrieval, and manipulation of unstructured data (BLOBs, CLOBs, JSON, XMLType) in an Oracle environment.- Integrate and manage BI Publisher templates and web Services.- Successfully deliver enterprise-level workflow-centric applications.- Build logical functions and algorithms to automate business processes. Qualifications- Bachelor's degree with 8+ years experience. A High School diploma with additional years of experience and/or relevant certifications may be considered in lieu of a degree.- U.S. Citizen.- Ability to obtain and maintain a public trust security clearance.- Experience with secure network programming in an Oracle environment; use of security certificates, HTTPS callouts, etc.- Experience with full lifecycle development of custom Oracle Applications, including the Oracle APEX toolset.- Experience with the use of Oracle Integrated Development Environments such as Quest Toad and Oracle SQL Developer.- Experience with JQuery, Ajax, JavaScript, CSS, and HTML.- Experience with PL/SQL, Java, Windows PowerShell, and Unix shell scripting with familiarity with built-in PLSQL packages and procedures.- Experience with storage, efficient retrieval, and manipulation of unstructured data (BLOBs, CLOBs, JSON, XMLType) in an Oracle environment.- Experience establishing goals and meeting project plan objectives.- Must be able to write and maintain system documentation on work products.- Excellent communication and teamwork skills.- Agile development experience.- Customer interface experience. Ideally, you will also have: - Experience with Oracle Database products version 11 and above.- Experience with Oracle Forms and Reports version 10G or higher.- Experience with Oracle APEX 4.0 and above.- Experience troubleshooting operational issues.- Government contracting experience, particularly with the DOJ.- Current DOJ Clearance. Our Commitment : Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come. We care about our employees. Therefore, we offer a comprehensive benefits package.- Health, Dental, and Vision- Life Insurance- 401k- Flexible Spending Account (Health, Dependent Care, and Commuter)- Paid Time Off and Observance of State/Federal Holidays Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Join our team and become part of government innovation! Explore additional job opportunities with CGS on our Job Board:************************************* For more information about CGS please visit: ************************** or contact:Email: ******************* #CJ

SSIS Developer 6 month contract to hire Dayton, OH Consultant must be Greencard holder or Citizen Top Skills: 1) 7+ years of ETL (SSIS) development experience 2) Experience working in an agile environment 3) Strong overall SQL & DW knowledge 4) Healthcare experience Job Description: Responsibilities: • Expand the company's use of data as a strategic enabler of corporate goals and objectives. • Facilitate information gathering sessions and provides data analysis and data mapping. • Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports. • Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process. • Have the ability to facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs. • Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements. • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security. • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments. Qualifications: • Hands on ETL development in tools such as SSIS • Working experiences in design and modeling normalized and dimensional (e.g. star schema) data warehouses. • Self-motivated team player who excels in a collaborative environment. • Strong sense of accountability, adaptability, flexibility and a sense of urgency. • They should have a bias for action and achieving results for themselves as well as their team. • Excellent analytic and problem solving skills. • Ability to work effectively with associates at all levels within the organization. • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes. • Proven ability to handle multiple tasks and projects simultaneously. • Familiar with the Agile Methodology. • Excellent analytical skills, attention to detail, and problem-solving skills. • Self-motivated team player who excels in a collaborative environment. • Strong sense of accountability, adaptability, flexibility and a sense of urgency. • They should have a bias for action and achieving results for themselves as well as their team. • Passionate about continuously improving organizational practices. Ability to learn and apply new technologies quickly and self-directed. • Familiarity and working knowledge of SQL Server Database, SSIS, SSAS, Kalido DIW and Kalido MDM is a plus. Additional Information If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on ************.

Lumen connects the world. We are igniting business growth by connecting people, data and applications - quickly, securely, and effortlessly. Together, we are building a culture and company from the people up - committed to teamwork, trust and transparency. People power progress. We're looking for top-tier talent and offer the flexibility you need to thrive and deliver lasting impact. Join us as we digitally connect the world and shape the future. **The Role** Lumen is seeking a highly skilled Lead Software Engineer to join our Enterprise Billing space, specifically supporting the Post Billing team. In this role, you will collaborate with team Architects, Product Owners, and Developers to ensure billing solutions are developed accurately and on time. You will play a key part in launching new products, integrating them into our billing ecosystem, and ensuring seamless post-billing operations. Additionally, you will contribute to strategic initiatives such as migrating legacy billing systems to the Azure cloud, modernizing infrastructure, and optimizing performance for scalability. The role also includes supporting production environments, troubleshooting critical issues, and deploying emergency patches to maintain system reliability and uptime. The ideal candidate is an initiative-taker who can quickly understand complex applications, propose innovative solutions, and drive implementation across both development and operational efforts. **Location** This role is designated as a fully remote position within the United States. **The Main Responsibilities** + Collaborate with developers, testers, and product owners to design, develop, test, and support new software features and enhancements for billing systems. + Design and implement scalable technical solutions to support new product launches and ensure continuity of billing operations. + Collaborate with cross-functional teams to analyze business needs and translate them into clear, actionable technical requirements. + Develop into and serve as a subject matter expert (SME) for billing applications, processes, and system integrations. + Develop and maintain automated tests, including test case creation and implementation of testing frameworks to ensure software quality. + Write unit tests, troubleshoot integration issues, and deploy emergency patches to resolve critical billing system incidents. Deliver high-performance systems that meet or exceed defined Service Level Agreements (SLAs) for performance and reliability. + Manage multiple development tasks and projects simultaneously, prioritizing effectively to meet deadlines and business needs. Contribute to cloud migration and modernization efforts for billing applications, with a focus on scalability and maintainability. **What We Look For in a Candidate** **Required Qualifications:** + 6+ years of experience with a bachelor's degree or equivalent education and experience (Computer Science or similar preferred); 4+ years with a master's degree. + Strong understanding of software development methodologies, coding standards, and best practices. + Hands-on experience with Agile methodologies, including sprint planning, backlog grooming, daily standups, and retrospectives. + 5+ years of development experience with programming languages such as C# and SQL. Proficient in web development using ASP.NET Core, Angular, and Blazor. + Skilled in relational database management (MSSQL, Oracle), including writing complex queries, stored procedures, and designing database objects. + Familiar with structured data formats such as XSD, XML, JSON, and YAML. + Experience with version control systems like TFS, Git, or SVN. Proficient in designing and consuming RESTful APIs. **Preferred Qualifications:** + Understanding of security best practices in application and data development. + Experience building scalable, high-performance systems for processing large volumes of data. + Self-motivated, detail-oriented, and highly organized, with a strong sense of ownership. + Quick to learn and adapt to new technologies and tools. Excellent problem-solving, time management, and communication skills (both written and verbal). + Exposure to cloud platforms, especially Microsoft Azure, is highly desirable. + Experience with DevOps practices and CI/CD pipelines is a plus. + Experience in the telecommunications industry is a plus. **Compensation** This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors. Location Based Pay Ranges: $103,711 - $138,281 in these states: AL, AR, AZ, FL, GA, IA, ID, IN, KS, KY, LA, ME, MO, MS, MT, ND, NE, NM, OH, OK, PA, SC, SD, TN, UT, VT, WI, WV, and WY. $108,896 - $145,195 in these states: CO, HI, MI, MN, NC, NH, NV, OR, and RI. $114,082 - $152,109 in these states: AK, CA, CT, DC, DE, IL, MA, MD, NJ, NY, TX, VA, and WA. Lumen offers a comprehensive package featuring a broad range of Health, Life, Voluntary Lifestyle benefits and other perks that enhance your physical, mental, emotional and financial wellbeing. We're able to answer any additional questions you may have about our bonus structure (short-term incentives, long-term incentives and/or sales compensation) as you move through the selection process. Learn more about Lumen's: + Benefits (**************************************************** + Bonus Structure \#LI-Remote \#LI-VK1 Requisition #: 340922 **Background Screening** If you are selected for a position, there will be a background screen, which may include checks for criminal records and/or motor vehicle reports and/or drug screening, depending on the position requirements. For more information on these checks, please refer to the Post Offer section of our FAQ page (************************************* . Job-related concerns identified during the background screening may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. **Equal Employment Opportunities** We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, gender expression, marital status, family status, pregnancy, or other legally protected status (collectively, "protected statuses"). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training. **Disclaimer** The job responsibilities described above indicate the general nature and level of work performed by employees within this classification. It is not intended to include a comprehensive inventory of all duties and responsibilities for this job. Job duties and responsibilities are subject to change based on evolving business needs and conditions. In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information. Please be advised that Lumen does not require any form of payment from job applicants during the recruitment process. All legitimate job openings will be posted on our official website or communicated through official company email addresses. If you encounter any job offers that request payment in exchange for employment at Lumen, they are not for employment with us, but may relate to another company with a similar name.

Each day U.S. Customs and Border Protection (CBP) oversees the massive flow of people, capital, and products that enter and depart the United States via air, land, sea, and cyberspace. The volume and complexity of both physical and virtual border crossings require the application of solutions to promote efficient trade and travel. Further, effective solutions help CBP ensure the movement of people, capital, and products is legal, safe, and secure. CBP seeks capable, qualified, and versatile SME Data Engineers to help develop complex data analytical solutions for law enforcement personnel to assess risk of potential threats entering the country. Responsibilities include, but are not limited to: Design, develop, and maintain scalable data pipelines and architectures to support data extraction, transformation, and loading (ETL/ELT) processes. Utilize strong SQL skills to perform complex data transformations and optimize database queries, ensuring high performance and efficiency. Building comprehensive datasets by aggregating data sourced from various relational databases, facilitating data analysts and data scientists in creating machine learning models, reports, and dashboards. Collaborate with cross-functional teams (data analysts, data scientists, and business stakeholders) to understand business requirements and translate them into technical solutions. Assist with the implementation of data migration/pipelines from on-prem to cloud/non-relational storage platforms. Leverage distributed computing frameworks like Apache Spark to process large volumes of data efficiently. Utilizing data analysis, problem-solving, investigative, and creative thinking skills to handle extremely large datasets, transforming them into various formats for diverse analytical products. Respond to data queries/analysis requests from various groups within an organization. Create and publish regularly scheduled and/or ad hoc reports as needed. Troubleshoot data-related issues, identify root causes, and implement solutions to ensure data integrity and accuracy. Implement best practices for data governance, security, and quality supporting the core business applications. Responsible for data engineering source code control using GitLab. Basic Qualifications: Experience with relational databases and knowledge of query tools and/or BI tools like Power BI or OBIEE and data analysis tools. Extensive experience with SQL and proficiency in writing complex queries. Solid understanding of data warehousing concepts and platforms such as Oracle and cloud-based solutions. Strong experience in automating ETL jobs via UNIX/LINUX shell scripts and CRON jobs. Demonstrate a strong practical understanding of data warehousing from a production relational database environment. Strong experience using analytic functions within Oracle or similar tools within non-relational (MongoDB, Cassandra etc.) database systems. Strong understanding of distributed computing principles and experience with frameworks like Apache Spark Hands-on-experience with data lake architectures and technologies in a cloud environment. Experience with Atlassian suite of tools such as Jira and Confluence Knowledge of Continuous Integration & Continuous Development tools (CI/CD) Must be able to multitask efficiently and progressively and work comfortably in an ever-changing data environment. Must work well in a team environment as well as independently. Excellent verbal/written communication and problem-solving skills; ability to communicate information to a variety of groups at different technical skill levels. Preferred Qualifications: 5+ years of experience in developing, maintaining, and optimizing complex Oracle PL/SQL packages to aggregate transactional data for consumption by data science/machine learning applications. 10+ years of experience in working in data engineering, with a focus on building and optimizing data pipelines and architectures. Must have full life cycle experience in design, development, deployment, and monitoring. Experience with one or more relational database systems such as Oracle, MySQL, Postgres, SQL server, with heavy emphasis on Oracle. Extensive experience with cloud platforms (e.g. AWS, Google Cloud, etc) and cloud based ETL/ELT tools. Experience with Amazon services such as S3, Redshift, EMR and Scala. Experience with migrating on-prem legacy database objects and data to the Amazon S3 cloud environment. Experience or familiarity with data science/machine learning and development experience for supervised and unsupervised learning with structure and unstructured datasets. Certifications in relevant technologies (e.g. AWS Certified Big Data, Google Professional Data Engineer) are a plus.

An IFS Developer is responsible for designing, developing, customizing, and maintaining solutions within the IFS Applications ERP ecosystem. This technical role requires a deep understanding of business processes as well as strong programming and analytical skills. The developer collaborates with cross-functional teams-including IT, business analysts, and end users-to deliver scalable ERP enhancements that improve business efficiency and innovation. Duties & Responsibilities: Solution Development: Design, develop, and implement customizations, integrations, and extensions within IFS Applications using relevant programming languages and tools such as PL/SQL, IFS Report Designer, and web technologies. System Analysis: Analyze business requirements in collaboration with stakeholders to translate them into effective technical solutions within IFS. Application Support: Provide day-to-day support for IFS Applications, troubleshooting issues, resolving incidents, and ensuring optimal system performance. Enhancements & Upgrades: Lead or participate in projects related to system upgrades, new module implementations, and process improvements. Creation of Custom Pages, Fields, Menus, Tabs and Events. Use Citrix Build Place/Harvest to deploy changes. Base Server Development, Forms Development, Integration Development, Reports Development, Data Migration, Custom Objects, Lobbies, Configurations, User Administration and IAL in IFS. Integration: Develop and maintain integrations between IFS Applications and other business systems using web services, REST/SOAP APIs, and third-party middleware. Documentation: Create and maintain comprehensive technical documentation, including solution designs, modification/change logs, and user guides. Preserve changes in Visual Studio. Quality Assurance: Perform unit testing, participate in user acceptance testing, and ensure all delivered solutions meet business requirements and quality standards. Collaboration: Work closely with business analysts, project managers, and end users to understand business processes and support continuous improvement. Security & Compliance: Implement and monitor system security and ensure solutions comply with relevant data protection and business continuity standards. Training: Deliver training sessions, workshops, or user support as needed to help internal teams maximize their use of IFS Applications. Qualifications & Requirements: Education: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. Technical Proficiency: Experience with IFS Applications ERP, IFS Developer Studio, SQL, PL/SQL, PowerShell and web technologies such as HTML, JavaScript, and XML. Proficiency in Visual Studio. Experience in Oracle database objects: Procedures, Functions, Packages, Triggers, Cursors, Tables, Views, DB links and Complex queries Business Process Knowledge: Familiarity with core business processes such as finance, supply chain, manufacturing, part management, sales, and CRM as they relate to ERP functionality. Problem-Solving: Strong analytical and troubleshooting skills with the ability to resolve complex technical issues. Project Management: Experience managing or working within software development projects, including meeting deadlines and coordinating with multiple stakeholders. Communication: Excellent verbal and written communication skills for effective collaboration and documentation. Adaptability: Ability to quickly learn new technologies and adjust to changing business requirements. Attention to Detail: Commitment to delivering high-quality work and ensuring accuracy in coding, testing, and documentation. At least 5 years of development experience supporting IFS ERP Applications IFS Certification: Formal certification in IFS Applications or related modules. ERP Implementation Experience: Prior involvement in full-cycle ERP implementations, upgrades, or migrations. Integration Expertise: Hands-on experience integrating IFS Applications with other ERP systems or cloud-based solutions. Reporting Tools: Experience with IFS Business Analytics, SSRS, Crystal Reports, and Power BI reporting platforms. Software Development Life Cycle right from inception, requirement specifications, planning, design, testing, implementation, and maintenance. Experience with Microsoft SharePoint Online, Power Apps, and Power Automate (Flow) Practical experience with Microsoft Office Suite (Access, Excel, Outlook, Word) Schedule: Fulltime Standard office hours with flextime Ideally located in PLP's Corporate office - 660 Beta Drive Benefits: 401(k) with a company match equal to 25% of the first 8% of pre-tax dollars contributed by the employee for the first two years Enrollment in company profit sharing after two years Medical, dental & vision insurance, including free preventative care Wellness & Employee Assistance Program (EAP) Health care flexible spending accounts, health savings accounts, & life insurance Paid time off, paid company holidays, and vacation purchase program Short & long-term disability Parental & family leave; military leave Inclusive & welcoming company culture Career development & tuition assistance Student loan debt repayment program Click here for additional information

Job Details Strongsville OH - Strongsville, OH Information TechnologyDescription The Sr. Data Engineer is responsible for the strategic design of data architecture systems. Their job is to optimize databases, develop ETL solutions, and manage automatized data flow. Sr. Data Engineer will supervise database content and vouch for data quality. This position will function as a technical leader, making sure that the data architecture under your watch is secure and sustainable. You will work together with other teams on developing various data integration strategies. The Sr. Data Engineer will work directly with our IT Data Analytics partners to implement the next generation of data visualization and insights. At UHM, we understand diversity comes in many different forms. It's our commitment to improve inclusion in the workplace through programs and policies that establish a positive and inclusive environment where every Partner, regardless of their background, can grow and excel. We value diversity, educate on equity, and create inclusive partner opportunities to ensure that you know #UBelongAtUHM! ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned. Lead designing of all aspects of our data solution including artifact creation such as diagrams and other technical documents Build consensus around solutions where possible and give direction when needed\ Work closely with the Enterprise Data Warehouse Manager and team leads to implement a modern data and analytics platform. Partner with various business partners and technology leaders to translate program requirements into scalable technical solutions and system designs Work with technology teams to prototype and prove the viability of solutions Facilitate planning for production implementation of solutions Research, understand, and socialize new technology trends and products Provide leadership and expertise in the development of standards, architectural governance, design patterns, and practices Research and evaluate capability with other systems, alternative solutions and recommend the most efficient and cost-effective solution for system design Advises on mechanisms for delivering solutions that demonstrate effective business-IT alignment Provide testing and production support as necessary Maintain a detailed knowledge of the business' current technology and infrastructure, marketplace changes, and client processes Determine tools and strategies to address business problems through modeling and understanding key business processes and impact of technology on business processes Participate in all aspects of Scrum, including but not limited to daily stand-ups, estimation meetings, demos, and retrospectives Provide guidance and training to other team members in the form of feedback, lunch and learns, and day to day mentoring All other duties as assigned Qualifications EDUCATION AND/OR EXPERIENCE Bachelor's Degree in Computer Science, Data Analytics, or related field 8+ years of experience architecting, designing, developing, and maintaining large scale cloud data solutions 5+ years of SQL experience developing stored procedures, functions and other database objects 5+ years of ETL/ELT development experience, including the ingestion of real-time data 5+ years working with Azure cloud solutions. 3+ years working with Python in a data engineering role. Experience with Lakehouse Architecture. Databricks experience preferred. Expertise working with structured, semi-structured and unstructured data Expertise in Data Architecture, Data Profiling, Data Modeling, and Data Quality concepts Experience driving technical ideas and communicating clearly with technical as well as non-technical audiences Experience implementing enterprise data management processes, procedures, and decision support Proven experience designing database objects for OLAP and OLTP SKILLS Passion for data and analytics with a willingness to learn and adapt new technologies Familiarity with data visualization tools Excellent problem-solving skills Detail oriented with the ability to exercise sound judgment Self-motivated individual with excellent written and verbal communication skills Ability to take ownership of a project and manage multiple tasks simultaneously to meet established deadlines. A willingness to work both independently and in a team-oriented environment. Ability to coach and mentor other engineers on the team. This employer participates in E-Verify. If hired, the employer will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. Union Home Mortgage Corp. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

An IFS Developer is responsible for designing, developing, customizing, and maintaining solutions within the IFS Applications ERP ecosystem. This technical role requires a deep understanding of business processes as well as strong programming and analytical skills. The developer collaborates with cross-functional teams-including IT, business analysts, and end users-to deliver scalable ERP enhancements that improve business efficiency and innovation. Duties & Responsibilities: Solution Development: Design, develop, and implement customizations, integrations, and extensions within IFS Applications using relevant programming languages and tools such as PL/SQL, IFS Report Designer, and web technologies. System Analysis: Analyze business requirements in collaboration with stakeholders to translate them into effective technical solutions within IFS. Application Support: Provide day-to-day support for IFS Applications, troubleshooting issues, resolving incidents, and ensuring optimal system performance. Enhancements & Upgrades: Lead or participate in projects related to system upgrades, new module implementations, and process improvements. Creation of Custom Pages, Fields, Menus, Tabs and Events. Use Citrix Build Place/Harvest to deploy changes. Base Server Development, Forms Development, Integration Development, Reports Development, Data Migration, Custom Objects, Lobbies, Configurations, User Administration and IAL in IFS. Integration: Develop and maintain integrations between IFS Applications and other business systems using web services, REST/SOAP APIs, and third-party middleware. Documentation: Create and maintain comprehensive technical documentation, including solution designs, modification/change logs, and user guides. Preserve changes in Visual Studio. Quality Assurance: Perform unit testing, participate in user acceptance testing, and ensure all delivered solutions meet business requirements and quality standards. Collaboration: Work closely with business analysts, project managers, and end users to understand business processes and support continuous improvement. Security & Compliance: Implement and monitor system security and ensure solutions comply with relevant data protection and business continuity standards. Training: Deliver training sessions, workshops, or user support as needed to help internal teams maximize their use of IFS Applications. Qualifications & Requirements: Education: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. Technical Proficiency: Experience with IFS Applications ERP, IFS Developer Studio, SQL, PL/SQL, PowerShell and web technologies such as HTML, JavaScript, and XML. Proficiency in Visual Studio. Experience in Oracle database objects: Procedures, Functions, Packages, Triggers, Cursors, Tables, Views, DB links and Complex queries Business Process Knowledge: Familiarity with core business processes such as finance, supply chain, manufacturing, part management, sales, and CRM as they relate to ERP functionality. Problem-Solving: Strong analytical and troubleshooting skills with the ability to resolve complex technical issues. Project Management: Experience managing or working within software development projects, including meeting deadlines and coordinating with multiple stakeholders. Communication: Excellent verbal and written communication skills for effective collaboration and documentation. Adaptability: Ability to quickly learn new technologies and adjust to changing business requirements. Attention to Detail: Commitment to delivering high-quality work and ensuring accuracy in coding, testing, and documentation. At least 5 years of development experience supporting IFS ERP Applications IFS Certification: Formal certification in IFS Applications or related modules. ERP Implementation Experience: Prior involvement in full-cycle ERP implementations, upgrades, or migrations. Integration Expertise: Hands-on experience integrating IFS Applications with other ERP systems or cloud-based solutions. Reporting Tools: Experience with IFS Business Analytics, SSRS, Crystal Reports, and Power BI reporting platforms. Software Development Life Cycle right from inception, requirement specifications, planning, design, testing, implementation, and maintenance. Experience with Microsoft SharePoint Online, Power Apps, and Power Automate (Flow) Practical experience with Microsoft Office Suite (Access, Excel, Outlook, Word) Schedule: Fulltime Standard office hours with flextime Ideally located in PLP's Corporate office - 660 Beta Drive Benefits: 401(k) with a company match equal to 25% of the first 8% of pre-tax dollars contributed by the employee for the first two years Enrollment in company profit sharing after two years Medical, dental & vision insurance, including free preventative care Wellness & Employee Assistance Program (EAP) Health care flexible spending accounts, health savings accounts, & life insurance Paid time off, paid company holidays, and vacation purchase program Short & long-term disability Parental & family leave; military leave Inclusive & welcoming company culture Career development & tuition assistance Student loan debt repayment program Click here for additional information