The Information Technology Group (ITG) Division of the National Association of Insurance Commissioners (NAIC) has an exciting opportunity for a Data Analyst II.
We are looking for a team member who would enjoy working for an organization that strives every day to support the public good and make a difference.
This position is based out of the NAIC's Kansas City, MO office. This is a full-time hybrid-remote position, in a positive and flexible environment.
Residency within 100 miles of the Kansas City, Missouri office is required, along with in-office work as scheduled.
Learn more about the general tasks related to this opportunity below, as well as required skills.
Responsibilities :
- Supports the NAIC's efforts to leverage data to assist with decision-making, reporting, analytics, and business intelligence.
- Uses data visualization software to create and publish aesthetically pleasing and informational reports / dashboards for both internal and external parties.
- Assists with the transformation of data for analytics and business intelligence.
- Assists with data cleansing to ensure the quality of data.
- Analyzes complex data sources.
- Follows NAIC accepted guidelines on version control for all technical development.
- Troubleshoots and resolves data problems as assigned. This involves utilizing SQL and other tools to assist in data manipulation.
- Is customer focused and understands customers' business requirements. Evaluates the requirements and makes recommendations.
- Extracts, cleans, transforms, aggregates, interprets large quantities of raw data for reporting.
- Utilizes many (3+) technical tools in preparing datasets for analysis. Such tools may include SQL, SQL*Loader, Excel, Python, Informatica, Tableau, Hadoop, Java, various AWS cloud products, and more.
- Accurately completes source to target data mapping, verifying accuracy through automated scripts and manual testing.
- Works with customer technical and business staff to confirm data mapping.
Education and / or experience required :
- Bachelor's degree from four-year college or university in a technology or business related field, and 3-5 years' experience.
- Advanced ability in SQL including experience with PL / SQL.
Skills and Abilities :
- Structured Query Language (SQL)
- Oracle
- PostgreSQL
- Amazon Web Services (AWS)
- Informatica (IICS)
- NoSQL (MongoDB / DynamoDB)
- Snowflake
- Extract, Transform and Load (ETL)
- Tableau
- Excel
Compensation :
$69,138 - $80,000, to be commensurate with education and experience
J-18808-Ljbffr
Data Analyst II
The Information Technology Group (ITG) Division of the National Association of Insurance Commissioners (NAIC) has an exciting opportunity for a Data Analyst II. Assists with data cleansing to ensure the quality of data. Supports the NAIC's efforts to leverage data to assist with decision-making, rep...
API and Data Migration Solution and Quality Analyst
API and Data Migration Solution and Quality Analyst. The API and Data Migration Solution and Quality Analyst is responsible for designing and executing test cases to validate the functionality and performance of APIs. Utilize Azure Service Bus and messaging queues for efficient data transfer and com...
Business Systems Analyst
Provide systems analysis, problem solving support, and necessary programming support to provide efficient and effective use of administrative information systems in support of client's goals and objectives. This is why right from the beginning; our analysts and solution-builders work closely wit...
Industrial Decarbonization Research Analyst
We are looking for an Industrial Decarbonization Research Analyst to join Energetics to deliver data-related research for industrial energy and emissions analysis to the Department of Energy (DOE)!. Ideal candidates have research and development experience related to metals, cement, chemicals, refin...
Business Analyst
Present the story of the overall business, including the digital business, business environment and trends on a regular basis to franchisees and McDonald’s employees. Complete business reviews and projects for specific segments within the business. Proactively use numbers, trends and research to dev...
Financial Analyst II
The Financial Analyst II focuses on short and long-term financial planning and or analysis of business operations for the purpose of measuring and forecasting future business performance. Provide mentorship and training to junior financial analysts in financial analysis techniques, modeling, and FP&...
API and Data Migration Solution and Quality Analyst
API and Data Migration Solution and Quality Analyst. The API and Data Migration Solution and Quality Analyst is responsible for designing and executing test cases to validate the functionality and performance of APIs. Utilize Azure Service Bus and messaging queues for efficient data transfer and com...
Workday Financials Analyst
The Workday Financials Analyst provides technical expertise necessary in the configuration, troubleshooting, and use of Workday. The Workday Financials Analyst works directly with various internal teams and vendors, to determine requirements, troubleshoot issues, and test solutions. Maintains Workda...
Research Analyst
Research Analyst, Heartland Region. The Research Analyst will support the Heartland Region by leveraging data from various sources, including JLL, to evaluate market conditions and effectively communicate the commercial real estate narrative to our brokers, clients, and prospects. Collaboration with...
Data Scientist (Healthcare)100% Remote
The Data Scientist will be responsible for driving insights from the vast amounts of patient and environmental data available within our data warehouse. Develop and implement algorithms on existing data warehouse records and identify new external data sources to be ingested to the data warehouse to ...