Reporting and Advanced Analytics Developer


San Diego, California

a month ago

Similar Jobs

Job Description

Job Title: Reporting and Advanced Analytics Developer
Duration: 12+ Months
Location: San Diego, CA

Top 5 Required Skills
1. Tableau – Dashboarding and governance
2. Python - Scripting
3. Redshift – Databases
4. Data Modelling
5. SQL
Technologies (specific tools and/or programs you would want to see on their resumes)
Education Requirement
  • Bachelors minimum
Min Required Years of Experience – 3
Job Description:
  • This position is for a Reporting and Advanced Analytics developer with a focus on Supply Chain and Finance projects and a potential for engagements with other business units.
  • Designs, develops, modifies, debugs and evaluates programs for functional areas, including but not limited to finance, human resources, manufacturing and marketing. Analyzes existing programs or formulates logic for new systems, devises logic procedures, prepares flowcharting, performs coding and tests/debugs programs. Develops conversion and system implementation plans. Prepares and obtains approval of system and programming documentation. Recommends changes in development, maintenance and system standards. Trains users in conversion and implementation of system. The responsibilities of this role include:
  • Working under some supervision.
  • Making decisions that are moderate in impact; errors may have relatively minor financial impact or effect on projects, operations, or customer relationships; errors may require involvement beyond immediate work group to correct.
  • Requires verbal and written communication skills to convey information that may be somewhat complex to others who may have limited knowledge of the subject in question.
  • Most tasks require multiple steps that can be performed in various orders; some planning and prioritization must occur to complete the tasks effectively; mistakes may result in some rework.
  • Deductive and inductive problem solving is required; multiple approaches may be taken/necessary to solve the problem; often information is missing or incomplete; intermediate data analysis/interpretation skills may be required.
  • Exercising creativity to draft original documents, imagery, or work products within established guidelines.
Principal Duties & Responsibilities
  • Unit tests own code to verify stability and functionality
  • Communicates with project lead via email and direct conversation to make recommendations about overcoming impending obstacles.
  • Gathers, integrates, and interprets information from a variety of sources in order to troubleshoot issues and find solutions.
  • Resolves standard software issues and bugs.
  • Adapts to significant changes and setbacks in order to manage pressure and meet deadlines independently.
  • Participates in code reviews on project team's submitted solutions.
  • Writes code for small features or minor bug fixes to support collaboration with other engineers.
  • Anticipates complex issues and discusses within and outside of project team to maintain open communication.
  • Manages individual project priorities, deadlines, and deliverables with minimal supervision.
  • Collaborates with other Analysts to complete assigned coding tasks to specifications without significant errors or bugs.
  • Determines which work tasks are most important for self and junior personnel, manages distractions, and independently deals with setbacks in a timely manner.
  • Executes against current technology roadmap.
IT Core Competencies
  • Accountability - Hold one’s self and others accountable for measurable quality, timely and cost-effective results, and accepts responsibility for impacts to the business and changes to business processes.
  • Adaptability - Adjusting own behaviors to work efficiently and effectively in light of new information, changing situations and/or different environments.
  • Collaboration - Fosters working together by establishing, communicating, and reinforcing shared values, norms, and objectives.
  • Communication - The ability to effectively exchange information with stakeholders in addition to the ability to accurately hear and understand the partially expressed thoughts, feelings, and concerns of others.
  • Financial Acumen - Ability to understand in-depth financial information that can be used to make meaningful insights to drive business growth in a safe and transparent environment.
  • Influence - The ability to accomplish goals through others.
  • People Development - Models and creates an environment that promotes career development.
  • Strategic Focus - Applies a comprehensive approach using business acumen and industry research to solve systematic complexities that promote growth.
Additional Competencies (All competencies below are required upon entry)
  • Algorithm Knowledge - Basic understanding of algorithms and how they can be used.
  • Analytical Skills - The ability to collect information and identify fundamental patterns/trends in simple to moderately complex data. This includes the ability to gather, integrate, and interpret information from several sources.
  • Application Knowledge - Familiarity with various applications (e.g. Oracle, Cloud).
  • Database Knowledge - Knowledge of components, structure, and approaches for storing, managing, and accessing data. This includes the ability to develop simple data structures and queries.
  • Documentation - The ability to document solutions to basic IT issues by using standard policies and procedures.
  • IT Knowledge - Basic understanding of IT-related content knowledge to carry out work tasks.
  • Monitoring - The ability to understand how to interpret basic data from logs in order to monitor and maintain performance and identify security issues.
  • Root Cause Analysis - The ability to understand the cause of an issue and contribute to identifying the appropriate solution.
  • Technical Troubleshooting - Knowledge of systematic approaches to solving common technical problems (e.g., hardware, software, application, operational). This includes the ability to identify problems and report and escalate problems according to established procedures, and the ability to identify available information resources for troubleshooting.
  • Time Management - The ability to quickly prioritize mission-critical from less important or trivial work activities. This includes sensing what the next most useful thing is to work on, and focusing on the critical few tasks that add value while putting aside or delaying the rest.
  • Candidate will be responsible for developing solutions in Tableau/Power BI/OAC with expertise in Advanced Visualizations including extensive experience in sourcing, processing, managing & distributing visual reports using database source for key stakeholders in data-centered environments.
  • Candidate is expected to be highly analytical and process-oriented with in-depth knowledge of Tableau, Python, SAS, Model development, Data Integration using Informatica, Data Analysis and Data Exploration, Self Service Analytics using Tableau, Alteryx, Oracle Analytics Cloud and Power BI.
  • Good understanding of business environment, excellent communication skill and ability to work in a fast environment.
  • This FTE position will take up the Reporting & Analytics activity in Supply Chain, and other Business Portfolio like Sales, Finance, HR.
  • This position acts as one of the key resources to take up the complete development activity with strong dedication & attain functional expertise & will assist the team in data delivery, data quality, etc. in all phases/cycles of business intelligence, data warehouse, and Advanced Analytics.
Preferred Qualifications
  • At least 3 years of experience with data visualizations tools such as Tableau, Oracle Analytics Cloud or Power BI.
  • Experience in Statistical knowledge to support Advanced Analytics and complex visualizations desirable.
  • Hands on experience with Python Programming Language.
  • At least 3 years of experience with Data Warehouse Design and Development using Cloud technologies like AWS Redshift and relational database like Oracle SQL and PL/SQL stored procedure.
  • Preferred experience working within the AWS environment.
  • Familiarity with different format of data files (Parquet files, JSON, Semi-Structure) and moving & managing files in Amazon S3 layer.
  • Process data into Amazon Redshift using Glue and Lambda.
  • Automate repetitive tasks within the data pipeline using Python/glue/Informatica.
  • Some experience with scheduling jobs using tools like Control-M (BMC Software).
  • Experience in Oracle ERP Applications, Supply Chain Modules, Financial modules, Order2Cash and Source2Pay modules a plus.
 Notice to California Applicants: SPECTRAFORCE® is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting

About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at:
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.

Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at if you require reasonable accommodation. 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $44.47/daily.