What are the responsibilities and job description for the SQL BI Report Developer position at Jack Henry & Associates, Inc.?
Our Payments Team is seeking an experienced SQL BI Report Developer to join their Data Services team. Their team's mission is to establish the long-term data strategy to provide the most innovative and efficient payment processing solutions delivered with unparalleled customer service and support. In this role, you will be providing backend support utilizing your exceptional SQL to enhance, modernize and create reports that are vital to our organization and clients. We have flexible hours and are a team of A-players who give 100%, but also know the importance of recharging and allowing time for the people we care most about. You can join us in any Jack Henry office location but you're free to work remotely within the United States.
What you'll be responsible for:
- Provides analysis, design and development utilizing SQL. Debugs and resolves data errors.
- Proficient in SQL toolsets to manage extraction of data from source systems, data mapping into a Data Lake and fulfilling custom report requests.
- Creates reports and dashboards using the appropriate BI toolsets.
- Provides guidance on business analytics offerings.
- Provides second line internal and external customer support.
- Provides technical documentation as appropriate.
- Develop processes to minimize data quality risks and proactively identify potential data issue.
- May serve in an on-call rotation to cover issues and requests during non-traditional business hours.
What you'll need to have:
- Minimum of 5 years of experience of SQL Report Development.
- Experience with MS Excel, VB Script, and Excel Macros.
- Must be able to work after hours and weekends as the business need dictates.
What would be nice for you to have:
- Proven ability to analyze and troubleshoot complex problems and make recommendations for remediation.
- Experience with developing with MySQL in a Cloud-based platform - preferably AWS.
- Working knowledge of Data Lake concepts.
- Strong skills in at least two of the following: PowerShell, Ruby, or other scripting language.
- Advanced knowledge of dimensional and relational modeling practices.
- Strong analytical, conceptual, and problem-solving abilities.
Equal Employment Opportunity
Applicants for U.S. based positions with Jack Henry & Associates must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available for this position.
Jack Henry & Associates, Inc. is an Equal Employment Opportunity/Affirmative Action Employer and maintains a Drug-Free Workplace.
EOE-M/F/Vet/Disability