Sr. SQL Server BI Developer (Richardson, TX)

ARGO; Richardson (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Sr. SQL Server BI Developer to lead the design and development of Business Intelligence solutions. This pivotal role involves overseeing the full Software Development Life Cycle, managing a team, and ensuring effective communication with stakeholders. You'll utilize your expertise in SQL Server, T-SQL, SSIS, and SSRS to develop actionable insights that enhance client services. Join a dynamic team where your contributions will drive innovation and excellence in BI solutions, making a significant impact on the financial and healthcare sectors.

Qualifications

• Minimum 5 years of experience with Microsoft SQL Server, T-SQL, SSIS, and SSRS.
• Strong analytical and problem-solving skills with excellent communication abilities.

Responsibilities

• Lead the design and management of BI infrastructure and documentation.
• Develop and customize SSRS reports and SSIS packages for high performance.
• Collaborate with stakeholders to gather requirements and resolve issues.

Skills

T-SQL

SSIS

SSRS

Data Modeling

Analytical Skills

Problem-Solving

Communication Skills

SDLC Knowledge

Unit Testing

Performance Tuning

Education

Bachelor’s degree in Computer Science

Tools

SQL Server

Visual Studio

JIRA

Power BI

PowerShell

Job description

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.

Job Summary
The Sr. SQL Server BI Developer is a key leadership role responsible for the design, development, maintenance, and deployment of Business Intelligence solutions utilizing the SQL Server BI stack. This position not only requires technical expertise but also involves leading a team, fostering collaboration, and ensuring effective communication among stakeholders. The Sr. BI Developer will oversee the full Software Development Life Cycle (SDLC) and manage customer-facing issues, while working closely with Business Intelligence Analysts and business partners to gather requirements, translate them into actionable designs, and ensure the successful delivery of BI solutions.

Time Allocation

• BI Solution Development and Maintenance: 50%-60%
• Leadership and Team Collaboration: 15%-20%
• Requirements Gathering and Project Management: 10%-15%
• Server Management and Configuration: 5%-10%
• Testing, Debugging, and Documentation: 10%

Outcome/Value Add
The Sr. SQL Server BI Developer enhances ARGO's offerings by delivering actionable insights through advanced Business Intelligence solutions. By developing reports with SSRS and optimizing data integration with SSIS, this role ensures clients receive timely, accurate information. Performance tuning T-SQL queries contributes to improved efficiency and reliability, reinforcing ARGO’s commitment to high-quality, data-driven products and services, and maintaining a competitive edge in the market.

Expected Work and Performance (Essential Functions)
Key responsibilities include, but are not limited to:

• Lead the design and management of BI infrastructure, ensuring thorough documentation, unit testing, and adherence to best practices across ARGO’s business lines.
• Develop, debug, and customize SSRS reports and Integration Services Packages, maintaining high standards for performance and usability.
• Collaborate with business analysts and developers to define and document new and existing customer reports, enhancing system and client documentation.
• Engage with external customers and senior management to understand reporting needs and resolve issues effectively.
• Oversee the building, maintenance, and debugging of reporting infrastructure across various business applications, including Healthcare and Financial Services.
• Provide regular updates on project status to the Data Architect and Senior Business Intelligence Analyst, ensuring alignment with project goals.
• Mentor team members and assist in the creation and validation of reporting artifacts in collaboration with QA.
• Research and address code defects, providing solutions to complex challenges.
• Design, build, and test advanced SSIS data transformation packages, ensuring high-quality data processing.
• Maintain and update documentation for BI infrastructure, including technical documents for ARGO’s reports and SSIS packages.

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, SSIS, and SSRS.

Required Skills/Experience/Knowledge

• Expertise in writing complex T-SQL queries and performance tuning.
• Proficiency in SQL Server Reporting Services and Integration Services.
• Strong understanding of relational data modeling and design concepts.
• Knowledge of Software Development Life Cycle (SDLC) and experience with JIRA.
• Familiarity with deploying Visual Studio build artifacts using SQL Server deployment tools.
• Working knowledge of source control systems.
• Experience in executing unit and QA testing, including writing test scripts and cases.
• Excellent quantitative, analytical, and problem-solving skills.
• Strong written and verbal communication skills, with experience collaborating with customers on requirements and design.
• Ability to effectively translate business requirements into technical specifications.

Preferred Skills/Experience/Knowledge

• Knowledge of SQL Server administration.
• Experience with PowerShell scripting and Power BI.
• Strong knowledge of Banking/Financial or Healthcare industries.
• Basic experience with VB.NET or C# projects.

Aligning to ARGO Value Chain
In ARGO's value chain, the Sr. SQL Server BI Developer plays a vital role in transforming data into actionable insights that drive product excellence. By creating sophisticated reports and analytics, this position ensures that product performance and customer feedback are effectively captured and analyzed, facilitating continuous improvement and innovation in ARGO’s offerings.