Secaucus
Job Title: Data Architect – BI Technology Location: Secaucus, NJ Department: IT, BI Technology Reports To: Manager, BI Technology W2 Contract Rate $55/hr on W2 Position Summary We are seeking a highly skilled Data Architect to lead the design, development, and optimization of our retail data ecosystem. This role will be instrumental in shaping our data strategy, enabling advanced analytics, and supporting business intelligence across finance, merchandising, supply chain, marketing, and customer experience domains. The ideal candidate will have deep expertise in cloud data platforms (Snowflake), data transformation tools (DBT), and business intelligence platforms like MicroStrategy, Power BI with a strong understanding of medallion architecture principles to support scalable and trusted data delivery. Key Responsibilities Architect and implement scalable, secure, and high-performance data solutions using Snowflake and DBT. Design and maintain a medallion architecture (Bronze, Silver, Gold layers) to support structured data ingestion, transformation, and consumption across the organization. Develop modular and reusable DBT models aligned with medallion layer principles to ensure data quality, lineage, and business logic consistency. Collaborate with business stakeholders to understand data requirements and translate them into technical solutions. Establish data governance practices including data quality, lineage, and metadata management. Optimize data pipelines for performance and cost-efficiency in a cloud-native environment. Direct experience with dimensional modeling (Star/Snowflake). Lead data integration efforts across internal systems (ERP, POS, CRM) and external sources (vendors, third-party APIs). Support and enhance reporting and analytics capabilities ensuring alignment with data architecture and semantic layer design. Ensure metric consistency across BI tools (MicroStrategy, Power BI). Mentor data engineers and analysts on best practices in data modeling, transformation, and documentation. Architect data solutions supporting core retail use cases including inventory optimization, sales performance, promotions, pricing, and omnichannel customer analytics. Stay current with emerging technologies and trends in data architecture and retail analytics. Required Qualifications Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field. 5+ years of experience in data architecture or data engineering roles. Proven experience with Snowflake, DBT, and SQL. Strong understanding of ETL/ELT processes, data warehousing, and cloud data platforms. Experience designing and implementing medallion architecture in a modern data stack. Strong background in documenting historical processes and designing future workflow documentation. Hands-on experience with MicroStrategy, including schema design, dashboard development, and performance tuning. Familiarity with CI/CD pipelines, version control (Git), and agile development practices. Excellent communication and stakeholder management skills. Preferred Qualifications Experience with tools like Talend, Fivetran, Airflow, Looker, or Power BI. Knowledge of Python or dbt macros for advanced transformations. Advanced knowledge of Snowflake Data Engineering & Optimization. Understanding of data privacy regulations (e.g., GDPR, CCPA) and compliance in retail. Experience with real-time data streaming and event-driven architectures. Why Join Us? Be part of a data-driven transformation in a dynamic retail environment. Work with cutting-edge tools and cloud technologies. Collaborate with cross-functional teams to drive impactful business decisions. Competitive compensation, benefits, and career growth opportunities. About Cygnus Professionals, Inc. Cygnus is a Princeton, NJ-headquartered global Business IT consulting and software Services firm with offices in the USA and Asia. Cygnus offers and enables innovation and helps our clients accelerate time to market & grow their business. Over 15 years, we have taken great pride in continuing our deep relationships with our clients. Cygnus Belief We believe in our commitment to diversity & inclusion. Equal Employment Opportunity Statement Cygnus is an Equal Opportunity Employer. We ensure that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All our employment decisions are taken without looking into age, race, creed, color, religion, sex, nationality, disability status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other aspects of employment protected by federal, state, or local law. Applicants for employment in the US must have valid work authorization. For further information about CYGNUS, please visit our website ___