at Randstad US in villa park, Illinois, United States
Job Description
azure data engineer.
+ villa park , illinois
+ posted may 25, 2023
job details
summary
+ $125,000 – $145,000 per year
+ permanent
+ bachelor degree
+ category computer and mathematical occupations
+ reference1012648
job details
job summary:
Pension
Improving Healthcare
\#1 in their Industry
Hybrid – 1 day in office/week
The Data Engineer is responsible for all aspects of the design, development, security, capacity planning, delivery of data and database solutions and day-to-day operations. This position will involve working with SQL on VMs, PaaS SQL solutions, Azure data Factory, Modern Data stacks and Azure DevOps.
Ensures data recovery, maintenance, and data integrity for physical databases are met through the formulation of policies, procedures, and standards relating to database management. Provides a high degree of coordination between application development, infrastructure, and business entities to ensure effective data management as a corporate enterprise. Has willingness to work with customers of varying levels of technical expertise in a complex environment. Responsible for the definition and maintenance of the enterprise data model.
PRINCIPAL DUTIES AND RESPONSIBILITIES
- Constantly reviews overall physical database structures for data integrity, performance, recoverability and space requirement considerations.
- Effectively manage day-to-day tasks / activities in coordination with a team of developers to meet the deliverables and schedule of a data solution component within a larger application project
- Closely monitors system performance, identifies problems, and implements solutions in a timely manner.
- Researches and recommends optimal data storage solutions, publishes standards and policies, and works with development staff to standardize the environment and improve efficiency.
- Ensures work plans across assigned teams are coordinated to meet dates and expectations. Meets application team deadlines by delivering database solutions as well as completing UAT and Production promotions on time. The ability to multi-task is essential.
- Lend support to various business and technology teams as necessary during design, development and delivery to ensure solid, scalable, robust solutions.
- Serves as liaison to database vendors.
- Is responsible for the integrity of Production, Development, and User Acceptance Testing environments.
- Evaluates and recommends data storage solutions
- Rotates On-Call 24/7 support of production DBMS across the enterprise.
- Where necessary, it provides a High Availability environment utilizing Always-On, Clustering, cloud solutions, or other advanced technical database solutions.
- Provides an enterprise data model.
- Other duties as assigned.
PREFERRED KNOWLEDGE, EXPERIENCE AND SPECIAL SKILLS
- Minimum five years’ experience in information systems or equivalent, Minimum 3+ years of experience with implementing data solutions in Azure, including Azure Data Factory, Azure Data Lake Store, and other relevant services
- Administer databases with regards to efficiency, data security, user security, and system integrity
- Complete knowledge of SQL. Ability to read, write and debug T-SQL. Experience in the use of SQL for query and transaction processing in a high-performance environment.
- Experience with Modern Data Stack – Azure Data Lake, Gen2 Storage, Synapse, Databricks
- Good knowledge of ETL tools, SSIS and Azure Data Factory, experience with building pipelines in Azure Data Factory and Synapse pipelines
- Experience with building and managing Ci/Cd using Azure DevOps and GitHub
- Experience with build-tools like MSBuild or Maven
- Experience with unstructured (BIG) data is a plus.
- Experience with implementing data encryption techniques.
- Working knowledge of a programming environment (i.e..Net Framework, Entity Framework).
- Complete knowledge of enterprise relational model. Ability to see big picture to conceptualize and document creative solutions.
- Understand The Joint Commission’s business process across the enterprise Central Office systems in order to provide a cohesive enterprise-wide data model.
- Knowledge of a scripting language, preferably PowerShell, Python or JSON.
- BS, BA degree in computer science or equivalent educational background.
- Microsoft Database Administrator Associate or Azure Data Engineer Associate Certified is preferred.
- Demonstrated ability to adopt various programming techniques/languages quickly and sometimes informally.
- Make recommendations on technical solutions for management and technical staff.
- Competency in project management. Successful experience in working with end users to deliver effective and timely solutions to complex business problems.
- Excellent oral and written communication skills.
location: OAKBROOK TERRACE, Illinois
job type: Permanent
salary: $125,000 – 145,000 per year
work hours: 8am to 4pm
education: Bachelors
responsibilities:
- Constantly reviews overall physical database structures for data integrity, performance, recoverability and space requirement considerations.
- Effectively manage day-to-day tasks / activities in coordination with a team of developers to meet the deliverables and schedule of a data solution component within a larger application project
- Closely monitors system performance, identifies problems, and implements solutions in a timely manner.
- Researches and recommends optimal data storage solutions, publishes standards and policies, and works with development staff to standardize the environment and improve efficiency.
- Ensures work plans across assigned teams are coordinated to meet dates and expectations. Meets application team deadlines by delivering database solutions as well as completing UAT and Production promotions on time. The ability to multi-task is essential.
- Lend support to various business and technology teams as necessary during design, development and delivery to ensure solid, scalable, robust solutions.
- Serves as liaison to database vendors.
- Is responsible for the integrity of Production, Development, and User Acceptance Testing environments.
- Evaluates and recommends data storage solutions
- Rotates On-Call 24/7 support of production DBMS across the enterprise.
- Where necessary, it provides a High Availability environment utilizing Always-On, Clustering, cloud solutions, or other advanced technical database solutions.
- Provides an enterprise data model.
- Other duties as assigned.
qualifications:
+ Experience level: Experienced
+ Minimum 4 years of experience
+ Education: Bachelors (required)
skills:
+ Azure
+ DevOps
+ synapse
+ databricks
+ Data Factory
+ SQLEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.Pay offered to a successful candidate will be based on several factors including the candidate’s education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad’s client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for detail
