Jobs
>
Magstatt-le-Bas

    Database Developer - Omaha, United States - Aperia

    Aperia
    Aperia Omaha, United States

    4 days ago

    Default job background
    Description
    Summary

    Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia's clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path.

    Job Description

    At Aperia, we rely on a dynamic team of software developers. We're seeking a Database Developer who is ready to work with new technologies and architectures in a forward-thinking organization that's always pushing boundaries. This person will have SQL development background and SSIS/ETL development experience. The ideal candidate has experience in SQL development, SSRS, SSIS, ETL, Power BI, and Azure Data Factory.

    Core Responsibilities
    • Designs, builds and implements relational databases.
    • Reviews T-SQL code and performances optimization.
    • Works closely with other members of the business analyst, database administrator and software development, and database development teams, sharing knowledge and making recommendations as needed.
    • Works with offshore development teams and reports.
    • Completes documentation on all assigned systems and databases, including business rules, logic, and processes.
    Functional Responsibilities
    • Implement a viable system that can survive and adapt changes demonstrated through delivered projects.
    • Ability to use critical thinking to solve issues that arise.
    • Ability to troubleshoot database performance issues.
    • Ability to deliver successfully tasks and projects independently and be a consultant for others.
    • Ability to do performance tuning: query optimization (avoid coding loop and correlated subqueries), applying indexes and partition functions.
    • Ability to write, debug and test stored procedures, functions, triggers.
    Technical Skills
    • 3+ years' experience with Extraction, Transformation and Loading (ETL) process using DTS/SSIS application tools.
    • 3+ years' experience with MS SQL Server 2008/2012/2017 including SQL Server Management, Integration Services, Analysis Services, and Reporting Services.
    • Hands on experienced in data modeling in all phases (conceptual, logical, and physical).
    • Hands on experienced in Transact-SQL (advanced queries, complex joins, indexes, pagination in SQL Server, TRY-CATCH blocks, CASE & PIVOT, etc.).
    • Hands on experienced in MS SQL Server database design and coding techniques work with NoSQL datatype (JSON).
    • Advanced knowledge of SSIS and Data Extraction and Transformations.
    • Hands on experienced in performing database unit tests to ensure code quality using SSDT.
    Things that will separate you from the rest
    • Practical knowledge of API and Web development.
    • Well grasp of how to connect different applications and systems together demonstrated through delivered projects.
    • Hands on experience with Power BI.
    • Knowledge of Azure Data Factory.
    Education or Certifications
    • Bachelor's degree in Computer Science, Computer Information Systems or equivalent degree.
    Eligibility Requirements
    • Must be willing to submit to a background investigation and drug test as part of the selection process.
    Job Type
    • Full-Time
    Schedule
    • Monday to Friday
    Work Location
    • Ohama, Nebraska preferred.
    Benefits
    • Health insurance
    • Health savings account
    • Dental insurance
    • Vision insurance
    • 401(k) matching
    • Life insurance
    • Paid time off
    • Parental leave
    • Disability insurance
    • Childcare assistance
    • Education reimbursement
    • Fitness membership
    • Volunteer time off
    This job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only.

    Recruiters please don't contact this job poster. DO NOT contact us with unsolicited services or offers.
  • Ender-IT

    SQL Server Developer

    6 days ago

    Ender-IT Omaha, United States

    SQL Server Developer (SSIS/ETL Developer) · Onsite in Omaha, NE · Full time position · This person will have SQL development background and SSIS/ETL development experience. The ideal candidate has experience in SQL development, SSRS, SSIS, ETL, Power BI, and Azure Data Factory. ...

  • Lutz

    Data Engineer

    1 week ago

    Lutz Omaha, United States

    Lutz Tech is an information technology firm that partners with local businesses to simplify the complex world of tech. Our team believes in saying it straight, pushing ourselves to be the best, and serving our teammates as well as our clients. · Role Summary: We are seeking a hig ...

  • Apex Systems

    Data Warehouse Engineer

    2 days ago

    Apex Systems Omaha, United States

    # Data warehouse Engineer · On-Site · 100k-130k a years · Data Warehouse and Data Governance Supervisor will, Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases and data warehouses. Create an ...

  • Creighton University

    Business Analyst II

    4 days ago

    Creighton University Omaha, United States

    · Under supervision of the Senior Director, Advancement Services, the Business Analyst II uses the alumni and donor database, correlated systems and reports to support University Relations (UR) and campus-wide staff's informational and data needs. This person elicits and synthes ...

  • Client Resources, Inc.

    Data Warehouse/Governance Supervisor

    6 days ago

    Client Resources, Inc. Omaha, United States

    Data Warehouse and Data Governance Supervisor will, Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases and data warehouses. Create and optimize data models for warehouse infrastructure and wor ...

  • Saicon

    C,/C++ Developer

    1 week ago

    Saicon Omaha, United States

    Need : C, C++ Developer · Location : Omaha. NE - · Duration : 12 + Months · • Standard Skillset Role: C, C++ Developer · • Must Have: C, C++, Oracle Tuxedo, Oracle Pro C, Oracle Pro C++, Sql, Pl/Sql, Linux, Shell Scripting · • Nice To Have: Java Swing · • Desired Profile: · • - ...

  • CyncHealth

    Data Engineer

    4 days ago

    CyncHealth Omaha, United States

    Position Summary · The Data Engineer will provide guidance on the ingestion, storage, processing, analysis, and visualization of healthcare data such as HL7v2, FHIR, and DICOM data on the AWS Cloud Platform. This includes data migrations and transformational projects. The Data E ...

  • Diverse Lynx

    SQL Server Database Lead

    4 days ago

    Diverse Lynx Omaha, United States

    SQL Server Database Lead · Hybrid - Omaha, NE · Contract Position · JD: · What are the top 3 skills required for this role? · 1. SQL server Database administration & Automation · 2. Hands on experience SQL server Database migration · 3. Team, Project & Client Management · ...

  • UnitedHealth Group

    Behavioral Health Advocate

    6 days ago

    UnitedHealth Group Omaha, United States

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel ...

  • Creighton University

    Business Analyst II

    2 weeks ago

    Creighton University Omaha, United States

    Under supervision of the Senior Director, Advancement Services, the Business Analyst II uses the alumni and donor database, correlated systems and reports to support University Relations (UR) and campus-wide staff's informational and data needs. This person elicits and synthesize ...

  • Diverse Lynx

    ROR Engineers

    6 days ago

    Diverse Lynx Omaha, United States

    Job Title: ROR Engineers · Location: Omaha, NE (Remote) · Fulltime · Mode of interview: Video Call · Note :: Require candidate to join onsite from day 1 · Competencies: Ruby on Rails · Experience (Years): 8+ yearsTo know how to write highly scalable and distributed Ruby on ...

  • Midlands Testing Services, Inc

    client relations representative

    1 week ago

    Midlands Testing Services, Inc Omaha, NE, United States

    Join our team and help keep the roads, rails, and airways safe, by ensuring our clients' employees are performing their jobs in an alcohol and drug free workplace. · We work as a team to meet the needs of our clients by connecting our certified onsite drug and alcohol subcontract ...

  • Advserv

    Business Analyst II

    1 week ago

    Advserv Omaha, United States

    Under supervision of the Senior Director, Advancement Services, the Business Analyst II uses the alumni and donor database, correlated systems and reports to support University Relations (UR) and campus-wide staff's informational and data needs. This person elicits and synthesize ...

  • HDR

    MS SQL ETL Developer

    1 week ago

    HDR Omaha, United States

    About UsAt HDR, we specialize in engineering, architecture, environmental and construction services. While we are most well-known for adding beauty and structure to communities through high-performance buildings and smart infrastructure, we provide much more than that. We create ...

  • Lutz

    Data Engineer

    1 day ago

    Lutz Omaha, United States

    Lutz Tech is an information technology firm that partners with local businesses to simplify the complex world of tech. Our team believes in saying it straight, pushing ourselves to be the best, and serving our teammates as well as our clients. · In order to make an application, ...

  • Lutz

    Data Engineer

    4 days ago

    Lutz Omaha, United States

    Lutz Tech is an information technology firm that partners with local businesses to simplify the complex world of tech. Our team believes in saying it straight, pushing ourselves to be the best, and serving our teammates as well as our clients. · Role Summary: We are seeking a hi ...

  • CORDOVA

    Middleware Engineer

    1 week ago

    CORDOVA Omaha, United States

    Connecting People and Technology · Middleware Engineer · We have an opportunity for a Middleware Engineer who is responsible for overseeing daily Middleware system administration and partnering with Enterprise Architects, and IT teams to manage data integration between internal a ...

  • McCarthy Building

    Marketing Coordinator

    6 days ago

    McCarthy Building Omaha, United States

    Position SummaryMcCarthy is looking for a hands-on, collaborative, and passionate Marketing Coordinator to assist our Central Region (Midwest) with a variety of marketing activities. Responsibilities will include development of qualification, proposal and presentation materials; ...

  • HDR

    MS SQL ETL Developer

    1 day ago

    HDR Omaha, United States

    About Us · At HDR, we specialize in engineering, architecture, environmental and construction services. While we are most well-known for adding beauty and structure to communities through high-performance buildings and smart infrastructure, we provide much more than that. We cre ...

  • US Tech Solutions

    GIS Lead

    1 week ago

    US Tech Solutions Omaha, United States

    Job Description: · • A key GIS technical resources and support and responsible for the spatial and tabular databases of the GIS · • oversees data automation and maintenance. · • maintain gigs hardware, software, and associated components. · • TPM for all GIS tools for union p ...