Signon Bonus - Database Developer (SSIS, PowerBI, Azure)

Job updated 3 months ago

Job Description

At Aperia, we rely on a dynamic database team. 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, 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.

Requirements

Technical Skills

  • Good English communication (verbal & written)
  • 3+ years’ experience with Extraction, Transformation, 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 experience with Power BI, Azure Data Factory, Azure Pipelines.
  • 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 MSSQL Server database design, 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.

Education or Certifications

  • Bachelor’s degree in Computer Science, Computer Information Systems or equivalent degree.
1
3 years of experience required
2,600 ~ 3,100 USD / month
Personal Invitation Link
This is your personal referral link for job invitation. You'll receive an email notification when someone applied for the position via your job link.
Share this job
Logo of Aperia.

About us

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.



Jobs

Full-time
Mid-Senior level
1
2.5K ~ 3K USD / month
Save

Full-time
Mid-Senior level
1
4K ~ 6K USD / month
Save