Data Analytics Engineer
Share
Job Location:
Jacksonville, FL - USA
Monthly Salary:
Not Disclosed
Posted on:
16 hours ago
Vacancies:
1 Vacancy
Job Summary
ARC Group has an immediate opportunity for a SQL Data Engineer! This is starting out as a 12 month contract position with potential to extend longer or possibly convert to FTE. The position is hybrid with a couple of days per week onsite in Jacksonville FL. This is a fantastic opportunity to join a dynamic and well-respected organization offering tremendous career growth potential.
Reference # 19409-1
Hybrid role in Jacksonville FL
SQL Data Engineer Onsite (JACKSONVILLE FL)
Ideal Candidate Profile
A Senior Data Engineer/Developer with:
Advanced SQL & Data Warehousing Expertise
NO H1B EAD GC EAD Please.
Job Description:
Must-Have Skills:
- Writinghighly complex SQL queries(joins across large fact tables window functions performance tuning)
- Designing and optimizingStar/Snowflake schemas
- Experience with:
- IBM Netezza (Preferred)
- Microsoft SQL Server
- Oracle Database
- Handlinglarge-scale batch processing(10TB datasets preferred)
- Nightly claims or transactional processing pipelines
- Indexing partitioning query performance optimization
Core Skills:
Writing complex SQL queries for ELT/ETL pipelines in Netezza (preferred) or similar RDBMS (SQL Server Oracle).
Designing optimized data models (fact/dimension tables) for analytics.
Handling high-volume batch jobs (e.g. nightly claims processing).
Tools: Netezza SQL Server SSIS or similar ETL tools.
Unix/Linux Scripting for Automation.
Automating data pipelines (e.g. cron jobs error handling file transfers).
Example: Scripted daily data ingestion for 10TB healthcare datasets using Bash.
Stored Procedure Development.
Building reusable efficient stored procedures for data transformations and batch workflows.
Example: Created stored procedures to automate provider data aggregation reducing runtime by 30%.
MVC Code Integration.
Collaborating with application teams to MVC applications (C# ) to the data warehouse via APIs or direct SQL calls.
Example: Integrated a member analytics dashboard (built in MVC) with Netezza via stored procedures.
Healthcare Data Experience (Nice-to-Have)
Familiarity with healthcare datasets (claims EHR HL7) and compliance (HIPAA PHI).
Understanding of healthcare analytics use cases (risk modeling population health).
Interested
Email your most updated resume toSureshatemailprotected or apply online and explore other opportunities at.ARC Group is aForbes-ranked top 20 recruiting and executive search firm connecting top technical talent with clients nationwide. We pride ourselves on understanding both candidates and clients goals and serving both with integrity and excellence.
ARC Group is anequal opportunity workplace committed to building a diverse workforce.
Required Experience:
Senior IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Are you struggling with finding qualified employees? Contact American Recruiting & Consulting to learn how we can help with job recruitment specific to your industry.
