Trigyn Technologies - Fairfax, VA

posted 2 months ago

Full-time - Mid Level
Fairfax, VA
Professional, Scientific, and Technical Services

About the position

The Business Intelligence Architect/Developer position at Trigyn Technologies is a long-term contract role based in Fairfax, Virginia. This position requires candidates to be local to the Virginia, Maryland, or Washington D.C. area. The ideal candidate will be well-versed in Business Intelligence (BI) and data analysis software systems and concepts. The role demands a strong technical background in data analysis, business intelligence, and data science, with a focus on defining and documenting requirements, including data flows and diagrams. The Architect/Developer will provide application analysis and data modeling design support to effectively collect and distribute data. This includes assisting with query and reporting analysis to access data warehouses and archives. The candidate must be proficient in working with data at all stages of processing, including Extract, Transform, Load (ETL), denormalization, and data cleansing. A solid understanding of various data stores, databases, data warehouses, and data lake houses is essential. Additionally, the candidate should be familiar with a range of software tools, including but not limited to SQL Server Integration Services, Azure Data Factory, Microsoft SQL Server Reporting Services, Data Studio, and Databricks. Proficiency in working with various programming languages and data formats such as Parquet and JSON is also required. Knowledge of machine learning modeling and AI prompt engineering will be beneficial. The role involves working in environments with multiple data systems and facilitating data sharing between these systems.

Responsibilities

  • Define and document requirements including data flows and diagrams.
  • Provide application analysis and data modeling design support.
  • Assist with query and reporting analysis to access data warehouses and archives.
  • Work with data in all stages of processing including ETL, denormalization, and data cleansing.
  • Collaborate with various data stores, databases, data warehouses, and data lake houses.
  • Utilize software tools such as SQL Server Integration Services, Azure Data Factory, and Microsoft SQL Server Reporting Services.
  • Work with programming languages and data formats such as Parquet and JSON.
  • Implement machine learning modeling and AI prompt engineering as needed.
  • Facilitate data sharing between multiple data systems.

Requirements

  • Strong technical experience in data analysis, business intelligence, and/or data science.
  • Ability to define and document requirements, including data flows and diagrams.
  • Experience with application analysis and data modeling design support.
  • Proficiency in ETL processes, denormalization, and data cleansing.
  • Understanding of various data stores, databases, data warehouses, and data lake houses.
  • Familiarity with SQL Server Integration Services, Azure Data Factory, and Microsoft SQL Server Reporting Services.
  • Experience with programming languages and data formats such as Parquet and JSON.
  • Knowledge of machine learning modeling and AI prompt engineering.

Nice-to-haves

  • Experience with Microsoft Azure, AWS, and Google Cloud.
  • Familiarity with Apache/Spark, Elastic, R, Power BI, Databricks, SAS, Snowflake, and Teradata.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service