Job Overview: We are seeking a skilled Business Intelligence Architect/Developer with strong technical experience in data analysis, business intelligence, and data science. The ideal candidate should be proficient in defining and documenting data requirements, designing data flows and diagrams, and providing application analysis and data modeling support. This role involves working with data throughout all stages of processing, including ETL, data cleansing, and denormalization, as well as working with various data stores, databases, and data warehouses. The candidate should have experience with business intelligence and data analysis tools, and be comfortable working in complex data environments with multiple data systems.Responsibilities:Design, develop, and maintain business intelligence and data analysis solutions.Define and document data requirements, data flows, and diagrams.Provide application analysis and data modeling support to collect, organize, and distribute data.Perform query and reporting analysis to access data warehouses and archives.Manage data throughout all stages of processing, including ETL, denormalization, and data cleansing.Work with a variety of data stores, databases, data warehouses, and data lake houses.Utilize business intelligence tools such as SQL Server Integration Services, Azure Data Factory, and Microsoft SQL Server Reporting Services.Develop machine learning models and utilize AI prompt engineering.Collaborate with various teams to facilitate data sharing between multiple systems and environments.Required Skills:Proficiency in SQL, data modeling, and data analysis.Experience with ETL processes, data cleansing, and data normalization.Knowledge of data warehouses, data lake houses, and various data storage formats (e.g., parquet, JSON).Experience with business intelligence tools such as Power BI, Databricks, Snowflake, Teradata, and Microsoft SQL Server.Familiarity with cloud platforms such as Microsoft Azure, AWS, and Google Cloud.Understanding of machine learning modeling and AI prompt engineering.Strong problem-solving and analytical skills.Qualifications:Bachelor’s degree in Data Science, Computer Science, Information Technology, or a related field.2-4 years of experience in business intelligence, data analysis, or data science.Certification in business intelligence or data analysis tools is a plus.Experience with multiple data systems and complex data environments is preferred.