Name of position: Senior Business Systems Analyst
Location: San Francisco CA
Job Description
The Judicial Council Research, Analytics, and Data (RAD) office seeks the services of a full-time Senior Business Systems Analyst (Senior Data Specialist Analyst) consultant with reporting, collection, translation, and warehousing of Appellate Courts’ Appellate Court Case Management System (ACCMS) data.
Including analytics, data mapping to and from (ACCMS) and data integration experience to support the services provided by the Appellate Court Services to the Appellate Courts (Supreme Court and Courts of Appeal).
This position requires working with reporting software such as SAS, onboarding and supporting multiple implementations, coordinating with multi-disciplinary teams, third-party vendors, and stakeholders.
This position will also manage the migration of the current statistical analysis software tool, SAS to a more updated statistical analysis software tool—this includes reviewing available tools and making a recommendation for the migration of the data to a better suited statistical analysis software solution.
This position will also re-design existing SAS reports to Power BI reports from ACCMS for Courts of Appeal.
Minimum Job-Specific Skills/Qualifications Required (in order of relative importance):
â5+ years as a data specialist, analyzing, designing, developing and maintaining optimal data models and pipelines:
a.Analyzing and developing data models and data dictionaries for data warehouse and data analytics integration
b.Assembling large, complex data sets that meet business requirements,
c.Building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, SAS, Power BI and cloud-based technologies.
â5+ years of experience with principles and techniques of analyzing and documenting all product life cycle artifacts
such as functional requirements, business cases, project charters, communication plans, test plans, detailed functional specifications.
âPrior experience implementing large scale multi-organizational data warehousing solutions using ETL tools, Machine learning, and Data APIs
â5+ years of experience analyzing data using SAS.
â5+ years of experience analyzing data using Power BI.
â5+ years of experience in data modeling
â5+ years of programming experience in SQL
â5+ years of experience using an enterprise grade ETL/ELT product (i.e., Talend, Informatica, Oracle Data Integrator, etc.)
âStrong understanding of data classifications, data access and security
âProven track record of written and verbal communication skills, with both technical and non-technical audiences.
âExperienced working with project schedules, identifying deliverables, milestones, and timelines for assigned projects.
âConfidence explaining decisions, analyses, and recommendations to stakeholders of varying levels of seniority and digital content knowledge.
âGreat inter-personal skills, flexible can-do attitude, and drive for continuous improvement.
âAbility to assess and evaluate situations and identify creative problem-solving solutions.
âExperienced with MS Office applications including Word, Excel, Project, and Visio.
âKnowledge of digital government and digital government strategies
âAbility to communicate clearly and effectively in English, both orally and written.
Additional Skills/Qualifications Desired:
âProficient in Microsoft applications
âRecent experience within government agencies or public-sector bodies with projects of a similar type
âExperience integrating, supporting and administering Snowflake
âExperience using Talend Data Fabric, R, and Power BI
If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why
you think you are a fit.
About Us:
Since 2000, Tri-Force Consulting Services (
https://triforce-inc.com
) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.
