Business Intelligence Architect

"We do not work with third-party agencies and are unable to sponsor visas, OPT, CPT, or other work authorizations. Candidates must be U.S. citizens or permanent residents." 😊 Position Overview The Data/Business Intelligence (BI) Architect is a hybrid role that combines data architecture, engineering, and business strategy. This role bridges the gap between technology and business, ensuring the data is accessible, reliable, secure, and optimized for decision-making. The Architect will design and maintain enterprise-level data solutions that support descriptive, diagnostic, predictive, and prescriptive analytics. We are seeking a senior-level resource with at least 5+ years of experience in data architecture and BI, with the ability to define technical strategies, mentor teams, and deliver scalable solutions aligned to business objectives. Key Responsibilities Stakeholder Collaboration • Partner with business and IT stakeholders to translate requirements into technical specifications • Identify and integrate diverse data sources into enterprise architecture. Data Architecture & Modeling • Architect scalable, secure, and efficient data platforms (data warehouses, lakes, marts) • Design conceptual, logical, and physical data models to meet analytics needs. Tools & Platform Selection • Evaluate, recommend, and implement tools aligned with business and technical requirements. • Support BI and visualization platforms that enable data-driven decision-making. ETL / ELT Development • Design, develop, and maintain data pipelines, integrations, and ETL/ELT processes • Ensure efficient movement and transformation of data across systems. Data Catalog & Metadata Management • Create and maintain an enterprise data catalog with automated metadata integration. • Establish data dictionaries, tagging standards, and documentation practices Data Governance & Discovery • Enforce governance policies for quality, security, and compliance. • Enable self-service analytics through curated and organized data assets. Performance Optimization • Monitor, troubleshoot, and optimize BI systems and pipelines for cost, speed, and reliability. Technical Leadership • Provide guidance, establish best practices, and mentor teams across the organization. Qualifications • 5+ years of experience in data architecture, BI solutions, and analytics platforms. • Proven experience designing solutions for enterprise data platforms (data warehouses, lakes, marts). • Strong data modeling skills (conceptual, logical, physical). • Hands-on experience with ETL/ELT tools and pipeline development. • Knowledge of data governance, metadata, and catalog management. • Strong analytical, problem-solving, and leadership skills. • Excellent communication and stakeholder engagement abilities. • Ability to be on-site at least two days per week. Technical Environment (Preferred, Not Required to Know All) Data Platforms: Data warehousing & lakes, dimensional modeling, cloud services (AWS Redshift, S3, RDS, Azure Data Lake Storage, Synapse Analytics, BigQuery, Databricks, Snowflake, Informatica) Databases: SQL Server, Oracle, PostgreSQL, MongoDB BI Tools: Power BI, Tableau, Business Objects, Crystal Reports, Looker ETL/ELT: AWS Glue, Azure Data Factory, Google Cloud Dataflow, Fivetran, Talend, dbt Big Data: Hadoop, Spark, Kafka Programming / APIs: SQL, Python, R, XML; ML/DL with TensorFlow, PyTorch, Scikit-learn, Keras Modeling Tools: MS Visio, ER/Studio, PowerDesigner Source Systems: On-premises, Cloud, and SaaS integrations