TruConnect is on a mission to bridge the digital divide in the United States by delivering premium wireless services to underserved communities. We have connected millions of Americans over the past decade and experiencing substantial growth as the government places significant resources to help bridge the digital divide. The ideal candidate is an excellent communicator, well-organized, creative, empathetic, and proactive. You build trust & strong relationships at all levels. You are confident and can influence without formal authority, pushing back when appropriate. You earn respect and respect contributions of others. DUTIES AND RESPONSIBILITIES: Demonstrable experience of using relational databases and Cloud Data environments via writing performant queries in SQL against multi-terabyte and billion row datasets in AWS Redshift/Spectrum, MS SQL, and MySQL Transform data-based observations and insights into hypotheses through analytical rigor, leading to use cases that will confirm or deny those hypotheses and ultimately improve the quality of data Demonstrate critical thinking around business rules and logic especially as it pertains to compensation models and other analytic models Design appropriate data structures by gathering data from primary and secondary sources for reporting consumption Troubleshoot, research, and identify discrepancies specifically around data such as inventory, compensation, claims/reimbursements, general sales activity, and other such related data Identify, analyze, and interpret trends or patterns in complex data sets Create structured data marts for current and historical reporting Detail oriented and deadline driven to meet monthly filing deadlines Assist in data governance, meta data management and quality control of the completeness and accuracy of data Work with end users to follow through with associated action items and execute in a timely manner Design and document process and data flows for establishing data pipelines to support detailed analyses and accuracy in reporting Present analyses, translate findings in the data into solutions, and perform root cause analysis in a concise manner which is easy to interpret and understand KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED: Bachelor’s degree is required. A degree in economics, finance, computer science, statistics, or other data related field preferred Experience working with ETL tools such as Matillion, AWS Glue, SSIS, etc. Working knowledge of BI reporting tools such as Tableau or similar tools Strong product development mindset and focus on actionable analytics Ability to clearly communicate with cross functional teams Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy Translate business requirements into technical requirements Work with business stakeholders to assess potential risks Minimum of 2 years of BI/reporting/data analysis experience Detail-oriented with excellent organizational skills Analyze problems and provide automated solutions whenever possible Working knowledge and experience with Agile/Scrum methodology and iterative practices in a service delivery lifecycle Experience with online collaboration tools such as Slack, JIRA, or MS Teams is a plus Consistent demonstration of organization, prioritization, self-motivation, and problem resolution skills Ability to navigate between multiple projects, meet deadlines, and process ad hoc requests Ability to deal with ambiguity and influence change in a rapidly changing business environment Great interpersonal and communication skills and the ability to provide insights to support key business decision making MUST be able to work from the Los Angeles Office 3-4 days/week NO VISA SPONSORSHIP BENEFITS: 401(k) matching Medical insurance, including PPO & HSA Dental insurance Vision insurance Flexible Spending Account(s) Free Life & Long-Term Disability Insurance Free Identity Theft Protection & Travel Assistance Access to corporate discount program Flexible schedule Paid time off (sick, bereavement, and Flex PTO) Parental leave