Statistical Programming Analyst IV

Spectraforce Technologies; Columbia (SC); On-site; USD 95,000 - 125,000; Full time

Job summary

Spectraforce Technologies in Columbia, SC seeks a Statistical Programming Analyst IV to lead the transition of SAS programs to Python on the on‑prem data warehouse, producing routine and ad hoc reports mainly in Excel, and mentoring the team through the change.

The ideal candidate has 6 years of statistical programming or interpretation, strong leadership, and hands‑on experience with Python, SAS, Snowflake or Databricks, and BI tools.

Qualifications

• Bachelor's or Master's in Statistics/Biostatistics, Mathematics, CS.
• 6 years of statistical programming or interpretation.
• Experience leading teams or projects.

Responsibilities

• Lead design, coding, maintenance of database programs for data extraction and reporting.
• Guide departmental efforts through complex statistical analyses and reporting.
• Develop project plans and lifecycle maintenance for databases.
• Create and review internal documentation and training materials.

Skills

Statistical programming

Leadership

Python programming

SAS

Data analysis

Communication

Education

Bachelor's or Master's in Statistics/Biostatistics/Mathematics/Computer Science

Tools

Snowflake

Databricks

Power BI

Tableau

Job description

Title: Statistical Programming Analyst IV

Location: Columbia, SC (Onsite first 90 days, partially onsite at manager discretion after 90 days)

Duration: 6 Months (Possible conversion to FTE)

Note:

CMS security clearance/residency requirements will apply. This role require candidates to meet residency requirements (i.e., having lived in the U.S. for three out of the past five years).

Job Summary:

The team is currently transitioning SAS programs to Python on the on premises data warehouse. We are producing both routine and ad hoc reports, primarily in Excel. The ideal candidate will need to be willing to act as lead for the team as we transition SAS code to Python. This will involve being responsive to questions and providing training when weaknesses are identified. Someone self-driven and adaptable who enjoys staying current with evolving tools will thrive in this role. Making complex data understandable for any audience. Decisive when faced with ambiguity.

Duties:

• Leads staff responsible for the design, coding, maintenance and execution of database programs for the extraction, analysis, and presentation of data for standard and ad hoc reporting.
• Initiates, designs, codes and executes complex statistical analysis programming and sophisticated statistical interpretation, compilation and verifications to guide departmental efforts. Identifies patterns and trends and prepares charts, illustrations, other graphics, and narrative reports to explain data findings.
• 25% Leads staff responsible for the design, coding, maintenance, and execution of database programs for the extraction, analysis, and presentation of data for standard and ad hoc reporting.
• Oversees creation of support documentation outlining procedures for specific projects.
• 15% Leads the development of sampling design and/or execution of methodology for sample selection.
• 15% Initiates, designs, codes and executes complex statistical analysis programming and sophisticated statistical interpretation, compilation and verifications to guide departmental efforts.
• 10% Identifies patterns and trends and prepares charts, illustrations, other graphics, and narrative reports to explain data finds.
• 10% Responsible for writing and reviewing articles for internal/external publication to support department efforts for various projects as assigned by management.
• 10% Develops project plans and system life cycle maintenance. Performs quality checks on new and existing relational database tables.
• 10% With leadership responsibilities as assigned by management, participates in development of change requests/testing plans for changes to relational database tables.
• Researches new sources of data and provides written and/or verbal feedback to management.
• Represents management in discussions.
• 5% Develops focused end-user applications.

Extensive programming skills using the following:

• Cloud based data platform: Snowflake or Databricks
• Data Visualization/Dashboard experience: Power BI or Tableau
• Data Management and Analysis: Python and SAS

Required Skills and Abilities:

• Strong customer service, organizational, analytical skills.
• Ability to use complex mathematical calculations.
• Demonstrated knowledge of mathematical or statistical concepts.
• Relevant computer programming skills.
• Excellent leadership and presentation skills.

Required Software and Other Tools:

• Microsoft Office Preferred

Skills and Abilities:

• Strong oral and written communication skills. Computer systems support knowledge.

Work Environment:

• Typical office environment. Some out of town travel.

Required Education:

• Bachelor's or Master's degree Statistics/Biostatistics, mathematics, computer science, or other job related field. Master's degree preferred!

Required Work Experience:

• 6 years statistical programming or statistical interpretation.

Preferred Work Experience:

• 8 years experience with statistical practices. 5 years statistical software and relational database experience.