Search Jobs
Find your next opportunity.
Alliance of Professionals & Consultants, Inc.
https://www.apcinc.com/wp-content/uploads/2021/11/apc-squ.png
http://www.apcinc.com
http://www.apcinc.com
true
SSIS ETL Data Analyst
5171 Glenwood Ave ste 310 Raleigh, NC 27626 US
Posted: 03/18/2024
2024-03-18
2024-08-26
Industry: BI/Data
Job Number: 38356
Remote/Work From Home Jobs: Work from home flexibility
Job Description
Are you an experienced Data Analyst? If so, let’s talk!
Â
Our client is actively seeking a talented Data Analyst located in Raleigh, NC. This is a 3-month contract opportunity with the possibility to go permanent with our client.
Job Overview:
The 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.
Responsibilities:
Â
Requirements:
Â
Job Requisition # 38356
A reasonable estimate of the pay range for this role is $35.00 - $50.00 per hour.
The disclosed pay range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The compensation decisions are dependent on the facts and circumstances of each case, such as skills and experience levels.
Meet APC
Company – Staffing – 501 – 1000 employees
APC believes that the workplace should be fun and enjoyable. Join our team today and ignite your career!
Â
APC is a professional services organization focused on engaging people and positively impacting lives. As professionals serving professionals, we take pride in providing our employees with the highest level of customer service and support, creating meaningful, fulfilling and rewarding experiences every day.
APC is committed to creating a diverse work environment and is proud to be an equal opportunity employer. All qualified individuals will receive consideration for employment without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetics, or veteran status. #LI-LB1
Â
Â
Our client is actively seeking a talented Data Analyst located in Raleigh, NC. This is a 3-month contract opportunity with the possibility to go permanent with our client.
Job Overview:
The 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.
Responsibilities:
Â
- 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.
Requirements:
Â
- 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.
- Work experience across all phases of the software development life cycle.
- Proficient in eliciting and documenting business requirements, processes, and workflows.
- Strong oral and written communication skills.
- Exposure to data integration solutions in the Property and Casualty Insurance line of business.
Job Requisition # 38356
A reasonable estimate of the pay range for this role is $35.00 - $50.00 per hour.
The disclosed pay range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. The compensation decisions are dependent on the facts and circumstances of each case, such as skills and experience levels.
Meet APC
Company – Staffing – 501 – 1000 employees
APC believes that the workplace should be fun and enjoyable. Join our team today and ignite your career!
Â
APC is a professional services organization focused on engaging people and positively impacting lives. As professionals serving professionals, we take pride in providing our employees with the highest level of customer service and support, creating meaningful, fulfilling and rewarding experiences every day.
APC is committed to creating a diverse work environment and is proud to be an equal opportunity employer. All qualified individuals will receive consideration for employment without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetics, or veteran status. #LI-LB1
Â
Meet Your Recruiter
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Raleigh, NC
Ready to take your career to new heights? Explore our job opportunities in the vibrant area surrounding Raleigh, North Carolina. Known as the "City of Oaks," Raleigh boasts a rich tapestry of cultural experiences, including the North Carolina Museum of Art, Raleigh Little Theatre, and PNC Arena, home to the Carolina Hurricanes. Indulge in the region's renowned Southern cuisine, enjoy the bustling nightlife in downtown Raleigh, or bask in the natural beauty of William B. Umstead State Park. With a thriving job market, top-notch universities, and a diverse community, Raleigh is the perfect place to grow both personally and professionally. Dive into our listings and discover your next career adventure in this charming and dynamic region.
APC is committed to creating a diverse work environment and is proud to be an equal opportunity employer. All qualified individuals will receive consideration for employment without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetics, or veteran status. **California Consumer Protection Act
