SQL & BI Reporting Analyst

Published date Posted on Indeed on Jan 14, 2022 (9 d ago)

Who We Are:

Transcard is a fintech company that specializes in providing innovative cloud-based payment solutions to financial institutions, corporations, and governments throughout the U.S. Its funds disbursement and managing platform take the regulatory, time, and cost burdens off the payer, while providing payees secure, self-service options for receiving their money.

At Transcard we believe payments should be personalized for recipients and stress-free for businesses. Through our proprietary platform, Paynuver; clients can easily create secure cards and/or online payment accounts that disburses funds to any payee in a streamlined, compliant manner, ultimately saving time and cost.

Position Details:

This is a full-time position, working Monday-Friday during standard business hours. Compensation will be based on the qualifications of applicant.

Location: This is a REMOTE opportunity with preference in US or UK. We are unable to offer visa sponsorship.

Our corporate office in located in Chattanooga, TN.

Benefits:

Transcard offers benefits starting the first of the month following the month of hire (Medical, Dental, & Vision, 401k Match!, Paid Time Off, Life-Disability Insurance, and more)

Please apply and see more job requisitions at:

https://www.transcard.com/careers

Essential Duties and Responsibilities:

Our Power BI reporting suite is the central channel through which we communicate operational performance results and metrics back to our bank and institutional clients who use Transcard’s payment services. Maintaining high accuracy of reported information and being responsive to client requests for new reports (or changes to existing) is key to Transcard’s success.

We are looking for a highly motivated candidate with in-depth expertise in SQL and Power BI for reporting (data normalization/table design) and excellent communications skills to develop and amend reports on our Power BI reporting suite. You will be fully supported as you learn our data structure and business processes and ramp up to this responsibility.

  • Create new reports. Maintain, optimize, improve existing reports, research the underlying data (i.e., financial transactions being reported) and answer questions on reported metrics
  • Research data availability for new report requests, model the tables in our reporting data warehouse and create stored procedures to populate this new data
  • Ad hoc data analysis to support reporting
  • Function as the central point of contact for all requests and questions regarding our Power BI reporting suite. Own all aspects of reporting – collect client specifications, research data availability, design the report-data layer, set up SQL scripts/stored procedures to populate the data layer & finally construct the new report or modify an existing Power BI report
  • Address client concerns about reported metrics, perform research on the data and troubleshoot issues
  • Perform integrity checks using visual means and by developing SQL scripts/alerts to confirm that the reporting backend data warehouse (Azure SQL database) is accurately reflecting transactions captured in the production database (SQL Server)
  • Identify opportunities for improvement, streamline content to reduce redundancy of multiple reports on the same metric. Identify and eliminate reports that have outlived their original purposes
  • Create documentation of the SQL jobs & stored procedures that are used to prepare data for existing reports
  • Create logical table structures to enable reporting. Work with the database administrator to create the physical tables in the reporting data warehouse. Develop stored procedures to refresh/update such report-layer tables
  • Ad hoc analysis and list pulls: Using your knowledge of our databases and complex SQL table joins, perform list extracts and data analysis for internal and external clients

Required Qualifications:

  • 4+ years of experience with hands-on SQL experience. SQL querying expertise is a core requirement for succeeding in this role
  • 2+ years of experience in data modeling for reporting purposes – organizing the data, creating relationships between tables etc., with an end goal of providing business intelligence/reporting
  • 3+ years of experience as a BI/reporting analyst.
  • Prior experience with Power BI is required
  • Excellent communication skills and an ability to positively collaborate with a non-technical audience
  • A customer service/customer-first mindset is essential as interacting with report consumers & troubleshooting (or providing clarity to) their issues is a big part of this role.

Education and/or Experience:

Bachelor's degree preferred or equivalent work experience

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be a complete list of duties performed.

No resumes from 3rd party vendors will be accepted at this time.


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

There can be a lot of pressure that comes with a new year. New workout routine, new goals, and if you’re here reading this, perhaps a new job. Oh, and apparently a new variant. Take a second away from your gym selfie-filled Instagram feed and hear us out: Being in the beaut

General Dynamics Information Technology General Dynamics Information... |
|
2 d ago

Travel Required: NonePublic Trust: BI Full 6C (T4)Requisition Type: RegularGDIT, a Federal marketplace leader in next-generation IT solutions and services, is seeking highly qualified and motivated IT professionals like you who are eager to contribute to our critical Homeland Sec

Nelnet is a student loan servicer that's grown into a fiber internet pioneer, real estate investor, and software provider. But that's just the beginning. With 6,500 associates and growing, we take our business wherever superior customer experiences and ingenuity are needed.The pe

Aspect Software Aspect Software |
|
3 d ago

Alvaria employs a team of passionate individuals who are changing the face of customer engagement. Over our 40-year history we have empowered employees by creating an inspired community that values Urgency, Accountability and Results. Our ability to think big has enabled us to co

Piper Companies Piper Companies |
|
5 d ago

Piper Companies is seeking a Manager of Data Engineering for a growing technology driven organization. The Manager of Data Engineering role is a 100% remote role that can reside anywhere in the United States. The Manager of Data Engineering will be working with a team primarily b

Application Database AdministratorWhat We Offer YOU!401(k)Paid HolidaysLife InsurancePaid Time Off (PTO)Medical, Dental, VisionLong and Short-Term DisabilityAnd More!Location: RemotePrimary ResponsibilitiesProvide SQL infrastructure engineering to include database architecture ma

More jobs by this company

Transcard Payments Transcard Payments |
2 d ago

Who We Are:Transcard is a fintech company that specializes in providing innovative cloud-based payment solutions to financial institutions, corporations, and governments throughout the U.S. Its funds disbursement and managing platform take the regulatory, time, and cost burdens o

Transcard Payments Transcard Payments |
8 d ago

Who We Are:Transcard is a fintech company that specializes in providing innovative cloud-based payment solutions to financial institutions, corporations, and governments throughout the U.S. Its funds disbursement and managing platform take the regulatory, time, and cost burdens o