Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele. As a Certified MBE and Woman-Owned organization, we pride ourselves on fostering global cross-cultural connections that advance both the careers of our employees and the success of our clients' businesses. At LanceSoft, our mission is clear: to leverage our global network to seamlessly connect businesses with the right talent and individuals with the right opportunities, all without bias. We believe in providing Global Workforce Solutions with a personalized, human touch. Our comprehensive range of services spans various domains, encompassing temporary and permanent staffing, Statement of Work (SOW) arrangements, payrolling, Recruitment Process Outsourcing (RPO), application design and development, program/project management, and engineering solutions. Currently, our team of over 5,000 professionals caters to 110+ enterprise clients worldwide, including Fortune companies. Our client base represents a diverse spectrum of industries, including Banking & Financial Services, Semiconductor/VLSI, Technology, Healthcare & Life Sciences, Government, Telecom & Media, Retail & Distribution, Oil & Gas, and Energy & Utilities. Headquartered in Herndon, VA, LanceSoft operates 32+ regional offices across the North America, Europe, Asia, and Australia. We also have nine delivery centers strategically located in India in Bangalore, Indore, Noida, Baroda, Hyderabad, Bhubaneshwar, Dehradun, Goa, and Aligarh to further enhance our client service capabilities.

Job description

Job Title: Senior Data Analyst

Description: The candidate must have senior data analysis experience in the following:
Experience
collecting and managing birth defect data as found in the State of Ohio
applications, including but not limited to the Maternal and Child Health
Integrated Data System.

Experience
collecting and managing birth defect data from the State of Ohio
Department of Health agency via the Innovation Ohio Platform (IOP).

Experience using Impala/ANSI
SQL to select and transform data as needed. SQL experience must include
data conversion, pivots, and logical assignments.

Experience using Hue (Impala
Editor) for querying large datasets, managing SQL scripts, and creating
reusable query workflows within shared or sandbox environments.

Experience creating views or
temporary tables within a sandbox database and/or schema to facilitate
more complex queries.

Experience working with
business users to understand and document their analytics and reporting
requirements.

Experience developing complex
reports and dashboards for state and federal reporting.

Experience with all types of
testing from unit to system and user acceptance testing, developing test
cases and scenarios along with business users, reporting and tracking
defects, and triaging/resolving issues.

Experience training business
users on analytic tools and data structures.

Required profile