SOCOM - Business Data Analyst (MacDill Air Force Base, FL)

Company Overview: Integrated Data Services (IDS) is a leading provider of custom software products and Government financial management services. IDS was founded in 1997 in El Segundo, CA, and since that time has seen tremendous growth and success. Currently IDS has offices supporting customers nationwide. By providing customers with fast, efficient and reliable information systems and support services, IDS has become a preferred provider of financial and programmatic systems, services, and solutions across a wide variety of government agencies. Position Description: IDS is seeking an ambitious self-starter to provide data analytics support for our government customers. This position will work with senior leadership to perform data extraction, cleansing, analysis, visualization and storytelling. Successful candidates will have experience analyzing data from SOCOM systems (Finance, Logistics, Personnel, Acquisition, Contracting, etc.), work well in a collaborative environment, think creatively, thrive under pressure, and be able to adjust to shifting priorities quickly. Candidates will possess effective diplomatic, time management, and oral and written communication skills. Responsibilities include, but are not limited to, the following: Gather business requirements, analyze source systems, define underlying data sources and transformation requirements, design data models, and develop metadata for data analysis and visualization Acquire and analyze data and metrics across the enterprise to learn how they can be incorporated into data visualizations and dashboards Collaborate with business areas and project teams to elicit, identify, prioritize, and document data visualization and business intelligence requirements Serve as a functional and technical data visualization and business intelligence subject matter expert Translate business analysis and business needs into prototypes concepts of reports and dashboards and contribute to design and visualization best practices Utilize business intelligence tools to take dashboard requirements and develop deliverable solutions Document data acquisition, data management and data governance processes Make and implement process improvements and efficiencies Create training materials and user guides Conduct group and one-on-one training sessions with end users Otherwise support a government financial office Knowledge and Skills: Minimum of ten (10) years of government acquisition, finance or financial management, program management or related experience within a Department of War organization. Minimum of five (5) years of hands-on experience developing, maintaining, and troubleshooting Qlik Sense applications. Strong proficiency writing and troubleshooting Qlik load scripts, including transformations, joins, concatenations, resident loads, mapping, variables, and incremental loads. Experience working with multiple data sources such as SQL databases, APIs, Excel/CSV files, and enterprise data warehouses. Advanced SQL skills, including complex queries, joins, aggregations, CTEs, subqueries, and data validation/reconciliation. Working knowledge of Qlik security/access concepts, including section access where applicable. Candidates with the following additonal experience are preferred: CCaR and/or PMRT Jira and Confluence SOCOM War Data Platform (WDP), formerly known as Advana Education and Work Experience: This position requires a Bachelor's degree from an accredited college or university in business management, engineering, computer science, mathematics, accounting, economics or other related discipline. Experience in lieu of education may be considered if the individual has thirteen (13) or more years of relevant experience. Physical & Mental Qualifications: Must be able to sit, type, hear, see, and speak for extended periods of time. Must consistently work and type on a computer for prolonged periods of time. Must be able to communicate accurate information and ideas so others will understand. Must be able to lift/carry at least 15 lbs. May be required to move about inside an office to access file cabinets, office supplies, etc. Security Clearance: Applicants selected for employment will be subject to a Federal background investigation and must meet additional eligibility requirements for access to classified information or materials. Travel: Some travel may be required. Hours: Normal work schedule hours may vary, Monday through Friday. May be required to work additional hours and/or weekends, as needed, to meet deadlines or to fulfill travel obligations. Salary Range: $115,000 - $145,000 per year The estimated salary range listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job posting and may be modified in the future. The disclosed salary range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. When determining an applicant’s compensation, various factors are taken into consideration including, but not limited to: geographic location, relevant prior work experience, relevant training, special skills/competencies, education, clearance, licenses/certifications, labor categories/contract rates and other business needs. Please note: All candidates being considered for this position will be required to complete an assessment to assess their level of knowledge with Qlik. It will assess data modeling skills, UI skills, ability to follow instructions, and attention to detail. The assessment should take between 20-30 minutes. This assessment is for evaluation purposes only and will not be used for business operations. If you require a reasonable accommodation to complete the assessment, please notify our Human Resources team in advance so we can support your request. IDS offers a robust benefits package including employer paid health, dental, vision, disability, AD&D and life insurance plans for eligible employees. IDS also offers a variety of elective plans to eligible employees including flexible spending accounts, voluntary life insurance and supplemental insurance plans. Benefits become effective the first of the month following the start date of employment unless starting on the 1st of the month, in which case benefits are effective immediately upon the eligible employee’s start date. IDS offers eligible employees eleven (11) paid holidays, generous PTO accruals starting at three (3) weeks per year, as well as a 401(k) safe harbor contribution upon eligibility. IDS also offers generous employee referral bonuses. IDS is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regards to age (40 and over), color, physical or mental disability, gender identity or expression, genetic information (including family medical history), national origin or ancestry, race, religion, sex, pregnancy (including childbirth and related medical conditions), sexual orientation, citizenship status, veteran status, uniformed service member status, or any other characteristic protected by federal, state, or local law. IDS participates in E-Verify. To learn more about E-Verify, including your rights and responsibilities, please visit A submission of a resume is an expression of interest and not considered an application. For more information, visit Disclaimer: This job description is intended to provide an overview of job responsibilities that are subject to change. **U.S. citizenship is required; H1-B visas and other visas are not being sponsored. Relocation expenses are NOT compensated. All jobs are employer paid; no fees to candidates. Third parties or agency inquiries are not being accepted at this time.** #IDS