C2C position::: Database Architect- Azure
imtiaz md
KINDLY REPLY TO md.i...@genzeon.com ONLY
Genzeon established in 2009, we are a cutting-edge global digital company with focus on healthcare. Genzeon helps its clients achieve their goals by providing innovative services & solutions to reduce costs, streamline operations, improve experience, increase provider productivity, and advance patient care and satisfaction. Our culture anchors our core values – Human connection, Accountability & Empowerment.
I will be more than happy to learn and know more about your expertise, also we can discuss about the job description too. You can call or text me at 484-713-8999 & md.i...@genzeon.com
The Database Engineer will be responsible as the technical subject matter expert for the star schema design, build, testing, and deployment of our Application data into the Enterprise Data Warehouse.
Using Azure Data Factory to create data-driven workflows they will provide guidance and work in collaboration with Sr leaders and developers of both teams (EA and SE).
Additional responsibilities as indicated below.
Essential Job Functions
Data Architecture:
Responsible for database design and documentation including normalization, denormalization, schema creation, and diagram creation
Assemble large, complex data sets that meet functional / non-functional business requirements
Focus on transactional database programming for high-volume data sets in a way that ensures clean data is consistently collected while preventing database locks and performance issues
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Work with developers and stakeholders to assist with data-related technical issues and support their data development and infrastructure needs.
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure big data technologies.
Work with developers and stakeholders to assist with data-related technical issues and support their data development and infrastructure needs.
Keep our data separated and secure across national boundaries through multiple data centers and Azure regions. Run performance profiling tools to identify and then remediate inefficient code causing bottlenecks.
Review TSQL
Establish database backup/restore procedures
Assist in formalizing BCDR policies, procedures and activities for the organization
Support data governance activities for the organization
Granting database permissions as needed
Create/maintain data dictionaries
Ablity to Create and maintain optimal data pipeline architecture
Work collaboratively to write high quality, testable code that meets the Definition of Done:
Strive to meet team commitments
Participate in design and code reviews with other engineers
Actively support and contribute to end of iteration demos
Responsible for assigned integration, testing and deployment tasks
Work with product management to scope and estimate product enhancements
Experience/Required Skills
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Strong analytic skills related to working with unstructured datasets.
Ability to build ETL Pipelines in Azure Data Factory
REQUIRED
A successful history of manipulating, processing and extracting value from large, disconnected datasets.
Working knowledge of message queuing, stream processing, and highly scalable big data data stores.
Strong project management and organizational skills.
Experience supporting and working with cross-functional teams in an agile environment.
10+ years of experience in a Data Engineering role, who has BS degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field. Experience with the following tools:
SQL Server, SSIS, SQL Profiler, Tableau or PowerBI and ASP.NET is a plus
Relational SQL and NoSQL databases
Azure cloud services including Managed Instance Infrastructure
Thanks & Regards,
Md Imtiaz
Talent Acquisition Partner
P: 484-713-8999
Genzeon Corporation: 559 West Uwchlan Avenue # 120, Exton, PA 19341