Technogen International Company
SQL Server Data Engineer
Technogen International Company, Alpharetta, GA
SQL Server Data Engineer to join our growing team of Data platform management. The candidate will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. Possess a high level of energy and passion about data and processes, a self-starter being able to hit the ground running and comfortable supporting the data needs of multiple teams, systems and products.
Responsibilities:
• Data acquisition and ingestion - Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx. Data sources including but not limited to SQL Server, GCP, SAP, Teradata, Hadoop\Hive, PostgreSQL, Oracle and flat files.
• Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.
• Expertise in GCP and BigQuery data transformation and View/assets creation.
• Assist in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.
• Create and optimize data models to support various business applications.
• Reviewing modifications of existing data systems for cross-compatibility.
• Automate and support workflows to ensure timely delivery.
Must Have:
• 5+ years of SQL Server development experience.
• 3+ years in GCP BigQuery with DataFlow, Data Form, DataStudio and Looker.
• 5+ years data modeling experience.
• 5+ years of ETL experience.
• 5+ years of experience in working on more than one database technologies Microsoft SQL server, Teradata or GCP BQ.
• 2+ years big data experience, Hadoop, Hive, Spark
• Expert knowledge of data warehousing.
DESIRED SKILLS:
BI Lifecycle management
Data Lifecycle
ETL Development
Working understanding of Microsoft VBA, HTML, Python
PowerBI/Tableau/Looker Experience.
Data model development using ERWIN
Responsibilities:
• Data acquisition and ingestion - Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx. Data sources including but not limited to SQL Server, GCP, SAP, Teradata, Hadoop\Hive, PostgreSQL, Oracle and flat files.
• Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.
• Expertise in GCP and BigQuery data transformation and View/assets creation.
• Assist in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.
• Create and optimize data models to support various business applications.
• Reviewing modifications of existing data systems for cross-compatibility.
• Automate and support workflows to ensure timely delivery.
Must Have:
• 5+ years of SQL Server development experience.
• 3+ years in GCP BigQuery with DataFlow, Data Form, DataStudio and Looker.
• 5+ years data modeling experience.
• 5+ years of ETL experience.
• 5+ years of experience in working on more than one database technologies Microsoft SQL server, Teradata or GCP BQ.
• 2+ years big data experience, Hadoop, Hive, Spark
• Expert knowledge of data warehousing.
DESIRED SKILLS:
BI Lifecycle management
Data Lifecycle
ETL Development
Working understanding of Microsoft VBA, HTML, Python
PowerBI/Tableau/Looker Experience.
Data model development using ERWIN