ARGO is a leading provider of software and analytics solutions for both the financial services and healthcare industries. ARGO transforms business processes for financial service providers and healthcare organizations using proven business models and software innovation informed by real customer challenges, breakthrough technology, and rich analytics.
SQL SERVER BI DEVELOPER
Job Summary
The SQL Server BI Developer is responsible for designing, developing, maintaining, troubleshooting and deploying BI solutions built using the SQL Server BI stack. This role is also responsible for managing customer-facing issues and incidents within their assigned areas. The SQL Server BI developer works under the guidance of the Business Intelligence Analyst Sr and collaborates with business analysts and customers to gather requirements, translate them into technical specifications, and ensure the successful delivery of BI solutions.
TIME ALLOCATION
- BI Solution Development and Maintenance: 50%-60%
- Customer Support: 15%-20%
- Requirements gathering, project management, collaboration: 10%-15%
- Server Management and Configuration: 5-10%
- Testing, Debugging, and Documentation: 10%
OUTCOME/VALUE ADD
The SQL Server BI Developer enhances ARGO's product and service offerings by delivering actionable insights through advanced Business Intelligence solutions. Developing reports with SSRS and streamlining data integration with SSIS ensures clients receive timely, accurate information. By optimizing T-SQL queries, the role improves performance and reliability, contributing to ARGO’s commitment to high-quality, data-driven products and services, and maintaining its competitive edge.
Product Summary
ARGO is a mission-driven software company providing financial services and healthcare customers with cutting-edge technology and analytics. ARGO’s solutions require extensive expertise in both business and technology to support financial products such as Fraud Detection, Teller Payment Systems, Lending, and Omni-channel Delivery, as well as healthcare solutions including Behavioral Health, Utilization Review, Patient Identity Matching/EMR, and Patient Financing.
Expected Work And Performance (essential Functions)
Job duties and responsibilities include but are not limited to:
- Design and manage BI infrastructure, including development, documentation, unit testing of BI assets across ARGO's business lines.
- Create, debug, customize, and evaluate SSRS reports, Integration Services Packages and SQL Server databases.
- Partner with business analysts and developers to define, document, and maintain new and existing customer reports, contributing to system and client documentation.
- Interact with external customers and senior company management to address reporting needs and issues.
- Build, maintain, and debug reporting infrastructure for business applications, including Healthcare, Teller Payments, Sales & Service, Lending & Commercial Lending lines of business.
- Provide regular status reports on assigned tasks to the Data Architect and Senior Business Intelligence Analyst.
- Assist QA in creating and validating reporting artifacts and deliverables.
- Research and resolve code defects of varying complexity.
- Design, build, and test complex SSIS data transformation packages.
- Write and update documentation for BI infrastructure, including technical documents for ARGO’s reports, SSIS packages, and client-facing materials.
Qualifications
- Education: Bachelor’s degree in Computer Science, Information Technology, Information Systems, or related field.
- Experience: Minimum of 5 years of technical experience with Microsoft SQL Server, T-SQL Integration Services (SSIS) and Services (SSRS).
Required Skills/Experience/Knowledge
- Expertise in writing complex T-SQL queries.
- Expertise in SQL Server Reporting Services.
- Expertise in SQL Server Integration Services.
- Expertise in performance tuning T-SQL queries
- Strong understanding of relational data modeling principles and design concepts.
- Good understanding of SQL Server Analysis Services and OLAP/Multi-Dimensional modeling
- Good understanding of Software Development Life Cycle (SDLC) and JIRA
- Good understanding of deploying Visual Studio build artifacts using SQL Server deployment tools (rs.exe, sqlpackage, dtutil, Microsoft.AnalysisServices.Deployment)
- Working knowledge of source control systems.
- Experience in executing unit and QA testing, writing test scripts, and cases.
- Excellent quantitative, analytical, and problem-solving skills.
- Strong written and verbal communication skills.
- Experience working with customers on requirements and design.
- Ability to interpret and translate business requirements into technical specifications.
Preferred Skills/Experience/Knowledge
- Knowledge of SQL Server administration.
- Experience with PowerShell scripting.
- Experience with PowerBI.
- Strong knowledge of the Banking/Financial or Healthcare industries.
- Basic experience with VB.NET or C# projects and code.
- Light project management experience.
ALIGNING TO ARGO VALUE CHAIN
In ARGO's value chain, the SQL Server BI Developer plays a crucial role in the
Product and Customer segment by transforming data into actionable insights that drive product excellence. By creating sophisticated reports and analytics, this role ensures that product performance and customer feedback are accurately captured and analyzed. This facilitates continuous improvement and innovation in ARGO’s offerings, aligning product development with market needs and enhancing overall product value. Ultimately, this contributes to delivering superior products that meet customer expectations and supports ARGO's competitive edge in the market.
ATTENDANCE/WORK LOCATION
The position is based in our Richardson, TX office. Daily physical presence is required for interaction with co-workers, attending meetings, and project collaboration.
PHYSICAL DEMANDS
While performing the duties of this job, the employee is regularly required to stand, walk, sit, operate computer equipment, and communicate with employees and customers. The role involves exchanging accurate information, evaluating, editing, revising, updating, and providing solutions to critical issues.
DISCLAIMER
This job description does not restrict management’s right to assign or reassign duties and responsibilities at any time.
Additional Requirements
Applicants for U.S. or Canadian based positions with ARGO must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required at the time of hire. Visa sponsorship is not available at this time for ARGO positions.
Pre-employment background screening will be conducted.
Department: Software Development
This is a full time position