Job Title: Data Analysts
Job Location: Mechanicsburg, PA
Duration: 12 Months
Job Description:
The Department of Corrections is seeking a skilled Data Warehouse, ETL, Business Intelligence Developer and API Developer for staff augmentation. This hybrid position requires the candidate to work onsite one day a week at 1920 Technology Parkway, Mechanicsburg, PA 17050, with potential changes to onsite requirements.
Responsibilities:
- Optimize, develop, and maintain integration solutions using SQL Server SSIS and ETL Framework (BIDS) for connecting legacy data stores to the data warehouse.
- Develop, maintain, and optimize all aspects of the Data Warehouse (SSIS, stored procedures, views, etc.).
- Create data warehouse components following best practice methodologies.
- Document data flow and transformations through various layers.
- Perform data conversion from OLTP to DW using tools such as SSIS/Data Factory.
- Identify and analyze data discrepancies and quality issues, ensuring data consistency and integrity.
- Ensure stability and high performance of existing ETL processes.
- Troubleshoot complex data-related issues and provide production support.
- Develop and deploy ETL job workflows with reliable error/exception handling and rollback mechanisms.
- Must have experience with SQL Server Reporting Services (SSRS).
- Power BI experience is preferred.
- Experience with Crystal Reports is beneficial.
- API development experience is preferred.
- May be involved in manual testing.
- Perform other related duties as required.
Required Skills:
- Education: 4-year college degree or equivalent technical study, with advanced study preferred.
- ETL Experience: 6+ years, including SSIS or other ETL tools.
- Data Analytics Experience: 6+ years.
- Data Warehouse Knowledge: 6+ years.
- MS SQL Reporting Server (SSRS): 4+ years.
- Power BI: 3+ years.
- Web API Development: 3+ years.
Warm Regards,
Mohammad Uman
Sr- Technical Recruiter
Cell: +1 2019871977, Ext: 520 | Email: [email protected]
linkedin.com/in/md-uman-8076b01b5
1260 Centennial Ave Suite 1A, Piscataway, NJ 08854
Emonics LLC – A Great Place to Work | www.emonics.com
For any suggestion or feedback, please contact Sudhir Panigrahi ([email protected])
‘The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.emonics.com’ ** To unsubscribe from emails, please send email to [email protected]