46 Data Analyst Jobs in Raleigh, NC
TEKsystems is Hiring a Data Analyst Near Raleigh, NC
This Data Analyst will work closely with IT development staff and business representatives to analyze requirements and develop ETL processes for transferring data across multiple platforms. They will be responsible for writing and optimizing SQL queries to support corporate reporting. Additionally, this position will play a vital role in the lifecycle of various applications, including creating data mappings, building data migration processes, and designing databases for transactional data models, data warehouses, and data marts
This client is a private, non-profit organization protecting the interests of farm and rural families across North Carolina. This client is the largest domestic property and casualty insurance company in the state. This company is owned and controlled by our policyholders through an elected Board of Directors. With a network of agents located throughout the state, they now provide insurance for farm and non-farm policyholders alike in all 100 counties of North Carolina. They have over $1.8 billion in assets, write over $1 billion of premium annually, and hold an A.M. Best Company, Inc. rating of A (excellent).
Team
Responsible for all the policy information related to claim, billing and policy. If there is new development work in the IT department, this team creates the database for them. If a new application is designed or an enhancement within an existing application is created and they need new capabilities to store new data, this team is responsible for it. This team is responsible for reporting, dashboard creation and ETL processes.
The teams dashboard is used for marketing folks (customer and claims departments). They use this data to evaluate KPI’s for the companies goal (ex: how many new policies to create compared to previous years) and managers use this to see how close/how far they are from their goals.
- Collaborate with business and development teams to analyze and resolve data and process issues.
- Troubleshoot and optimize SQL queries for enhanced performance.
- Design and develop ETL processes to transfer data from various platforms to meet business
- requirements.
- Work with Senior Staff to develop logical data models (LDM) and physical data models (PDM) supporting
- operational databases, Data Warehouses, and BI applications.
- Develop and maintain reports across the entire business, ensuring data integrity.
- Monitor day-to-day batch jobs, communicate and troubleshoot issues related to data integrity, database
- design, and software tools.
- Draft and maintain job flows, data flows, and design documentation
etl, Sql database, data modeling, sql, data analysis, data, reporting
Top Skills Details
etl,Sql database,data modeling
Additional Skills & Qualifications
- A four-year degree with courses in Computer Science or Information Systems.
- Minimum of three years' experience in a development or analysis role in an enterprise setting.
- Ability to work in a team environment, meet deadlines, and handle multiple tasks independently without supervision. Demonstrated strong organization and time management skills.
- Expertise in building and optimizing complex SQL queries for improved performance.
- Strong knowledge of ETL concepts, methodologies, and best practices.
- Develop, maintain, and administer complex ETL processes using SQL Server SSIS.
- Proficiency in Visual Studio and SQL Server Reporting Services for report development.
- Solid understanding of Relational Database Design and Data Warehousing methodologies and best practices.
- Experience with data modeling tools such as Power Designer.
- Two days WFH (Friday and any other day, your choice)
- Flexible work hours (ex: 10 hours per day, 1 day off or 9 hours per day with ½ day off)
- Regular onsite M-F
Intermediate Level
About TEKsystems
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Job Summary
Part Time
Business Services
$91k-118k (estimate)
06/23/2024
07/21/2024
teksystems.com
HANOVER, MD
1,000 - 3,000
1983
Private
JAY ALVATHER
$3B - $5B
Business Services
Related Companies
About TEKsystems
TEKsystems is an IT consulting firm that offers DevOps, cloud enablement, data analytics and cybersecurity services to businesses.
The following is the career advancement route for Data Analyst positions, which can be used as a reference in future career path planning. As a Data Analyst, it can be promoted into senior positions as a Data Analyst IV that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Data Analyst. You can explore the career advancement for a Data Analyst below and select your interested title to get hiring information.
If you are interested in becoming a Data Analyst, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a Data Analyst for your reference.
Step 1: Understand the job description and responsibilities of an Accountant.
Quotes from people on Data Analyst job description and responsibilities
A data analyst also helps the business use the present data to make better business decisions and deliver better services to consumers.
12/10/2021: Lynchburg, VA
Their role will be like to work on collaborative, multidisciplinary teams with leaders where they can review and analyze data and to develop the presentation for the data consumption across the organization.
02/10/2022: Temple, TX
Data analysts work constantly with stakeholders, fellow colleagues and data suppliers, so good communication skills are essential.
12/21/2021: New London, CT
Many data analysts are required to create presentations of their findings to share with stakeholders and other key members of an organization.
12/24/2021: Alamogordo, NM
Gathered requirements, analyze data and create functional/technical specifications to functionality required by new business rules, regulations or standards change.
03/03/2022: Santa Maria, CA
Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.
Career tips from people on Data Analyst jobs
Data analysts typically work with existing data to solve defined business problems.
02/20/2022: Laramie, WY
Data analysts rely on various tools to collect and make sense of their data.
01/17/2022: Melbourne, FL
Banks and financial firms need data analysts for financial reporting and forecasting.
03/04/2022: Akron, OH
Data analysts often work directly with more senior data team members like data scientists or data engineers.
03/02/2022: Grand Forks, ND
Predictive analysis refers to a data analyst's ability to use data, machine learning and statistical algorithms to predict the likelihood of future outcomes based on previous historical data.
02/26/2022: Las Vegas, NV
Step 3: View the best colleges and universities for Data Analyst.
Similar Jobs
Popular Articles
