Senior Data Architect

Verified Job On Employer Career Site

Job Summary:

Censis Technologies, Inc. is a global leader in surgical instrument tracking and asset management solutions. They are seeking a highly experienced and innovative Data Architect to lead the design and implementation of modern data solutions, leveraging technologies such as Microsoft Fabric and Power BI.

Responsibilities:

• Design and implement scalable BI and data architecture using Data Lake or Lakehouse paradigms, including medallion architecture.

• Architect and optimize ELT/ETL pipelines using SQL Server, Dataflows, and data Pipelines.

• Integrate on-premises data sources using On-prem Data Gateway (ODG) with cloud-based solutions.

• Develop a robust semantic layer and underlying data model to bridge technical data and business language, applying data virtualization principles.

• Design and optimize semantic models that represent data in a way that enhances understanding and usability for analytics.

• Build and manage data pipelines, Lakehouses, Data Lakes, and Data Warehouses in Azure or AWS.

• Manage Power BI dashboards with advanced DAX and real-time data integration.

• Implement data governance, security, and compliance best practices.

• Utilize AI-driven development and delivery to enhance solution effectiveness and efficiency.

• Define data quality checks, transformations, and cleansing rules, and work with data engineers to implement them within the semantic layer.

• Collaborate with business stakeholders to translate requirements into technical solutions and intuitive business language.

• Lead and mentor a team of BI developers, data engineers, analysts, and collaborate with data architects.

• Drive adoption of unified data platform, modern BI practices, and semantic modelling methodologies across the organization.

• Monitor and optimize data pipeline performance and troubleshoot issues.

• Ensure data quality, lineage, and availability across all reporting layers.

• Maintain comprehensive documentation of architecture, data models, workflows, and semantic layer details.

Qualifications:

Required:

• Experience: 10 years in Data & Analytics and expertise in semantic data modelling and data engineering skills.

• Strong experience with data platforms such as Snowflake, Databricks, Microsoft Fabric, or Azure Data Gateway, Azure Synapse.

• BI Tools: Working Knowledge in Power BI and integration with Microsoft Fabric is a plus.

• Data Integration: Experience with On-prem Data Gateway (ODG) and hybrid data environments.

• Data Engineering: Proficient in designing ELT/ETL processes using SQL Server, columnar data format such as Delta or Parquet and Fabric Pipelines.

• Architecture: Strong understanding of medallion architecture, data virtualization principles, cloud-based data management, and analytics technologies.

• Programming: Expertise with Python, T-SQL, Spark or other scripting languages for data transformation.

• Methodologies: Agile/Scrum project delivery experience.

• Communication: Strong verbal and written communication skills with the ability to convey complex technical data in simple business language.

Preferred:

• Certifications: Microsoft certifications in Azure, Power BI, or Fabric are a plus.

Company:

Censis Technologies is an innovative software company that specializes in surgical instrument inventory management. Founded in 2000, the company is headquartered in Franklin, Tennessee, USA, with a team of 51-200 employees. The company is currently Growth Stage.